Discussions

 View Only
  • 1.  Now() vs now easter egg

    Posted 12-07-2020 08:53
    Edited by Mark Shnier (Your Quickbase Coach) 08-26-2021 13:20
    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 (Your Quickbase Coach).​

    ------------------------------
    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 08-25-2021 18:28
    Amazing, I was JUST about to make a post with the staleness issue. Thank you!!

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