Inconsistent results using this API_EditRecord

I have a form setup with buttons that capture the current time on a button click. It works great using both a code page or just running the code in the URL formula field. But I've found an issue that...

MikeTamoush

Qrew Commander

I tried to replicate this behavior, but could not. This is what I did:

[Set Time 1] =

var text urlToExecute =
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord &apptoken=xxxx" &
"&rid=" & [Record ID#] & "&_fid_30="&ToTimeOfDay(Now());

$URLtoExecute

[Set Time 2] =

var text urlToExecute =
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord &apptoken=xxxx" &
"&rid=" & [Record ID#] & "&_fid_31="&ToTimeOfDay(Now());

$URLtoExecute

Is this a correct test to duplicate your scenario? I didnt even have it return anywhere. Field 30 and 31 are time of day fields.

------------------------------
Mike Tamoush
------------------------------

BarryDolan

Qrew Cadet

2 years ago

I tried using Time of Day field type but I get the same behavior

------------------------------
Barry Dolan
------------------------------

Forum Discussion

Inconsistent results using this API_EditRecord