Forum Discussion

AustinHayes's avatar
AustinHayes
Qrew Cadet
7 years ago

How to utilize multiple ask the user filters in single query while allowing for situations with no input for some of the filters.

I am looking to utilize multiple ask the user contains queries with an all condition. I run into problems when the user leaves any of the ask the user filters blank; no results are pulled back because...
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I seem to recall that I use this technique in the past.

I created a mirror Field for example a field called [customer name or enter * for all]

With the formula

[customer name] & "*"

So the result is ACME INC.*

Then I use that field for the Ask then User prompt and try to train the users to know that they put in an * for a wildcard.

But this tactic will only work for a contains search
EvanMartinez's avatar
EvanMartinez
Moderator
7 years ago
As the Community Manager I can mark content as Answered which I try to do when I see that a thread had a successful resolution so that its a bit easier for those viewing a conversation later to see if the suggestions worked.