Solved: Datetime when field is filled - Page 2

School_Bus · 12-15-2021 10:18 AM

How would you go about saving the datetime when a user updates a specific field?

I tried to do isnotblank[_thisrow].[fieldtoupdate]
but it doesn’t seem to save the datetime.

Marc_Dillon

You can use the ChangeTimestamp column type.

Or if you’re like me and don’t like those “Change…” column types (for some reason), you can do something like this:

Initial Value =

IFS( ISNOTBLANK( [watch col] ) , NOW() )

Reset_on_edit =

AND( ISNOTBLANK( [watch-col] ) , [_THISROW_BEFORE].[watch-col] <> [watch-col] )