AnsweredAssumed Answered

Auto Text Entry

Question asked by DanielLaughton on Feb 6, 2014
Latest reply on Feb 7, 2014 by DanielLaughton


Auto Text Entry


     Hi There,


     Right now I am trying to create a field which will automatically enter data based on the data in another field. What I am hoping is that if another field called 'Exit Year' is empty or a specific value, the field I called 'Entry Year' will automatically put in yes. Otherwise it should select no. In the auto-calculation section I have the following formula to try and do that, but all it provide me with is an auto-entry of '0'. Here it is:
     If ( Exit Year = 13/14 ; "Yes"; "No" )  or  If ( IsEmpty ( Exit Year ) ; "Yes" ; "No" )

     I am not sure if this is how the if function works in Filemaker Pro, I am used to programming in C++, hence the confusion. If there is anyone who can help resolve this situation, I would be extremely grateful. Thanks!