Update date when click save button

[Yan1]

Hey guys,

I have these two date fields which have the formula NOW().

What happens is that I need these fields to be changed only when the user clicks the Save button.

How do I do this configuration?

[AleksiAlkio]

You would need to do that with an Event action. You can find it from the form view's definitions.

[Denny774]

Hey man,

use ChangeTimestamp as the Column Field Type with no formula at all

Cheers

[AleksiAlkio]

If the user changes one of your fields and then wait for some reason, the timestamp is different than when the save button was pressed. ChangeTimestamp is built in that way 

[Yan1]

@AleksiAlkio 

Do you know how I can perform this configuration?

[AleksiAlkio · Accepted solution]

First you need to create an hidden action that writes NOW() to your DateTime column. Then open your form view's definitions and select the action to Event 
action. It will write the time every time when the record is saved.

[Yan1]

@AleksiAlkio 
It worked out!
Thanks a lot for the help

[AleksiAlkio]

You're welcome!