Filemaker Pro Notes

about the background image...

Determining the change date of a single field

Scripts: Handling 'No records found condition'

Determining the change date of a single field

Define calculated field:
FieldsToTrack [number, stored] = (IsEmpty(Field1) or IsEmpty(Field2) ... or IsEmpty(Fieldn)

LastModTime [time,stored] =
Case(FieldsToTrack,Status(CurrentTime),Status(CurrentTime))
and
LastModDate [date,stored] =
Case(FieldsToTrack,Status(CurrentDate),Status(CurrentDate))

In this example, we want the calculations involving the Status functions to be
stored - and they function as we need when they are stored.

Scripts: Handling 'No records found condition'

Set Error Capture ON
Perform Find
If Status(currentFoundCount)=0
Go to "no results" layout
Exit or halt your Script
End If
Set Error Capture OFF