Skip to main content
Question

Checkbox - auto-checked with a condition

  • January 6, 2018
  • 0 replies
  • 65 views

I need a checkbox (field "Checked") to be checked automatically, based on another text field (field "Text") has a specific particular word in it "Content". If the word "content" is not there, I don't want the box to be checked. Is this possible with the "formula-checkbox" field? If so, please help.
This topic has been closed for replies.

contains([My Text field], "Your Quick Base Coach")

will be true if [My Text field] Contains the phrase
"Your Quick Base Coach"

or if it contains

"youR QUICK base Coach

  • Registered
  • January 6, 2018
you may also want to include common misspellings of the word 

  • Author
  • Registered
  • January 8, 2018
Thank you guys. This is so helpful. It works perfectly.