How to set a default time

[AppSheet_Lectra]

There is “Arrival Time” column in one table. Its type is “Time”. I understand that by default, user will see TIMENOW() when they enter the time. How do I set a specific time for example “09:00:00” as default value instead of TIMENOW()? Thank you.

[Aleksi]

Use “09:00:00” as the initial value.

[AppSheet_Lectra]

I tried it. But user still see TIMENOW() as default. Or I missed up any step when I set “09:00:00” as initial value? Thank you for your advice.

[Aleksi]

They are probably using an older version. If you change that in the initial value, is your app preview (From the editor) showing it as “09:00:00”?

[AppSheet_Lectra]

This is what I see.

[Aleksi]

As a note… initial value is created only when the new record is created. It doesn’t change the value automatically or when that record is opened.

[AppSheet_Lectra]

For the existing record, how to set default time like “09:00:00”?

[Aleksi]

What about the emulator preview? Does it show 09:00:00 when a new record is created?

[AppSheet_Lectra]

Yes. It shows 09:00:00 when a new record is created.

[Aleksi · Accepted solution]

If you want to reset the existing record with 09:00:00, you need to set the option “Reset on edit” to ON. Please remember that it will do that every time when the record is opened if you don’t have any formula with it.

[AppSheet_Lectra]

I tried to turn on option “Reset on edit”. This is good option for me. I just need to add a condition so that it does not reset every time the record is opened. Thank you.

[Aleksi]

You’re welcome