Hello everybody.
How can I limit the selection to just two time stamps?
Welcome to the AppSheet community.
Please make it clear as to what you mean by two timestamps.
Do you mean
1)any date and just two times?
Just two date time stamps together, meaning something like just two options โ01/01/2021 09:00:00โ and โ12/31/2021 10:00:00โ
Or anything else?
Assuming you wish to have option 1 above, it may be a better idea to separate the Datetime type column into two columns, one each for date and one for time.
in the time column you could have a valid_if expression something like LIST(โ9:30:00โ, โ17:30:00โ)
This will look like below
Also, you may find a lot of related references below that will help you in your AppSheet journey.
Yeah, thanks a lot. It is much easier with separate it in two columns.
User | Count |
---|---|
39 | |
28 | |
24 | |
24 | |
13 |