Discussions

 View Only
  • 1.  How to Create a Save and Refresh Button

    Posted 08-08-2022 11:46
    Hi all, sort of flummoxed by this because I consider myself an advanced builder so am surprised that I can't figure out how to do this and the forums seem to be filled with javascript based suggestions that no longer work in formula fields

    What im looking to do is simple. I want to have a button half way down a form that works exactly like the native "Save & Keep Working" functionality.

    The reason I want this is because I want people to refresh the page to see an additional tab controlled by a form rule that is based on some of the previously entered data

    So how can i add a "Save & Keep Working" style button? What formula would I need to do this?

    Thanks

    ------------------------------
    Process Q
    ------------------------------


  • 2.  RE: How to Create a Save and Refresh Button

    Posted 08-08-2022 22:30
    You can do this with a Rich Text Formula field.
    // first,  either use the existing Record ID# if the record has one yet, else use the "future" Record ID# after the initial save.

    var text RID = IF([Record ID#] > 0, [Record ID#], %%RID%%)

    var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $RID;


    "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='"
    & $URL
    & "'>Save and Continue in Edit Mode</a>"

    // you can mess around with the button appearance by carefully adjusting the parameters above.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: How to Create a Save and Refresh Button

    Posted 08-11-2022 11:51
    Hi Mark, thanks so much for this but the formula throws out an error because in the first sentence of the formula the first % symbol in "%%RID%%" is highlighted yellow

    Any ideas what this could be?


    ------------------------------
    Process Q
    ------------------------------



  • 4.  RE: How to Create a Save and Refresh Button

    Posted 08-11-2022 12:34
    Sorry, I forgot the quotes.

    "%%RID%%"

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: How to Create a Save and Refresh Button

    Posted 08-11-2022 13:38
    Hi Mark, now it highlights the "%%RID%%" and says "expecting number but found text" . any ideas?

    ------------------------------
    Process Q
    ------------------------------



  • 6.  RE: How to Create a Save and Refresh Button

    Posted 08-11-2022 16:47
    ok try this,   I've been on a bike all week and not on my regular computer .

    var text RID = IF([Record ID#] > 0, ToText(Record ID#]), "%%RID%%");




    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: How to Create a Save and Refresh Button

    Posted 08-11-2022 17:17
    that worked, thanks mark, really appreciate it

    ------------------------------
    Process Q
    ------------------------------



  • 8.  RE: How to Create a Save and Refresh Button

    Posted 08-11-2022 18:01
    Keep in mind I believe this will only work on desktop, not mobile.

    ------------------------------
    Mike Tamoush
    ------------------------------