Discussions

Back to discussions
Expand all | Collapse all

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

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

    Posted 10-19-2018 11:06
    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.


  • 2.  RE: How to generate a dynamic bar graph on a form by dynamically applying filter on a column through a click on the report

    Posted 10-19-2018 18:13
    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)