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
  • AustinHayes's avatar
    AustinHayes
    Qrew Cadet
    7 years ago
    I am utilizing this tactic right now. It works well enough, I appreciate the input. It isn't perfect but certainly gets the job done. Is there a way to set the fields to * by default on load?
  • AustinHayes's avatar
    AustinHayes
    Qrew Cadet
    7 years ago
    How do I mark this answered? I am  satisfied with the implementation of you original solution.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    You can do a "Like" if you want to ping me, but this new forum no longer has the concept of "Answered".
  • EvanMartinez's avatar
    EvanMartinez
    Moderator
    7 years ago
    Hi Austin,

    I have gone ahead and marked this conversation as Answered for future reference. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    OK, i did now known that the concept of Answered existed on this Forum.
  • AustinHayes's avatar
    AustinHayes
    Qrew Cadet
    7 years ago
    So only certain users can mark questions answered? I don't see an option as the question creator.
  • 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.