AnsweredAssumed Answered

How to have a Status field change to the default text if a related field is deleted

Question asked by najlahanderson on Dec 18, 2018
Latest reply on Dec 18, 2018 by najlahanderson



I am trying to write a database that is being used for transferring patients between hospitals. I am new to FileMaker but it has been surprisingly intuitive and easy-to-use so far!


I am getting stuck with changing the status of a case. I have written a calculation for a 'Status' field to change from the default "Active" to "Complete" once a timestamp is entered in a different area. However, if I delete the timestamp, the 'Status' field becomes empty and does not contain either "Active" or "Complete".


Should I write a script for this instead, and if so, any suggestions on how to incorporate the 'Status' field going back to the default "Active" if the timestamp is made empty again?


My calculation is:


If ( c_Date_and_Time < Get ( CurrentTimestamp ); "Complete" )