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

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.

Murali Krishna Gangineni

272 Points

Posted 2 months ago

2 months ago

QuickBaseCoach App Dev./Training, Champion

52,786 Points

np,

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)

Comment

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

Related Categories