EssenceQB_Admin
5 years agoQrew Member
URLEncode and Now() formula
I recently downloaded a Time Clock app from the Quickbase Exchange.
I modified a URL Field that I am using to allow users to set an end time for a task. The user clicks on the button to assign a log out time to a Date/Time field. The following URL works for the most part (it gets the date correct), but the times can be random. So, I am thinking, that the the URL Encode function is scrambling the time so it is not formatted correctly when it is saved. I am not even sure if this is possible.
I must need a better way to import the current date AND time into the field. The Today() seems to put the date to noon for the current date.
URLRoot() & "db/" & [_DBID_DAILY_TIME] & "?act=API_EditRecord&rid=" & URLEncode ([Record ID#]) & "&_fid_57=" & URLEncode(Now())
Does anyone have some experience with how to format a Now() date correctly when it is being passed by a URL?
Thanks in advance,
------------------------------
Ray Moss
Essence QB Admin
Essence Cabinets Inc.
Edmonton, AB, CAN
------------------------------
I modified a URL Field that I am using to allow users to set an end time for a task. The user clicks on the button to assign a log out time to a Date/Time field. The following URL works for the most part (it gets the date correct), but the times can be random. So, I am thinking, that the the URL Encode function is scrambling the time so it is not formatted correctly when it is saved. I am not even sure if this is possible.
I must need a better way to import the current date AND time into the field. The Today() seems to put the date to noon for the current date.
URLRoot() & "db/" & [_DBID_DAILY_TIME] & "?act=API_EditRecord&rid=" & URLEncode ([Record ID#]) & "&_fid_57=" & URLEncode(Now())
Does anyone have some experience with how to format a Now() date correctly when it is being passed by a URL?
Thanks in advance,
------------------------------
Ray Moss
Essence QB Admin
Essence Cabinets Inc.
Edmonton, AB, CAN
------------------------------