Discussions

Expand all | Collapse all

Checkbox - auto-checked with a condition

  • 1.  Checkbox - auto-checked with a condition

    Posted 01-05-2018 19:58
    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.


  • 2.  RE: Checkbox - auto-checked with a condition

    Posted 01-05-2018 20:02
    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


  • 3.  RE: Checkbox - auto-checked with a condition

    Posted 01-05-2018 21:50
    you may also want to include common misspellings of the word 


  • 4.  RE: Checkbox - auto-checked with a condition

    Posted 01-08-2018 00:43
    Thank you guys. This is so helpful. It works perfectly.