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