Discussions

Expand all | Collapse all

Can we pass two values in text box while filtering data?

  • 1.  Can we pass two values in text box while filtering data?

    Posted 05-26-2017 17:01
    When I select two I can see these two filter added in separate line. Is there any possibility to add two filter value in same text box.

    See Picture Attached. 



    https://community.quickbase.com/quickbase/topics/new/add_details?post_flow=true&topic%5Bsubject%5D=Can+we+pass+two+values+in+text+box+while+filtering+data%3F


  • 2.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 17:03
    Is this Role Permission filter or a Report filter or a Summary field filter.


  • 3.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 17:08
    Report Filter


  • 4.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 17:10
    The best way to do this is to simply hover beside the report filter line and add a new line and set it to be where "any" are true.

    You can also separate terms with OR  in upper case but its a clearer practise, I feel to have a separate line as a report filter.


  • 5.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 17:13
    Which means the filter shown in the picture is not possible.


  • 6.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 17:15
    You can require that filter like

    Not Started OR Cancelled

    as Quick Base will not recognize that string as an OR comparison.  It will treat it as one link string.


  • 7.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 17:28
    Thank you.


  • 8.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 17:57
    The Task that I am trying to achieve looks like this.
    See attached picture. 

    The">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1602005/RackMultipart20170526-112667-17guic4-filter_inline.PNG?1495821419">The 


  • 9.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 18:00
    Are you using the Dynamic Filters feature of Reports.  Just configure your report and select up to 5 fields to be Dynamic Filters.


  • 10.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 18:09
    I want a dashboard with 7-8 reports and multiple filters. So by applying a filter, all reports change dynamically.  

    I know it is easy to add dynamic filters in reports but the task is to have multiple filters in Dashboard.


  • 11.  RE: Can we pass two values in text box while filtering data?

    Posted 05-26-2017 18:26
    I suggest that you post this as a new question.