Skip to main content
Question

Formula URL Help Needed

  • November 5, 2021
  • 0 replies
  • 61 views
I am not overly comfortable debugging formula URLs.  I have two questions.  First, I am using a button to trigger a pipeline.  The button is in an embedded report and currently when clicked it is going to the form view.  I would like the result of the button click to be adding a check in a checkbox then returning to the report view.  This is what I have now:

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=tokenmID&rid=" & [Record ID#] & "&_fid_80=1" &
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])

What do I need to change.

Secondly, what is the best resource so I can learn more about this rather than constantly asking for help?

------------------------------
Paul Peterson
------------------------------
This topic has been closed for replies.

Hi Paul, so you currently have your button redirecting back to the record:
Redirect: &rdr=" & URLEncode(URLRoot() & "db/" &
TABLEid: Dbid() & "
View Record: ?a=dr&
Record ID: rid=" & [Record ID#]

If you want it to redirect you have to send it to the URL of the report. TO find the Report ID, look at the qid in the URL of the report page:
View Report: ?a=q&
Report ID: qid=REPORTID

So your url should look similar to this:
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=tokenmID&rid=" & [Record ID#] & "&_fid_80=1" &
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=q&qid=" & REPORTID)

I found these things through the community, but I am sure there is documentation on this somewhere.
------------------------------
Ursula Llaveria
------------------------------
Terms & ConditionsAccessibility statement