How to set the value of a field when modifying another?

[Faly_Rabedaoro]

Hi all,

how to set the value of a field when modifying another?
I have 4 fields, in the same table

1. [validation1]
2. [date validation 1]
3. [validation2]
4. [validation date 2]

I want [date validation 1] = today () when I fill the field or modify [validation1]
I want [date validation 2] = today () when I fill the field modify [validation2]

Help me please

[Aleksi]

Instead of using Date field, you could try to use ChangeTimestamp field. Please check this article…

help.appsheet.com

Tracking Changes Using "Change" Column Types

How to keep track of when and where data is changed in your app.

[Faly_Rabedaoro]

thank you Aleksi,
and how about if i change [date validation 1] to [user_name] ???
how to set the value of a field [user_name1] when modifying th field [validation1]?

I have 4 fields, in the same table

1. [validation1]
2. [user_name 1]
3. [validation2]
4. [user_name 2]

I want [user_name 1] = username() when I fill the field or modify [validation1]
I want [user_name 2] = username() when I fill the field modify [validation2]

[Heino_Matthee]

Reset on Edit this thread will be usefull for you

[Faly_Rabedaoro]

OK , I’ll try it.