Discussions

Expand all | Collapse all

Now() vs now easter egg

  • 1.  Now() vs now easter egg

    Posted 12-07-2020 08:53
    Edited by Mark Shnier (YQC) 23 days ago
    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
    ------------------------------


  • 2.  RE: Now() vs now easter egg

    Posted 12-07-2020 09:06
    Thanks for the info @Mark Shnier (YQC).​

    ------------------------------
    Adam Keever
    ------------------------------



  • 3.  RE: Now() vs now easter egg

    Posted 12-14-2020 12:04
    Nice!!  Thanks.

    ------------------------------
    Suzy Kania
    ------------------------------



  • 4.  RE: Now() vs now easter egg

    Posted 23 days ago
    Amazing, I was JUST about to make a post with the staleness issue. Thank you!!

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