Getting Real Time For Field
In this discussion, I will use the word timestamp in the generic sense and not with any QuickBase specific definitions. Also, this problem is happening to mobile device users. I have a form which ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou can set up an Automation triggered when the button is pushed (maybe also update a field called [Date Time Automation triggered], and it can update that record with the current date time.
Be sure to contrive it so if a person (e.g. manager) legitimately needs to edit the time, they can without the Automation overwriting it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Be sure to contrive it so if a person (e.g. manager) legitimately needs to edit the time, they can without the Automation overwriting it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thanks. That should be easy. Thanks.
Jeff Mickelsen
JPM Consulting
Sent from my iPhone
Jeff Mickelsen
JPM Consulting
Sent from my iPhone
- Because an automation always takes longer to run than a screen refresh, This will leave the field on my form named "Job Start Time" as a blank when the screen is repainted. It will hold the correct value when the screen is manually refreshed. Is there a way to delay the refresh until the automation has completed? Or to force a screen refresh from the last step of the automation?
------------------------------
Jeff Mickelsen
------------------------------- MarkShnier__YouNp,
var text URL =URLRoot() & "db/"&[_DBID_XXXXXXXX]&"?a=API_EditRecord&rid=" & [Related Order] &
"&_fid_99=" & URLEncode(Now());
// slow refresh
"javascript:" &
"$.get('" &
$URL &
"',setTimeout(function(){" &
"location.reload(true);" &
"},1000));"
& "void(0);"
// the 1000 gives a 1second delay. 1,000 milliseconds. Experiment to keep it small but enough to let the Automation complete.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- You are a genius! Thanks
------------------------------
Jeff Mickelsen
------------------------------
