Forum Discussion

JonFroderberg's avatar
JonFroderberg
Qrew Cadet
6 years ago

Reports With API Filters Launched From URL Link Lose Filter Criteria

We have several report buttons on dashboards and forms in our apps that are coded to call the report and also apply various filters in the URL.  However, if the resulting report data set has more than...
reports and charts
JonFroderberg's avatar
JonFroderberg
Qrew Cadet
6 years ago
We have a mixture of buttons. Most of them just go directly to the URL embedded in the button. There are a few that go to external web pages and a few that go to code pages within our Quick Base realm to do some more complex functions such as Workato. The example in my original post is just a direct URL.

I will experiment with the "ask the user" approach. Thanks for the suggestion! Our goal was to create a page of buttons embedded in a single formula rich text field that would all be filtered based on the page/table/record they were launched from. Simpler experience for the user!  We are also experimenting to determine whether we can overcome the page coding limiting the report results.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
503.382.4413
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
If you are making a button to launch off a record which inherently knows the answer to a question, it's very easy to create a simple URL formula button which runs the <ask the user> report and answers the question. 

Urlroot() & "db/" & dbid() & "?a=q&qid=9&nv=1&v0=" & [branch]

This would be an ask the use Report which will run filtered in a branch value  in the record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------