Highlight Row based on Multipule Choice Field
New to Quickbase. Looking to highlight a row based on the status drop down. I have the multiple choice drop down but cant figure out how to get it to highlight the row based on what is chosen.
Forum Discussion
var text MultiTextFormat = ToText([my multi sect field]);
IF(
Contains($MultiTextFormat, "apples", "red"),
Contains($MultiTextFormat, "bananas", "yellow"),
Contains($MultiTextFormat, "apricots", "orange"))
for the actual colour codes I suggest using the hex codes in this app by another QSP Laura Thacker. for example use say #FF6EB4 instead of red.
https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1
IF(
Contains($MultiTextFormat, "apples", "red"),
Contains($MultiTextFormat, "bananas", "yellow"),
Contains($MultiTextFormat, "apricots", "orange"))
for the actual colour codes I suggest using the hex codes in this app by another QSP Laura Thacker. for example use say #FF6EB4 instead of red.
https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1
That code goes in the row colorization box for a table report type.