Hi,

I have 2 categories of clients - “banks” and “others” – and for “banks” I have two sub-categories. I would like to mark one of these two sub-categories and “banks” should be auto-marked. I have succeeded to do this, but then I can’t mark only “banks” if there is no need to mark sub-categories… What am I doing wrong? Or this is not possible?

Thanks in advance.

When you talk about categories, do you mean you have used check boxes or radio buttons to represent the categories?

You could simply write a script to uncheck/unmark the sub categories if a certain condition is true and mark only the top banks category.

Some more details would be helpful.

If i understand you correctly, if you have a field with certain contents ( Field 1 Yes) I can a have a check box automatically checked?

Also can I use larger group (Category 200) to have these fields automatically checked? ( IF items have a category of 200, then these Field 1 will automatically be checked)?

Hi alphanitrate,

You would use an Auto-Enter on Field 1 (be sure to UNCHECK 'Do Not Replace Existing Value' with:

If ( Category = 200 ; "yourCheckboxValue" )

... where yourCheckboxValue is whatever is specified in that checkbox value list. But does that Value List contain other values as well? If so, change the calc to:

If ( Category = 200 ; "yourCheckboxValue" ; Field 1 )

It helps to have specific examples. The first example assumes only one value - it becomes a toggle and will only allow a one value or blank. The second example allows multiple values.

LaRetta

Hi alphanitrate,

LaRetta has provide a similar answer as I was going to post, but she beat me to the punch because she is a faster typist then me.

However, I was going to ask a question to clarify the answer a bit:

is the Category = 200 the only number you want this fore, or were you talking about the range of 200...300, i.e. 200, 201, 202, ... 299?

HTH

Lee

I think the main problem remains unsolved… If need to check the first “category” only (and none of the second and third), it seems that, as I turned it into an “auto-enter calc”, it wont be possible and that’s my problem.

I want that first category to be both “auto-checked” and free to check. Is it possible?

(I don’t know if I made my self clear, as my English is not as good as I’d like.)

Hi Teresa,

Sorry for answering alphanitrate's question, and while you were still needing help.

You sound like you have set up, or are wanting to have a Conditional Value List for Banks. But, your file structure is a little fuzzy to me, can you attach a sample of your file?

Lee

Hi, Lee

Here goes the sample.

Thanks.

Contactos_.zip

4-03-06 02:10 PM - Post#200710

In response to alphanitrate

Hi alphanitrate,

You would use an Auto-Enter on Field 1 (be sure to UNCHECK 'Do Not Replace Existing Value' with:

If ( Category = 200 ; "yourCheckboxValue" )

... where yourCheckboxValue is whatever is specified in that checkbox value list. But does that Value List contain other values as well? If so, change the calc to:

If ( Category = 200 ; "yourCheckboxValue" ; Field 1 )

It helps to have specific examples. The first example assumes only one value - it becomes a toggle and will only allow a one value or blank. The second example allows multiple values.

LaRetta

Hi alphanitrate,

LaRetta has provide a similar answer as I was going to post, but she beat me to the punch because she is a faster typist then me.

However, I was going to ask a question to clarify the answer a bit:

is the Category = 200 the only number you want this fore, or were you talking about the range of 200...300, i.e. 200, 201, 202, ... 299?

HTH

Lee

I thank you both for providing me help before - and i am looking for it again.

Here's the scenario - I have a list of product catagories ( 200, 300, 400 etc) i would like these catagories to activate check boxes that correspond to safety warnings. ( IE. 200 = don't eat)

Now some catagories may have multiple warnings. ( 300= don't eat, keep out of light, explosive.)

So in my layout the items would be have check boxes for all the possible warnings, but would have some prepopulated based on catagory.

I would also like to have the new checked off warnings attached to this record, but not the whole class.

Here's what i've done so far:

Set up a Checkbox set linking the catagory number from another file and the field (:BYRNUM).

Displaying values from " Warnings" value list, I tried to use LaRetta's example and have done this: Use values from field ::BYRNUM

and also tried a custom ( If BYRNUM=200;"do not eat"; Field 1)

in the field it self i get a check box

I've never used value lists before, so i'm not even sure what i did correctly .