Is there a way I can see when a field is last changed? I want to make a conditional formatting rule based on when a separate field is changed.
Well, one way is to create a separate timestamp field that has this as an auto-enter calculation:
Case ( IsEmpty ( YourField ) ; Get ( CurrentTimestamp ) ; not IsEmpty ( YourField ) ; Get ( CurrentTimestamp ))
and set it to override its contents (i.e. uncheck the box that says, "Do not replace existing value of field (if any)"). This way, whenever the contents of "YourField" change, then the other field will reset itself to the current date and time.
There's probably a more elegant way to do it, but this will work.
I would suggest using a calculation (result is timestamp) as:
Let ( trigger = yourField ;
Get ( CurrentTimeStamp )
Because you are referencing your field within the calculation, it will automatically update the timestamp when the data in your field changes.
Thank you Mike.
I was wondering about a GET function but this was a nice solution. I try it in my FM base tomorrow.
Have a nice day
Here is almost night.
Ah, yes. Much better. Thanks.
Retrieving data ...