How to Create a Save and Refresh Button
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 suggestion...
Forum Discussion
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
------------------------------
// 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
------------------------------
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
------------------------------
Any ideas what this could be?
------------------------------
Process Q
------------------------------
- Sorry, I forgot the quotes.
"%%RID%%"
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Hi Mark, now it highlights the "%%RID%%" and says "expecting number but found text" . any ideas?
------------------------------
Process Q
------------------------------- 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
------------------------------
