Discussions

Expand all | Collapse all

Formula checkbox needs to uncheck when conditions change

  • 1.  Formula checkbox needs to uncheck when conditions change

    Top
    Contributor
    Posted 08-14-2018 13:40
    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?



  • 2.  RE: Formula checkbox needs to uncheck when conditions change

    Posted 08-14-2018 14:31
    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.



  • 3.  RE: Formula checkbox needs to uncheck when conditions change

    Top
    Contributor
    Posted 08-14-2018 15:35
    Correct. [Tools] is not blank. The user selected "MVR" and "Service Metrics". The Approver deselected "MVR". So [Tools] now just has "Service Metrics"


  • 4.  RE: Formula checkbox needs to uncheck when conditions change

    Posted 08-14-2018 15:47
    I'm not sure if you are saying that your problem is solved or not, right now.


  • 5.  RE: Formula checkbox needs to uncheck when conditions change

    Top
    Contributor
    Posted 08-14-2018 16:56
    I have it now. Quick Base support found the issue. Thanks.


  • 6.  RE: Formula checkbox needs to uncheck when conditions change

    Posted 08-14-2018 17:07
    Can you post your final working formula?