(?) Conditional function help
I wish to insert a calculation field ::Status into a patient assessment database that describes a patient as :"Active", "review if needed", "discharged" or "deceased". The "active" option is chosen if our database user reviews the patient regularly (either daily or every other day). The "review if needed" option is chosen if that patient is not seen regularly. THe other options (in a drop down menu) include discharge and death. These maybe selected when either event occurs manually.
I would like the field to read "active" when a new record is made via an Assessment Layout for that patient but also read "review if needed" if that patient's layout is not visited for say, 3 days.