Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Now() vs now easter egg

Just thought I would pass a tip along that I recently learned from a Quick Base staffer.

Whenever you use a formula URL button and are trying to populate a date time field with the current date and time on a Button click,  a problem I have always run into is that the button can get stale sitting on the screen.  
Here was my typical partial syntax.

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_154=" & Now()

But if you use this syntax, the system will stamp the date time the screen was loaded (and could be sitting there getting stale) as opposed to what you really want which is the time that the button was clicked.

But this alternative partial syntax will give you the time the button was clicked regardless of how stale the screen load is..

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_154=now"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

3 Replies

  • Nice!!  Thanks.

    ------------------------------
    Suzy Kania
    ------------------------------
  • Amazing, I was JUST about to make a post with the staleness issue. Thank you!!

    ------------------------------
    Elena Larrabee
    ------------------------------