Skip to main content
Question

Formula checkbox needs to uncheck when conditions change

  • August 14, 2018
  • 0 replies
  • 45 views
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?

This topic has been closed for replies.

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
  • Author
  • Quickbase Alumni
  • August 14, 2018
Correct. [Tools] is not blank. The user selected "MVR" and "Service Metrics". The Approver deselected "MVR". So [Tools] now just has "Service Metrics"
Terms & ConditionsAccessibility statement