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" )