Skip to main content
Question

Is it possible to create a ""Save and Keep Working"" button from a formula URL field?

  • November 21, 2017
  • 0 replies
  • 1749 views
I realize the "Save and Keep Working" button was introduced by Quickbase, but I am wanting to add it somewhere in the middle of my form. I've seen posts relating to this kind of thing, but all of theme were published prior to the introduction of the "Save and Keep Working Button" and I can't seem to get any of them to work. Any thoughts?
    This topic has been closed for replies.

    • ChadBrandmire
    • Registered
    • December 27, 2017
    Try this in a Formula Rich Text

    var text urlone = URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=dr&dfid=2&rid=" & URLEncode([Route ID#]);

    "<a href="& $urlone &"><img width=\"100\"src=\"<i><u>Link your button image here</u></i>\"></a>";
    • anomDiebolt
    • Registered
    • December 29, 2017
    Put a Rich Text Formula field in the middle of your form with this definition:

    "<div style='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>Save and Keep Working</div>"

    When it is clicked it will trigger the clicking of the native Save and Keep Working button (even though it is not visible at the moment).  FWIW, this type of strategy of embedding JavaScript into a form which emulates a user clicking on a native features is safer than other methods of more directly invading the native markup and code.
    Wow, I will need to try that trick myself.
    Thx for the Boxing week Christmas Present. 
    • anomDiebolt
    • Registered
    • December 29, 2017
    Well I have a truckload (100s) of similar techniques for which I just need a kitschy name, an image macro or some other gimmick in order to promote the technique. Just get me the raw concept and I will get you the technical solution. Something creative like this:


    This works great. But, how can I activate the Save & keep working feature from the header? Using "onclick=$('#saveButton')" as mentioned above activates the normal save function which I've set to redirect to an error message because I have created my own own 'save' and 'apply changes' buttons
    And, using  "onclick=$('#footerSaveAndKeepWorkingMenuOption')" only works if the footer is added to the form. I'd prefer not to have it there.
    • AlexWilkinson
    • Registered
    • February 21, 2018
    Here's a cleaner way to do this, replicating the color and style of the standard 'Save & keep working button' while allowing it to be placed anywhere on the form:

    1) In the form properties, check the box to "Show save & keep working choice." (It's not necessary to also check the box to show the save and cancel buttons at the bottom of the form. That's optional.)

    2) Create a global variable for your app at Setting >> Variables ... Let's say you call it "mySaveKeepWorking" or something similar ... and give it exactly the following value (the quotes are critical!)

    <a class='Vibrant' style='font-size:14px; color:white; background:#6BBD57; white-space:nowrap;' onclick='$("#saveAndKeepWorkingMenuOption").click();'>Save & keep working</a>

    3) In your table, create a rich text variable ... say it's called "mySKW" and give it exactly and only the following value:

    [mySaveKeepWorking]

    4) In your form, place the mySKW field wherever you want, as often as you like. Each time, be sure to check the box for "Use Alternate Label Text" while leaving the value blank, and to set the form-row for "edit and add" modes.

    When you save the form, Quick Base will ask you to confirm that you really do want the mySKW field to appear multiple times, which you do!

    That's it. One wrinkle: it might be nice to have mySKW return to the same spot on the form where it was clicked. That's doable but a bit fancier. Post back here if interested.
      Terms & ConditionsAccessibility statement