Skip to main content
Question

Highlight Row based on Multipule Choice Field

  • March 7, 2018
  • 0 replies
  • 44 views
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.

  • ChrisChris
  • Registered
  • March 7, 2018

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.
  • ArchiveUser
  • Author
  • Registered
  • March 8, 2018
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
  • ArchiveUser
  • Author
  • Registered
  • March 8, 2018
ok but where do I put that code?
  • ArchiveUser
  • Author
  • Registered
  • March 8, 2018
i don't see that option
  • ArchiveUser
  • Author
  • Registered
  • March 13, 2018
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