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

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
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.
Photo of Murali Krishna Gangineni

Posted 10 months ago

  • 0
  • 1
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 1,030 Points 1k badge 2x thumb
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.
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 [Table1] where Col1=Value1, Col2=Value2, Col3= Value3, Col4=Value4 "
I want to filter the column values using a drop-down list in a FORM
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
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 ?