Home Premium Courses Blog HTML Cheat Sheet Login

The easy way to add color to reports in Quick Base

Subscribe on YouTube

Color coding your Quick Base report rows allows the important information to stand out. Drawing attention to critical details will save time and ignite action.

Learn how to add easily add color coding to your Quick Base reports. 

Make any information you want 'pop' on your table report.

  • Need to see active employees at a glance?
  • Want to highlight a task past due?
  • Desire to make out of stock items more obvious?

In this short tutorial, I walk you through three things you need to customize your awesome Quick Base reports using a formula to add color.

  1. Choose your report
  2. Identify the “trigger” field
  3. Select your values & colors

After this quick video, you’ll be well on your way to creating colorful and action generating reports!

RESOURCES:
In the video, I mention this video on using a formula to color code rows: https://www.quickbasejunkie.com/blog/how-to-color-code-rows

 

FROM THE VIDEO: "...In their November release QuickBase added a super easy way to add color to your reports. Gone is the need to write out complex case formulas to color code your report rows. Let me show you how here. I have a quick base with sample HR data. Let's open the report we want to add the color coding to. With my report selected you can see there's no easy way for information to stand out in order to tell whether an employment status is active, inactive, terminated, etc., it's kind of hard to tell. That's where the color coding can help out a lot. Let's look at the customization that's now been added. At the bottom of these options under this section for color coding notice the option to assign a color to choices in an item in this drop down the first option here is departments let's select it and see what happens you see it's assigned a color to each of the choices in the department's field. The department field is a multiple choice type field, it's assigned a color to each of the choices. There are six here and it'll assign up to a maximum of ten colors. Let's see what happens when we have a multiple choice field with more than ten options. That's the case with employee source. Employee source has many more than ten options as you can see in this list, however, QuickBase will only assign choices to the first ten options, so you'll have to watch out for this one. If you want to do more color coding you're going to have to write the formula out. There's the option for that at the bottom and I've got a video for writing the formula out too and you can check it out on the Quick Base Junkie blog or on the Quick Base Junkie YouTube channel. Let's look at the employment status field; the employment status field only has five options, so that's great, it's assigned a color to each of these five but maybe these aren't the colors that you want to have assigned to these five. You can choose a color by clicking on the color box and selecting another color. You can also enter your own hex code for any color you choose. There's a couple of colors I know like dark gray or black, although I don't actually recommend using really dark colors. You could also even enter white. If you know the color for your company's branding you could use those colors as well. If we don't want to have any color assigned to one of the choices we simply need to click the minus sign and that'll delete it from our list and a color will not be assigned.  You can assign a color to address fields, email fields, text fields, multi-select fields, and multiple choice fields. You should all show up in the drop-down in the customization options there isn't an option for color coding on an item like a checkbox which you may want to include, in those cases you will need to write a formula. There is one other thing I wanted to mention - if I go back to my home page the report here does not have any color coding and the reason for that is because this report is based on the default report and the default report does not allow for any type of color coding..."

Feeling like a Junkie? Subscribe on YouTube now! 

I'm always interested in hearing from you about what you're working on and what you would like to learn more about. 
Visit: https://quickbasejunkie.com/p/input

Don't miss the latest:

Tips, shortcuts, checklists, reviews, tutorials, and courses from Quick Base Junkie!

Subscribe now to stay in touch

Don't worry, your information will not be shared.

Subscribe

Already subscribed?

Take your Quick Base skills to the next level with Premium Courses.

Premium Courses
Close

Don't miss the latest:

Tips, shortcuts, checklists, reviews, tutorials, and courses from Quick Base Junkie!

Sign up now to stay in touch