Skip to main content
Question

Restrict date time fields to 24 hours

  • April 1, 2021
  • 0 replies
  • 38 views
I have 2 date time fields Check in time and check out time which are entered manually. I need to restrict users to enter the time for only the current day and not exceed a certain hour limit. 

For example: if today is 1st april, the date time field should gray out all remaining date selection or automatically display the current day. Also the time entered should not exceed more than say 24 hours.

------------------------------
Raj Helaiya
------------------------------

Have you thought about having the users select a button that auto-fills a Date/Time field instead of manually selecting the date and time? This is the basic URL I use for clocking in :


URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=########&rid=" & [Record ID#] &

"&_FID_42=now" & //this is the FID for the Start Date/Time field
"&rdr=" &

URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] )

​


------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement