Initial Value

[Steph_TAKODJOU]

Good morning all.

I created a form where I would like to display the current date and time automatically in a field when the previous field is filled.
In the field that must have the time I set the initial value to now() but it rather displays the time at which the application is launched and not the time at which the previous field is filled.
Someone can help me please?

[Yogi_Hayate]

Sorry i still don't get it.

Could you give more further information or examples? screenshoot would be great! Do you want date and time field automatically filled after you Input value specific row?

[Steph_TAKODJOU]

Exactly !!!

[Steph_TAKODJOU]

Here is my screen. I want the field which contains date automatically filled when we click on the button "Debut " But  it does not give the exact time at which we click

[Yogi_Hayate]

Ahhh, i got it, what types of data do you use to store for Debut and Fin? 

[Steph_TAKODJOU]

I use the Enum Type 

[Yogi_Hayate]

As far as i know you can't trigger that kind of action by clicking that Enum Button. Cause usually initial value keep static in form.

If you want to make a button that automatically change after clicked, how about try to make action button?

[Yogi_Hayate]

https://help.appsheet.com/en/articles/953637-actions-the-essentials 

[Steph_TAKODJOU]

That is my app 

[Joseph_Seddik]

• NOW() will display the current dateTime at the time the formula is calculated, NOT "when the application is launched.
  
  
• The formula is always calculated at row creation. 
  
  
• When the formula is in the App Formula column field, it will also recalculate on row edit and with every change to any column in the row. 
  
  
• If you want the formula to calculate only once, at row creation, instead of also every time the row is edited, then put it in Initial Value field instead. 
  
  
• If the formula is in a virtual column's App Formula field, then it will recalculate with every sync. In this case, if you don't want the dateTime value to change, then there is no meaning in putting a static value in a virtual column. 

[Steph_TAKODJOU]

Thanks 🙂

[Joseph_Seddik]

Salut @Steph_TAKODJOU,

Your column App Formula is just UTCNOW(), it doesn't have any relation with your Enum column, so why do you expect that it should change with a click on (setting the value of) the Enum column in the form? Would you pls explain? Thank you!