Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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
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
7 years agoQrew Cadet
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?