Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
4 years ago

Create a button that displays an embedded report from a different table

Hello, I want to create a button that displays an embedded report from a different table that is related to what's on the current record. I want a button to go in the green circle and op...
Forms
reports and charts
ReneeHansen's avatar
ReneeHansen
Qrew Member

HALLP! I broke my link :(

I want to append this to open a code page that says you're request has been submitted:

But when I was messing around with it (Like I shouldn't have been) it broke. 

URLRoot()&"db/"&Dbid()&"?a=API_EditRecord&apptoken=92wd2db2nn765dy8e3tqcpksavu&rid="&[Record ID#]&"&_fid_186=Request Approval&rdr="&URLEncode(URLRoot()& "db/" &Dbid()&"?a=dr&rid="&[Record ID#]
I get this error message:

The code page is this:

https://bounty.quickbase.com/db/bqduuj8ap?a=pageedit&pageID=18



------------------------------
Renee Hansen
------------------------------

LauraThacker's avatar
LauraThacker
Qrew Captain
4 years ago
It looks like you are missing the closing-parenthesis off the end of the formula ) after the last [Record ID#]

Another version of this formula would be:

URLRoot() & "db/" & Dbid()& "?a=API_EditRecord&apptoken=92wd2db2nn765dy8e3tqcpksavu&rid=" & [Record ID#]
& "&_fid_186=" & URLEncode(Request Approval) 
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])


------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------