Appsheet

[re0323]

Let me ask you a question.
I would like to have a column in Appsheet populated with initial values with conditions split by time.
What kind of expression should I enter in the INITIAL VALUE column?
I want to set the following condition with reference to the current time.
00:00~7:59 B
8:00~16:59 A
17:00~23:59 B

I have set the time zone in Japan.
Thank you in advance.

[TeeSee1 · Accepted solution]

timenow() < "14:04:00" <- this is TRUE if the current time is 14:03:59 and earlier on any day.

You can combine IF(), AND() and comparison operators(<,>,<=,>=) to construct an expression you want.