How to set a default time

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.

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

1 Like

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.

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”?

1 Like

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.

1 Like

image
This is what I see.

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

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

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.

1 Like

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

1 Like

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.

1 Like

You’re welcome