Forum Discussion

MichelleCoslet's avatar
MichelleCoslet
Qrew Assistant Captain
4 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
------------------------------
Form Rules
Formulas and functions

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 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
    ------------------------------
  • PrashantMaheshw's avatar
    PrashantMaheshw
    Qrew Captain
    4 years ago
    You could make a checkbox formula with 

    contains([Purpose],"solder")

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


    ------------------------------
    Prashant Maheshwari
    ------------------------------