Forum Discussion
ScottMarks
Qrew Member
You could always have your API call redirect to ANOTHER API call that then modifies the end time with Now(). That way, no matter how long someone is on the page, the Now() is always called on the second half and is always "up to date".
//First section of your API call that changes record values n such, Now() is not included in this part..
URLRoot()&"db/"&Dbid()&"?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=xxxxxxx&<DO YOUR STUFF HERE FIRST>
//Second section which executes the NOW() function, which has been "refreshed" in a second api call.
&"&rdr="&URLRoot()&"db/"&Dbid()&"?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=xxxxxxx&_fid_19=Now()
ScottMarks
6 years agoQrew Member
That said, the action trigger method is much simpler. :^)
EDIT: And you can actually skip the JS date function, and just use "=Now()" at the end of the redirect in the code page instead of the "=" + date piece. Derp.
EDIT: And you can actually skip the JS date function, and just use "=Now()" at the end of the redirect in the code page instead of the "=" + date piece. Derp.