Script to deal with Find that doesn't Find
I'm new to FMP and am working on a database that will allow me to follow patients in an intensive care unit on a daily basis. I developed a script that will carry over data from the day before to the next day but need a way to deal with what happens if there was no data from the day before. Here's the current script:
Set Variable [$date; Value: "=" & Get(CurrentDate)-1]
Perform Find [Restore] where Restore is ICU::Date [$date]
Contrain Find [Restore] where Restore is ICU::Room#  - this contrains the find to the record that was present yesterday in room 375.
This Script works find if there is a record from the day before to copy. However, if there is no record I want the script to just generate a new Record with the room number autofilled (Room 375). If that's not possible I at least want to avoid "No records match this find criteria." window that pops up.
Any help would be appreciated.