Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6425 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

Posted

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.

  • 3 weeks later...
Posted

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)?

Posted

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. :wink2:

LaRetta

Posted

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

Posted

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.)

Posted

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

  • 1 year later...
Posted

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 (:P: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 .

This topic is 6425 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.