Checkbox to Formula text field
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 t...
Forum Discussion
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.
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.
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
------------------------------
Yeah tried a multiple choice text and the emails would fire all over the place. So the checkboxes work the best. thanks
------------------------------
Joshua Joshua
------------------------------
