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 ...
Forum Discussion
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 :
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
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/
------------------------------