Forum Discussion

MichelleCoslet's avatar
Qrew Assistant Captain
2 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. 

Michelle Coslet

2 Replies

  • You could make a checkbox formula with 


    And then use this field on form rules, to see if checkbox is checked

    Prashant Maheshwari
  • np,
    The form rules are not powerful enough to do CONTAINS.
    But just make a formula field checkbox called [Purpose contains 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)