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 |
---|---|
17 | |
14 | |
10 | |
7 | |
4 |