Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
4 years ago

Restrict date time fields to 24 hours

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
------------------------------
APIs and custom code
Buttons
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    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/
    ------------------------------