How to generate a dynamic bar graph on a form by dynamically applying filter on a column through a click on the report

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
I have a column named Article_Number in my Report1 from Table1. I also have a Formula URL button in the same Report1 from Table1. I have another table Table2 from which i will generate a BAR GRAPH (Chart Report) after applying filter on column "Article_Number" . 

Now if the user clicks on the Formula URL button of a particular record in Report1, I want the BAR GRAPH to be dynamically generated after the filter applied on "Article_Number" column of Table2 based on the value of Article_Number from that particular record where that Formula URL button is present.

How to achieve this in QUICKBASE ?

Note: Article_Number Column from Table1 and Table2 contains the same values , I mean they both are same.
Photo of Murali Krishna Gangineni

Posted 10 months ago

  • 0
  • 1

Make a perfect Report that you want to run in table 2, but have an make it an <ask the user> filter. 

Run the report, answer the question and observe the URL.

Now, make a URL formula field in table 1  to mimic that URL

URLRoot() & "db/" & [_DBID of table 2 from Advanced properties] & "?a=q&qid=xx&nv=1&v0=" & urlencode(field from table 1 record to use as a filter)