Forum Discussion

AndrewS's avatar
AndrewS
Qrew Trainee
3 years ago

URL button for a linked report

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
------------------------------

2 Replies

  • 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
    ------------------------------
    • AndrewS's avatar
      AndrewS
      Qrew Trainee
      Thanks, it's work perfectly.

      ------------------------------
      Andrew S
      ------------------------------