Formula checkbox needs to uncheck when conditions change

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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?

Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb

Posted 3 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
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.

Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb
Correct. [Tools] is not blank. The user selected "MVR" and "Service Metrics". The Approver deselected "MVR". So [Tools] now just has "Service Metrics"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,198 Points 50k badge 2x thumb
I'm not sure if you are saying that your problem is solved or not, right now.
Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb
I have it now. Quick Base support found the issue. Thanks.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,198 Points 50k badge 2x thumb
Can you post your final working formula?