Highlight Row based on Multipule Choice Field

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • In Progress
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.
Photo of Ryan Ouellette

Ryan Ouellette

  • 140 Points 100 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

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

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

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Is this a Multiple Choice field type or a Multi select field type.
Photo of Ryan Ouellette

Ryan Ouellette

  • 140 Points 100 badge 2x thumb
Multi Select
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
That code goes in the row colorization box for a table report type.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Actually it is now called 

Color-code rows using a formula
Photo of Ryan Ouellette

Ryan Ouellette

  • 140 Points 100 badge 2x thumb
ok but where do I put that code?
Photo of Ryan Ouellette

Ryan Ouellette

  • 140 Points 100 badge 2x thumb
i don't see that option
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Are you saying that you don't see 

Color-code rows using a formula

at the bottom of a table report configuration screen?
Photo of Ryan Ouellette

Ryan Ouellette

  • 140 Points 100 badge 2x thumb
where is the table report configuration screen?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.
Photo of Ryan Ouellette

Ryan Ouellette

  • 140 Points 100 badge 2x thumb
Got it.  Now have this error.

The types of the arguments or the number of arguments supplied do not meet the requirements of the function Contains.

The function is defined to be Contains (Text u, Text v).
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
My IF has the brackets in the incorrect place.

In future please post your code when you have a syntax error.

IF(
Contains($MultiTextFormat, "apples"), "red",
Contains($MultiTextFormat, "bananas"), "yellow",
Contains($MultiTextFormat, "apricots"), "orange")
Photo of Ryan Ouellette

Ryan Ouellette

  • 140 Points 100 badge 2x thumb
This worked only for my home screen.  When I click on the other screens they are not highlighted.

Please advise.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.