Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Color linked records to look like a single select

cancel
Showing results for 
Search instead for 
Did you mean: 
Max_Goldberg1
6 - Interface Innovator
6 - Interface Innovator

I love using the Single Select (or Multiple Select) fields to add a pop of color to a table, and be able to see things at a glance. I also love how easy it is to change a Single Select field to a Linked Record field, and to automatically create a new table using the data from that field.

But I don’t love that all my colors go away when I do this. I gain so much functionality, but lose the ability to see things at a glance. I know I can add a little colored stripe to the side of record based on certain conditions, but it’s not the same as the colorful pills in either Single or Multiple Select fields.

What if there was a way to take the conditional coloring from one table, and use that to add color to that record when it appears in another table in a Linked Records field?

Screen Shot 2021-11-17 at 1.04.50 PM
Screen Shot 2021-11-17 at 1.04.59 PM

17 Comments
Brenda_Ginsberg
6 - Interface Innovator
6 - Interface Innovator

Cheers to this happening!

James_TCA
5 - Automation Enthusiast
5 - Automation Enthusiast

I just rebuilt a DB to use more linked fields in place of single/multi-select and was disappointed to see everything turn to grey. The coloring is such a great option for visually seeing information quickly. Please provide a solution

Roman_Sydorak
4 - Data Explorer
4 - Data Explorer

This is something that is a must if you grow your base, 
you start with single selects, and then turn them into linked fields, and it becomes a lot worse visually.
AT please add this.

La_Issa_
4 - Data Explorer
4 - Data Explorer

So i figured out a way to do it with the emojis like everyone mentioned with a formula.  see below: 

IF({Status} = "Backlog", "", 
    IF({Status} = "Committed", "🔵", 
        IF({Status} = "Complete", "🟢", 
            IF({Status} = "Dead", "🔴", 
                IF({Status} = "In Progress", "🟡", 
                    IF({Status} = "On Hold", "🟠", "")))))) 
Status is my linked record. 
 
 
Roman_Sydorak
4 - Data Explorer
4 - Data Explorer

Thank you for the proposal.
If you have a limited number of linked records, hardcoding a formula might make sense.
In my case, linked records are being added and removed quite often.
Imagine you start a Project management base, where there are 3 initial users, you can select assigned with a dropdown.
In some time headcount growth, and you add an HR base, you would like to link it to that base, but our clear visual identifier for Project assigned person disappears. You will not add colors for new employees each time. 

Erwan_Pannier1
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 This would be very helpful 

schtroumphy97
4 - Data Explorer
4 - Data Explorer

+1 Please do something !