Forum Discussion

ArkadyGranik's avatar
ArkadyGranik
Qrew Cadet
11 years ago

Button to save and stay in EDITING record form

I have a form in master Invoices table, which has an embedded Cost Of Materials details table. Cost of Materials is in Grid Edit format on the form, so one can add items quickly. Cost of Materials is...
Forms
Relationships
reports and charts
BenjaminLarrabe's avatar
BenjaminLarrabe
Qrew Cadet
10 years ago
Try this code in a formula text button:



"<a class='Vibrant Success' onclick=$('#RedirectURL').val(document.location.href.replace(/&rl=[a-z0-9]*/,''));$('[name=rl]').val('');$('#saveButton').trigger('click'); href='#'>Update & Keep Working</a>
RyanBlackwood's avatar
RyanBlackwood
Qrew Trainee
8 years ago
I think this is what I was looking for, however, div doesn't work (it doesn't create a button, just displays static text "Save and Keep Working").  

I changed it to:
"<a class='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>Save and Keep Working</a>"

This now gives me a button that works.  Thanks so much!
  • DavidRascon's avatar
    DavidRascon
    Qrew Trainee
    3 years ago

    Hi everyone!!

    I know this is a very old post but I have the same situation but now A rich Text formula field doesn't accept javascript.

    How can I do it now?

    Thank you!



    ------------------------------
    David Rascon
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago

      Try this:

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

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

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

      Note that for this to work, the Advanced setting for the Table needs to be set to "Auto save before navigating away" and also the Parent record must have been "dirtied" with some data entry.  If the only data entry is on a Grid Edit child table, then this will not work.

      If you need it to work in that grid edit situation, then you need to use a form rule to be sure that the record gets dirtied.  Such as set a dummy numeric field equal to the value in that field plus 1.



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