Skip to main content
Question

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

  • October 19, 2018
  • 0 replies
  • 52 views
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.
    This topic has been closed for replies.

    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.
    • anomDiebolt
    • Registered
    • October 23, 2018
    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?


    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 ?
    Terms & ConditionsAccessibility statement