How do I create in Filemaker: if(data in field) then (data in other field)

[jkaz]

hi, i'm trying to make my work easier.

say i have three check boxes.

a, b, and c

i want to be able to click in box 'a' and have a value automatically input into another field.


but i don't know what this type of function would be called, so i can't look it up and my tinkering hasn't turned up a result.

thanks!

 

[pncc]

hi, i'm trying to make my work easier.

say i have three check boxes.

a, b, and c

i want to be able to click in box 'a' and have a value automatically input into another field.


but i don't know what this type of function would be called, so i can't look it up and my tinkering hasn't turned up a result.

thanks!

If I am understanding you, you want the isempty operator and an if statement:

OK, so you have two fields,
-a text field called 'checkbox' set to popup menu with a value list containing a, b, c
-a calculation field called 'filled' containing this calculation:
If(IsEmpty(checkbox), "", "filled")

That's it. If checkbox is blank, so is filled. You can put limits on the possible contents of checkbox like not allow direct input only from the popup list, etc.

 

[evil_santa]

i think you are trying to do this

FMP Test File

Set up the checkbox field; a b & c, then create a value list for each check box, the filed will the show the checkbox & value, you can resize the filed to hide the value. Then set up a second field for each value; a2, b2 & c2 as a calculation, a2=a, b2=b & c2=c. you can then use either a or a2 for calculations.