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
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- That code goes in the row colorization box for a table report type.
- Actually it is now called
Color-code rows using a formula
- ok but where do I put that code?
- i don't see that option
- Are you saying that you don't see
Color-code rows using a formula
at the bottom of a table report configuration screen? - where is the table report configuration screen?
- Have you build a report? If so, just "Customize this report" at the top right when viewing the report.
If you have not built a report, then go to Reports and Charts and create a new report of type Table.
- 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.
