Skip to main content
Question

Color Code Fields

  • Apr 21, 2025 4:25 PM UTC
  • 2 replies
  • 163 views

Forum|alt.badge.img+7

I have looked everywhere and tried everything I can find but no luck. 

I want to background color a field if the values are the same. For instance, if a field for "Job 2345" has the number 523 in the ID field and "Job 1234" has the same 523 number in the ID field, color the background so they're identifiable.  And hopefully grouped together so all jobs with field ID 523 can have the same crew assigned. Thoughts?

2 replies

MarkShnierYou
Forum|alt.badge.img+24

If you do not have "too" much data in that table, you can look for duplicated with a Formula Query.  The syntax is a bit tricky if you have never used that type of formula.  If you like contact me directly at mailto:mark.shnier@gmail.com and I will give you 20 minutes of my time to get this workring.

Mark Shnier. Your Quickbase Coach. QuickbaseCoach.com. mark.shnier@gmail.com

 

 


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 28, 2026 4:03 PM UTC

I’d skip the formula query here, since those can slow the whole app down. A report grouping gets you there with no new fields.

Make a table report and in the Sorting & Grouping section, group by your ID field. Every job with the same ID lands together under one header, so it’s easy to see which ones belong to the same crew.

If you still want them to stand out, you can add a row color formula on the report based on any status or crew field, and the grouping keeps the matches side by side.

Want more detail? I wrote a full walkthrough here: https://www.topstep.tech/blog/quickbase-group-color-code-records-same-id