Forum Discussion
AshleyGwozdz
4 years agoQrew Member
I read somewhere that the topmost color should take precedence, and they are listed in order of importance. This is how it was working for me before (when all four fields were checkboxes).
I was using this code before:
------------------------------
Ashley Gwozdz
------------------------------
I was using this code before:
Case(true,
[Checkbox Field 1],"#f0f0f0",
[Checkbox Field 2],"#dbfffd",
[Checkbox Field 3],"#ffebbf",
[Checkbox Field 4], "#ffffbf"
)
------------------------------
Ashley Gwozdz
------------------------------
MikeTamoush
4 years agoQrew Commander
Ok yes order will be from top to bottom. In this case, since you are looking at multiple fields, you need an if statement.
As soon as it hits a true statement, that is the color that will be used.
------------------------------
Mike Tamoush
------------------------------
If(
[Multiple Choice Field] = "Option2", "#f0f0f0",
[Checkbox Field 1] = true, "#dbfffd",
[Checkbox Field 2] = true, "#ffebbf",
[Checkbox Field 3] = true, "#ffffbf"
)​
As soon as it hits a true statement, that is the color that will be used.
------------------------------
Mike Tamoush
------------------------------
- AshleyGwozdz4 years agoQrew MemberThanks! Works perfectly!
------------------------------
Ashley Gwozdz
------------------------------