Skip to main content
Question

Form rule: triggered when a field CONTAINS a word

  • September 27, 2022
  • 0 replies
  • 201 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------

Forum|alt.badge.img+11
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
------------------------------