Forum Discussion

EOMDevelepors's avatar
EOMDevelepors
Qrew Captain
7 years ago

Refresh time before editing record with current time using the now() method.

Can anyone help me with refreshing the time before editing a record via url formula with current time being posted to end date/time field. Here is my current code: If(IsNull([End Date/Time] ...
APIs and custom code
Formulas and functions
ScottMarks's avatar
ScottMarks
Qrew Member
7 years ago
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's avatar
ScottMarks
Qrew Member
7 years ago
Hmm actually you're right.  My mistake.  

Perhaps you could redirect to a code page that takes the rid url param, as well as dbid and use some javascript to run a call after the fact with the current time.

I think that should work, I'll see if I can setup a demo.