Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Option to Match 'Any' in 'Ask the User' in a View's filter
Currently its possible to filter a view using 'Ask the User' and choosing some columns where the user selects some values to search on.

Currently these only bring back results where ALL values match. It would be nice if there was the choice of searching on ANY value.

Alternatively, when using the formula e.g. Ask(Any([xyz],[?xyz])) where xyz is a multi-reference field, change so multiple values are available to select from in a search form (currently only 1 is supported)


ID
1133
Category
Customization
Author

Nick Ashcroft
Date Created
10/3/2017 6:24:23 AM
Date Updated
10/3/2017 5:56:37 PM
Status
New Idea
Score
20
Promoted By
Patricio BustosNick Ashcroft
Comments
Nick Ashcroft 10/3/2017 7:59:51 AM
just for clarification, I refer to ANY vs ANY matching on a field containing multiple values
basenine 10/3/2017 5:56:37 PM
In the past, I've created a dedicated formula text field called [SEARCH]:

List("\n", [Customer Name], [Customer Address], [Quote Id], [Customer Phone])

Then in the View setup, I choose [SEARCH] --> Contains --> Ask the User

You can string together anything you like in the List() formula

That may help(?)

Best regards - Brett
Feedback
 
Back to Search Results