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.
Solved! Go to Solution.
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] )
try using the changetimestamp type:
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] )
Thanks, that did it
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |