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 127
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