AnsweredAssumed Answered

Radio buttons and calculated field

Question asked by lmorris on Feb 11, 2019
Latest reply on Feb 12, 2019 by lmorris


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

Outcomes