EOMDevelepors
7 years agoQrew Captain
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]
),
var text URL =
URLRoot()
& "db/" & Dbid() & "?a
=API_EditRecord&apptoken
=[token]\n &rid=" &
[Record ID#] &
"&_fid_19="&Now();
"javascript:" &
"location.reload(true);"
&
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);"
&
"});"
& "void(0);",
"javascript:alert('You
marked this as ended
working already.')")
The problem is that if the user is currently on the page a while it will not update the current time instead it will execute with original time that the record was viewed.
Thanks
Here is my current code:
If(IsNull([End Date/Time]
),
var text URL =
URLRoot()
& "db/" & Dbid() & "?a
=API_EditRecord&apptoken
=[token]\n &rid=" &
[Record ID#] &
"&_fid_19="&Now();
"javascript:" &
"location.reload(true);"
&
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);"
&
"});"
& "void(0);",
"javascript:alert('You
marked this as ended
working already.')")
The problem is that if the user is currently on the page a while it will not update the current time instead it will execute with original time that the record was viewed.
Thanks