Auto Text Entry
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!