Discussions

 View Only
  • 1.  How to display report by applying filters using dropdown lists on the form ?

    Posted 10-19-2018 12:05
    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.


  • 2.  RE: How to display report by applying filters using dropdown lists on the form ?

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


  • 3.  RE: How to display report by applying filters using dropdown lists on the form ?

    Posted 10-22-2018 20:06
    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


  • 4.  RE: How to display report by applying filters using dropdown lists on the form ?

    Posted 10-22-2018 20:32
    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?




  • 5.  RE: How to display report by applying filters using dropdown lists on the form ?

    Posted 10-23-2018 05:48
    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 ?