Change colors on linked records

It’s also possible to use emoji’s to make a difference:

@Bram_Meulen This is a clever workaround! Thanks for sharing.

This would be very helpful and seems like it should be the intuitive representation of linked records - we can choose colors for single/multi-selects, we can assign colors to records based on a condition– and then none of that helpful, color-coded info gets carried over into another table through linked records.

Thread necro!

I too have been wanting this feature for years and years. Since learning about automation, we can at least employ a workaround to this limitation. In my example, I have a colour field in the lookup table, and the same colour field re-created in the entries table. The automation then does a check between the two tables and keeps the entry colour in line with the entry lookup colour.

Note how you’ll need to check colours are set up correct, my blue and green are different. :upside_down_face:

It’s a bit of a pain having to duplicate fields in each table, but works well enough.

voted! this feature is urgent lol

Any update on this? Would love the ability to color the linked records.

+1000000000000000 It’s been requested for four years. PLEASE!

Sometime it is very difficult to understand what the product managers are doing when such simple but useful product requests are ignored forever. But I’ve seen in many startups that the communication channel between VOM(voice of member) and Product(PMs who prioritize features) does not exist at all. And VOMs, here probably the community leads attempt to mitigate user report by using suboptimal workarounds as suggestions without figuring out a real way to get the simple feature added.

I would caution with saying “simple” because we don’t know the challenges the team faces, but in general, yes, celebrating workarounds is not equivalent to providing a new, dedicated solution to the problem.

For those still looking to add some color to your linked records, this is possible using the lookup field.

Step 1: Create a single select field on the main table you are linking to (for example: Article Topics). The best way to do this might be to duplicate the “Name” field, change it to Single Select, then change your “Name” field to a formula that pulls from the Single Select. (Make sure your single select has colored options turned on.)

Just to clarify, your Single Select field and your record’s primary field might be the same, but the Single Select field will have colors associated with it.

Step 2: Go to the secondary table that is pulling from your main table (for example: Calendar - which lists all your dates and links back to the topic that is being covered that day). Create a lookup field that pulls the Single Select field from the Main table. That lookup field will pull through the formatting of the Single Select.

Again, you may have a field with duplicate content (the Single Select has the same information as the linked record’s name), however the Single Select field will contain colors.

Note: For formatting calendars, the lookup field’s colors won’t be recognized, However, you’ll find it is easier to set up conditional formatting using the lookup field (since it is recognized as a single select field).

I hope this is helpful!

This. This is brilliant. Thank you.

To get people started - I used this formula on my linked record to have a conditional title icon show up in a different table. The plain-english translation is “show the :paperclip: icon after the person record’s name if there is anything contained in any of the Waiver form,Waiver ID or Waiver url fields”

CONCATENATE({First Name}," ",{Last Name}) & IF(OR({Waiver Form},{Waiver ID},{Waiver url}) , " 📎", BLANK() )

this feature should have been implemented by now.

+1 Please make it happen

+1 Please add this feature. It would make things a lot easier.

+1 on this please. Much needed!

6 years later... Heres to hope

+1 please