Expand all | Collapse all

Checkbox to Formula text field

  • 1.  Checkbox to Formula text field

    Posted 02-12-2020 11:24
    I have 8 checkbox fields that we use to send customers emails.
    Each checkboxfield sends a different email. Excellent it works like a charm. But on my reports I dont want to have to add all 8 fields to see which email was sent. I would like 1 rich text formula field that I could see which checkbox was clicked on.

    Something like
    if([1)Trying to to make first contact] = checked, then this text would show up"made first contact" 
    But I am not seeing  a formula to turn checkbox results into text.

    Thanks for you guys help I know its probably simple but not seeing it.

    Joshua Joshua

  • 2.  RE: Checkbox to Formula text field

    Posted 02-12-2020 11:31
    Edited by Austin K 02-12-2020 11:31
    So there will not be a time where more than 1 checkbox is checked? This will stop once it hits the first thing that is true and display that. This is for a formula - text.

    If([first contact] = true, "Made first contact",
    [second contact] = true, "Made second contact",
    [third contact] = true, "Made third contact",
    [fourth contact] = true, "Made fourth contact",
     Etc. Although you might be better off with a multiple choice text or something like that instead of a bunch of checkboxes. But if the checkboxes work they work.

  • 3.  RE: Checkbox to Formula text field

    Posted 02-12-2020 11:33
    Thanks Austin

    Yeah tried a multiple choice text and the emails would fire all over the place. So the checkboxes work the best. thanks

    Joshua Joshua