I’ve just implemented a basic time picker using this wonderful little trick: Hour picker for datetime type row - #4 by dmitry-grist . (Would really love a proper time picker, by the way).
The issue is that I’m living in a place where we use 24h time. Changing the formula for generating the choices wasn’t too difficult:
(datetime.datetime(2022, 1, 1) + datetime.timedelta(seconds=1560$Num)).strftime(“%H:%M”)
Just pasted those over into a choices column and adjusted the DateTime column formula, :
if not $Date or not $Time:
return
datetime.datetime.strptime(str($Date) + " " + $Time, “%Y-%m-%d %H:%M”)
Everything seemed fine, but on closer inspection it turns out that only the times between 00:00 and 12:15 are among the clickable choices.
The choices list in the column options is complete and if you begin typing, autocomplete works. 15:, for example, can be completed by mouse into 15:15, etc.
That’s not exactly working as intended, though. The goal was to make data entry easier for people preferring using their mouse. Missing nearly half of potential choices doesn’t meet that.
Edit: Just checked and it seems like the maximum is 50 choices. Seems a bit low, right?