Contains -- Multiple options
Hey, Basically I have a bunch of locations and different jobs that I would like to be able to Populate the field with one outcome, and I am wondering if its possible to have something like IF(Co...
Forum Discussion
The 'Contains' formula function requires a single variable text string and a text field to query, but you can use the Or function to query all of the combinations of your options.
Try this Matt:
IF(
Contains([LOCATION],"Milton")=true or Contains([LOCATION],"Oakville")=true or Contains([LOCATION],"Mississauga")=true
and Contains([WORKTYPE],"Spill")=true or Contains([WORKTYPE],"Containment")=true,
"Emergency Response",
"")
------------------------------
Adam Keever
------------------------------
Try this Matt:
IF(
Contains([LOCATION],"Milton")=true or Contains([LOCATION],"Oakville")=true or Contains([LOCATION],"Mississauga")=true
and Contains([WORKTYPE],"Spill")=true or Contains([WORKTYPE],"Containment")=true,
"Emergency Response",
"")
------------------------------
Adam Keever
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendMatt,
I agree with Don. You can do this by formula, but really this should be table driven so you don't end up with a formula with 100 conditions in a long IF statement. It's just not a good design and it means that regular users can't make a new entry.
If you can describe the parameters which drive the result, we can suggest a table structure. Is the result solely determined by the combination of the Location and Work Type?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I agree with Don. You can do this by formula, but really this should be table driven so you don't end up with a formula with 100 conditions in a long IF statement. It's just not a good design and it means that regular users can't make a new entry.
If you can describe the parameters which drive the result, we can suggest a table structure. Is the result solely determined by the combination of the Location and Work Type?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------