Skip to main content
Question

Working with %%rid%% and checking a box

  • April 14, 2024
  • 0 replies
  • 540 views
Forum|alt.badge.img+5

I know this has been probably answered before, but I just can't get this formula to work.  I want it to save a record (even a new record or already created one) and check a box.  I am going to use that box in a pipeline.  Here is my formula.  Can anyone see what I am doing wrong?  It does not check the box (fid is 599).

var text RID =If(IsNull([P-Referral Record ID#]),"%%rid%%", ToText([P-Referral Record ID#]));
var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $RID &
    "&_fid_599=1";

var text LABEL = "Send Consent to JotForm";
"<a class='Vibrant Success SaveBeforeNavigating' data-replaceRid=true href='" & $URL &"'>" & $LABEL & "</a>"

This topic has been closed for replies.

Forum|alt.badge.img+20
  • MikeTamoush
  • Registered
  • April 15, 2024

The ?a=er syntax will simply put a record into edit mode. So essentially a user would be left to check the box on their own. What you are looking for is the edit record API (the api, on the other hand runs and edit record automatically). Try this:

var text RID =If(IsNull([P-Referral Record ID#]),"%%rid%%", ToText([P-Referral Record ID#]));

var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord"
& "&apptoken= xxxxxx" // if Application Tokens are enabled, enter token here.
& "&rid=" & ToText($RID)
& "&_fid_599=1"; 
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())  

var text LABEL = "Send Consent to JotForm";


"<a class='Vibrant Success SaveBeforeNavigating' data-replaceRid=true href='" & $URL &"'>" & $LABEL & "</a>"

Terms & ConditionsAccessibility statement