Forum Discussion

ArkadyGranik's avatar
ArkadyGranik
Qrew Cadet
10 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
RyanBlackwood's avatar
RyanBlackwood
Qrew Trainee
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
2 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
    Qrew Champion
    2 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
    ------------------------------