Checkbox - auto-checked with a condition

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
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.
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,316 Points 50k badge 2x thumb
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"
Photo of melizzza

melizzza

  • 436 Points 250 badge 2x thumb
you may also want to include common misspellings of the word 
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb
Thank you guys. This is so helpful. It works perfectly.