Skip to main content
Question

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.
This topic has been closed for replies.

If([status]="value","#CCDDFF","")

^^ that would go into the report configuration. Do you know where that is?

Is this a Multiple Choice field type or a Multi select field type.
Multi Select
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
ok but where do I put that code?
i don't see that option
This worked only for my home screen.  When I click on the other screens they are not highlighted.

Please advise.
Each separate report will need to have it's own formula for the row colors.  You will need to copy the formula to the other reports.
Terms & ConditionsAccessibility statement