Datetime when field is filled

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 Solved
0 3 126
1 ACCEPTED 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] )

View solution in original post

3 REPLIES 3

try using the changetimestamp type:

3X_e_3_e31d975a692b597a9d487dfc71cbb5860b88d109.png

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

Top Labels in this Space