PachecoPrimo
asked on
Filemaker Record Modidified Field
I know you can create a TimeStamp field for record modification. Is there a way to create a field that sets to '1' if the record (any field) has been modified.
I was thinking maybe of a way of utilizing the TimeStamp field when a record is modified.
I do not want to do this using script triggers. I would like to do it using either a auto-enter field or calculation field.
I was thinking maybe of a way of utilizing the TimeStamp field when a record is modified.
I do not want to do this using script triggers. I would like to do it using either a auto-enter field or calculation field.
Will Loving
You can also create a Timestamp field for record creation, then create a calculation field that compares the Creation Timestamp with the Modification TimeStamp and yields a value of "1".
ASKER
Hi Will,
The thing is that records will be modified multiple times (for example on a daily basis, weekly basis), so the modify timestamp is going to change multiple times and this is exactly what I need to capture.
The thing is that records will be modified multiple times (for example on a daily basis, weekly basis), so the modify timestamp is going to change multiple times and this is exactly what I need to capture.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.