Discussions

Expand all | Collapse all

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

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

    Posted 09-07-2018 20:07
    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 no records are found containing '' for whichever field(s) are left blank. I need to maintain the all filter condition while allowing for blank inputs in any of the fields.


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

    Posted 09-07-2018 20:56
    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


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

    Posted 09-12-2018 19:53
    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?


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

    Posted 12-11-2018 14:24
    How do I mark this answered? I am  satisfied with the implementation of you original solution.


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

    Posted 12-11-2018 14:26
    You can do a "Like" if you want to ping me, but this new forum no longer has the concept of "Answered".


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

    Posted 12-11-2018 14:27
    Hi Austin,

    I have gone ahead and marked this conversation as Answered for future reference. 


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

    Posted 12-11-2018 14:28
    So only certain users can mark questions answered? I don't see an option as the question creator.


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

    Posted 12-11-2018 14:28
    OK, i did now known that the concept of Answered existed on this Forum.


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

    Posted 12-11-2018 14:35
    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.


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

    Posted 09-10-2018 17:38
    Thanks, I appreciate the option. It seems quickbase has not really designed for an elegant solution to this?


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

    Posted 09-10-2018 18:55
    I'm sure we can come up with something. Can you post more information about the exact workflow your user follows? My first thought would be something along the lines of creating helper fields for each filterable field, where the helper fields are formula fields, and the filter is done on the helper field rather than the data entry field. Sort of the reverse of Coach's suggestion, in a way.

    I don't know if you'd call that kind of a solution ELEGANT, exactly...