Forum Discussion

MuraliGangineni's avatar
MuraliGangineni
Qrew Cadet
7 years ago

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.
APIs and custom code
App builders
Ask about Quickbase functionality
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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)