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?
This is a great suggestion.
For now, you can include a colorful emoji in the primary field of the linked record. If your primary field is a formula field, you can even have the formula control which emoji to use depending on the state of the record. Then in your linked record fields you will be able to see things at a glance based on the emoji.
For a workaround, I wrote an automation that tracks linked records and maps them into a coloured single select field on the table where you’re needing the colour. It works well, and you can limit permissions on the extra colour select so users don’t accidentally change/desync it.
But would I love to see this feature? Heck yeah! I’ve been wanting it for years.
I was wondering this myself! It seems like it was requested 5 years ago, and is long overdue.