Button To View Child Record Report
I would like to add a button that will open a report in a new window, but filtered to show only the related child records. I get that I can embed the report directly (but I need a report formatted ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOK, so this is a two step process, but it's easy.
Step 1. Make your perfect report and have an <ask the user> filter on it for Related Parent. Run the report answer the question and observe the URL.
Step 2. Then like with many tricks in Quick Base, we just need a formula to mimic that URL. Note, I will be assuming here that the DBID you gave is to the child table.
Here we go for the URL button formula
URLRoot() & "db/" & [_DBID_PROJECT_DAYS] & ?"a=q&qid=99&nv=1&v0=" & [Related Parent]
Replace 99 with the Report #.
​
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Step 1. Make your perfect report and have an <ask the user> filter on it for Related Parent. Run the report answer the question and observe the URL.
Step 2. Then like with many tricks in Quick Base, we just need a formula to mimic that URL. Note, I will be assuming here that the DBID you gave is to the child table.
Here we go for the URL button formula
URLRoot() & "db/" & [_DBID_PROJECT_DAYS] & ?"a=q&qid=99&nv=1&v0=" & [Related Parent]
Replace 99 with the Report #.
​
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
