Discussions

Expand all | Collapse all

Coding fix to include second option

  • 1.  Coding fix to include second option

    Posted 11-30-2018 21:48
    I have a currency field with this code

    If([Replace]=true, 0, [Amount Offered])

    It works exactly as it needs to. "Replace" is a check box field. I need to amend the code to include a second check box field labeled "Repair". I need it to trigger if either one are checked They will never both be checked so it is an "or" statement rather than an "and" statement.

    I'm also aware that this should be way easier than I'm making it but it's my busy season and my brain has stopped functioning. 

    I would certainly appreciate the help.


  • 2.  RE: Coding fix to include second option

    Posted 11-30-2018 21:56
    Your original formula might be just this:
    If([Replace], 0, [Amount Offered])
    And your amended formula might be just this:
    If([Replace] or [Repair], 0, [Amount Offered])
    It is a common mistake to write [checkbox] = true when [checkbox] alone will do the same thing.


  • 3.  RE: Coding fix to include second option

    Posted 11-30-2018 21:59
    No it is exactly as I pasted it, I was simply giving the checkbox info to let someone know what type of fields they were in case it was relevant. 

    Of course if would be as simple as putting or... Thank you so much for helping me get through the rest of this Friday! :)