Code Page and URL Formula Field Button Issue
Hello I am trying to get a url formula button, From Magic Buttons, to work to where it creates a child record and opens it in edit mode. I have created a Code Page and URL Formula button field on the ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this approach as a Formula Rich Text field type
The code below work to add a record and then blend the user on the newly added record in edit mode.
var text RID = "%%rid%%";
var text AddShipment = URLRoot() & "db/" & Dbid() & "?a=nwr";
var text EditShipment = URLRoot() & "db/" & Dbid() & "?a=er&rid=" ;
var text URL =
$AddShipment
& "&rdr=" & URLEncode($EditShipment) & $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 Display in Edit Mode</a>"
NOTE: The %%RID%% does not seem to like being URLEncoded.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
The code below work to add a record and then blend the user on the newly added record in edit mode.
var text RID = "%%rid%%";
var text AddShipment = URLRoot() & "db/" & Dbid() & "?a=nwr";
var text EditShipment = URLRoot() & "db/" & Dbid() & "?a=er&rid=" ;
var text URL =
$AddShipment
& "&rdr=" & URLEncode($EditShipment) & $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 Display in Edit Mode</a>"
NOTE: The %%RID%% does not seem to like being URLEncoded.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- I appreciate the suggestion. I tried it out and it gives me the error that the Parent Record is Not found. Is that formula supposed to be used on the parent record to open and edit the child record?
------------------------------
Kyle Richardson
------------------------------ - This is what I ended up putting in. Please let me know what I did wrong.
var text RID = "%%rid%%";
var text AddDocusignDocJT = URLRoot() & "db/" & Dbid() & "https://companyname.quickbase.com/db/bsaxb9zdy";
var text EditDocusignDocJT = URLRoot() & "db/" & Dbid() & "https://companyname.quickbase.com/db/bsaxb9zdy";
var text URL =
$AddDocusignDocJT
& "&rdr=" & URLEncode($EditDocusignDocJT) & $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 Display in Edit Mode</a>"
------------------------------
Kyle Richardson
------------------------------- MarkShnier__YouCan you clarify your desired workflow? Are trying to put the user on a Add Record form to do data entry and have them save but end up back in edit mode?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- I was actually able to get my original formula to work. Thank you for your insight and options.
------------------------------
Kyle Richardson
------------------------------
