Forum Discussion

MichelleCoslet's avatar
MichelleCoslet
Qrew Assistant Captain
3 years ago

Form rule: triggered when a field CONTAINS a word

How would i set up a form rule to display a window prompt if a field contains the word "Solder"? My options are limited to Equals, does not equal,  >, <, is between, etc.  -----------------...
Form Rules
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
np,
The form rules are not powerful enough to do CONTAINS.
But just make a formula field checkbox called [Purpose contains Solder] 

Contains([Purpose],"solder")

Then hook the form rule on that formula field.  You will probably need to put the formula field on the form (in a hidden section if you like) to get the form to see the current value of the formula checkbox field.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------