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

    Joined:
    Feb 3, 2004
    Location:
    Upper Mid West
    #1
    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!
     
  2. pncc macrumors regular

    Joined:
    Jul 23, 2002
    #2
    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

    evil_santa

    Joined:
    Sep 23, 2003
    Location:
    London, England
    #3
    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