Discussions

 View Only
  • 1.  Form rule: triggered when a field CONTAINS a word

    Posted 09-27-2022 10:18
    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.  RE: Form rule: triggered when a field CONTAINS a word

    Posted 09-27-2022 11:02
    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
    ------------------------------



  • 3.  RE: Form rule: triggered when a field CONTAINS a word

    Posted 09-27-2022 11:04
    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
    ------------------------------