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

Discussion in 'Mac Apps and Mac App Store' started by jkaz, Nov 23, 2005.

  1. jkaz macrumors 6502

    Feb 3, 2004
    Upper Mid West
    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.

  2. pncc macrumors regular

    Jul 23, 2002
    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.
  3. evil_santa macrumors 6502a


    Sep 23, 2003
    London, England
    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.

Share This Page