Skip to main content
Question

Time Input forumula

  • February 6, 2023
  • 0 replies
  • 90 views
Forum|alt.badge.img+5
For some reason, my users are NOT fans of inputting time values on the mobile app (brings up the pop up with the dailer style window).

Is there some way that I have have them input say 2 fields (number or text whichever works) as follows...

Time:
Am / Pm

24 Hour time: (this is where I will need help with a formula to calculate the correct time from the two above fields).

Any help appreciated.

Cheers,
Damien

------------------------------
damien page
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • February 6, 2023
I totally agree.  Time entry into a free form field is wonderful as the input require is minimal.  Like 
10 means 10 am
2p mean 2 pm.  It's quite intuitive.

Obviously you know what a date field is.

Then also make a Time of Day field 

Then make a field to combine then as a formula date time field type.

ToTimeStamp([my date field], [My Time of day field])



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement