How can I get a dropdown with every 15 minutes of the day? I tried valid if minute() mod 15=0 in a time and enum time column and all I got was a blank dropdown.
Thatโs going to be one massive dropdown list! I started to go down that path at one point but eventually decided against it.
I think it makes for a better UI to just let the user type any time value they want, then validate the entry only if an even 15 minute interval is entered. Hereโs what I ended up doing:
https://community.appsheet.com/t/set-initial-value-of-time-column-to-nearest-15-minute-interval/1555...
Another option would be to create separate columns for [Hour] & [Minute], with dropdowns of 1-24 and 0,15,30,45. Then you can build the time value with TIME([Hour]&":"&[Minute]).
Mostly I just wanted to avoid the current way appsheet lets you select times. Having to enter in time values in a form was not the most user friendly so I guess I just need to set the defaults times to be the start and end of day. Iโm setting up a black out between X day from Y time to R day at S time for interviews that are every 15 minutes.
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |