Forum Discussion
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
------------------------------
Greaaat!!
It worked fine!
DAVID L. RASCON Customer Acquisition and Retention Manager 6641 N. Beltline Road, Suite 100 Irving, TX 75063 C: (469) 615-0609 david.rascon@nhausa.com |