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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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
Photo of Rohit Agarwal

Rohit Agarwal

  • 552 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,774 Points 50k badge 2x thumb
Is this Role Permission filter or a Report filter or a Summary field filter.
Photo of Rohit Agarwal

Rohit Agarwal

  • 552 Points 500 badge 2x thumb
Report Filter
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,774 Points 50k badge 2x thumb
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.
Photo of Rohit Agarwal

Rohit Agarwal

  • 552 Points 500 badge 2x thumb
Which means the filter shown in the picture is not possible.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,774 Points 50k badge 2x thumb
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.
Photo of Rohit Agarwal

Rohit Agarwal

  • 552 Points 500 badge 2x thumb
Thank you.
Photo of Rohit Agarwal

Rohit Agarwal

  • 552 Points 500 badge 2x thumb
The Task that I am trying to achieve looks like this.
See attached picture. 

The 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,774 Points 50k badge 2x thumb
Are you using the Dynamic Filters feature of Reports.  Just configure your report and select up to 5 fields to be Dynamic Filters.
Photo of Rohit Agarwal

Rohit Agarwal

  • 552 Points 500 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,774 Points 50k badge 2x thumb
I suggest that you post this as a new question.