Forum Discussion

Qrew Captain

3 years ago

New functionaility %%rid%%

Has anyone used the new feature that allows you to grab the record ID from a custom Rich Text button on an add record form? Ive used it once successfully, and now am completely stuck on why i cant get...

APIs and custom code

Qrew Captain

So, it didn't work, but it allowed me to try something interesting (which still doesn't make sense to me and only confirms my intial issue).

The URL that produced was:
https://sesgroup.quickbase.com/db/brgdpr9fn?a=nwr&_fid_12=0&_fid_57=

Which left field 57 blank.
I manually changed that URL to:
https://sesgroup.quickbase.com/db/brgdpr9fn?a=nwr&_fid_12=0&_fid_57=%%rid%%

Which put "id" in field 57. Hmmm...

------------------------------
Mike Tamoush
------------------------------

Qrew Assistant Captain

3 years ago

That is odd. The only other thing I do different in my app/formulas is I actually set up a global variable that I named [NewRID], containing just the pure text with no quotes: %%rid%%

------------------------------
Brad Lemke
------------------------------

MarkShnier__You
Qrew Champion
3 years ago
Just posting some code that worked. The goal was to add a record and return the user to the 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.

The use case might be to land the user on a saved record so that the Report Link fields would immediately populate.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MichaelTamoush
Qrew Captain
3 years ago
Thanks, Ill try that and get with customer support if needed. Appreciate your insight.

------------------------------
Mike Tamoush
------------------------------
AnneMurray
Qrew Member
3 years ago
Make sure you make an edit on the add record, then press the button. Otherwise, it will not work. This has tripped me up twice now...

------------------------------
Anne Murray
------------------------------
MikeTamoush
Qrew Commander
3 years ago
Thanks Mark. I bet that my original issue was that it was, in the end, URL Endcoded. I thought it wasn't because it wasn't URLEncoded in my variable, but looking back I see it ended up inside a URLEncode anyways...!

------------------------------
Mike Tamoush
------------------------------