Skip to main content
Question

URL button for a linked report

  • August 12, 2021
  • 0 replies
  • 36 views
Hello,
I have Budgets and  Budget Lines Table, 1 Budget has many Budget Lines. (Related ESTIMATE is primary KEY for the Budgets Table, Estimate ID is a foreign key in the Budget Lines Table)
Budget Lines has Chart report (id 14), I try to approach URL button in the Budgets table to open the Chart report, related to the particular Budget in the Budget Lines table.

my formula is:

URLRoot() & "db/" & [_DBID_BUDGET_LINES] & "?a=q&qid=14&rid=" & [Related ESTIMATE]

But it shows the report with all Budget Lines.

What I do wrong?

------------------------------
Andrew S
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You need to make a report of Budget lines with an <ask the user> filter which asks for the Related Budget.

Then change your formula to this.

URLRoot() & "db/" & [_DBID_BUDGET_LINES] & "?a=q&qid=14&nv=1&v0=" & [Related ESTIMATE]

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement