I have a set of URL formulas that run in a Formula -Text field when a button is clicked.
I'm invoking 2 sets of URLs in an HREF from pre-defined variables as follows:
&$URLeditlast& "&rdr=" & URLEncode($URLnew)&
The URLeditlast URL puts a stop time in on a current record, the URLnew creates a new record with a start time. This is the basis of a time tracking system
The problem is if the user leaves the page sitting idle the time doesn't' refresh.
For example, if I create my new time entry at 4:49pm and the leave the page sitting for 10 minutes then click the button to create a new entry, the times recorded is still 4:49pm, not 4:59pm.
I know if the user refreshes the page before they click the button this would solve the problem, however I do not want the user to have to do this (i have over 100 users in this quickbase all day long and there would be risk of time errors if people forget to refresh). I would like the QuickBase self-refresh when the button is clicked and then run the two URLs above to perform the actions with hopefully a refreshed time value
I've tried many things and cannot get this to work, i'm hoping someone has some ideas. Thanks!