Hi,
I am new to FileMaker and trying to find a way to determine if an ID number needs to be generated. I have radio buttons as shown below. If the user selects Filed at Large - No, then an ID number is needed, otherwise no ID is needed.
FiledatLarge is defined as Text and values from "No\Yes"
For ID, I am using the following calculated value:
Let ( D = Get ( CurrentDate ) ; Right ( Year ( D ) ; 2))&D_Nbr&"J"
For D_Nbr, I am using a serial number, generated on Commit and incremented by 1 each time.
When I tried to use IF FiledatLarge = 'No', received the following error message with IF FiledatLarge highlighted
The format for an If statement has parentheses in it like this and uses double quotes:
If( FiledatLarge = "No" ; "ID" ; "" )
Can you post the entire text of your Let statement for perusal?