Forum Discussion

MuraliGangineni's avatar
MuraliGangineni
Qrew Cadet
7 years ago

How to display report by applying filters using dropdown lists on the form ?

I have a table named Table1 . 
I want to give the USER the dropdown list options on a form to apply filters on columns Column1, Column2, Column3, Column4 .
When the user selects a value from the dropdown list of Column1, The related values should popup in the Column2. If the user selects a value from Column2 then show the related values in Column3, Like wise in Column4.
So after the user selects the values from the four dropdown lists i want the report to be shown.

How to do this in QUICKBASE ?

Note: If the user selects only one dropdown list and dont selects remaining three dropdown lists , then also i want to apply filter on that particular column only and show the report.
APIs and custom code
App builders
Ask about Quickbase functionality
  • KingslySamuel's avatar
    KingslySamuel
    Qrew Cadet
    7 years ago
    Did you try using 'dynamic rules' in form to try this? You can say something like 'when' column 1 is not equal to <blank>, taken action to show column 2 and so on to create multiple rules for other columns. I think, the report by default, can be set up to show whatever the user has picked.
    • MuraliGangineni's avatar
      MuraliGangineni
      Qrew Cadet
      7 years ago
      I tried it...But that doesn't work....Basically what I want to do is something like to filter the table and show the table as a report either on the form or on the dashboard.
      My task is something like this SQL Query " SELECT * FROM where Col1=Value1, Col2=Value2, Col3= Value3, Col4=Value4 "
      I want to filter the column values using a drop-down list in a FORM
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    You make a reference to the word related:

     "The related values should popup in ..."

    (1) Do you in fact have more than one table and relationships between Table 1 and these other tables?

    (2) Where do the values for  Column1, Column2, Column3, Column4 come from that you want to show up in four cascading <select>s?


  • MuraliGangineni's avatar
    MuraliGangineni
    Qrew Cadet
    7 years ago
    Hello Dan,

    (1) I have only one table and no relationships with other tables.
    (2) The values for  Column1, Column2, Column3, Column4 come from a single table 

    How to show the report on the FORM based on User Selection in the drop-down lists ?