Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Formula checkbox needs to uncheck when conditions change

I have a formula checkbox that says
     If(([Related Department or Group] = 13) and Contains(ToText([Tools]), "MVR") true,false)

This works fine until [Tools] changes from "MVR" to ""

What happens is, an anonymous user submits a request. They are in [Related Department or Group]  13, They select "MVR" and "Service Metrics" in [Tools]. They save the request. My formula checkbox checks because "MVR" was selected. That is correct.

The Admin gets the request and decides the users does not need "MVR" so they remove it. But my formula checkbox does not uncheck. I need it to uncheck. How do I fix this?

App builders
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Try this

    [Related Department or Group] = 13
    and ToText([Tools])<>""
    and Contains(ToText([Tools]), "MVR") 

    I'm testing [Tools] is not blank and also just using less code as the If is not really needed for a boolean.

  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    Correct. [Tools] is not blank. The user selected "MVR" and "Service Metrics". The Approver deselected "MVR". So [Tools] now just has "Service Metrics"