Change colors on linked records

+1 on being able to add colors to linked records.


Have the labels adopt the color of the linked record should be a good first step!


I’m wondering if it’s possible to use a formula to connect each option in a single select field type to its matching field in a “link to another record” field.

Basically, we use Airtable for managing tasks across clients, and we now have three tables. One is tasks, one is a library of work we’ve completed for clients, and the last is the clients themselves. Originally we made a linked column in the tasks table that associates tasks with each client so that we could click on a client name and see all linked work from the library and all tasks across assignees, and any information for that client from the account table But! Airtable doesn’t let you color linked table fields. So everything is blue – we tried to use emojis to differentiate, but it’s not enough.

I’m wondering, is it possible to use a formula to connect single field types (one for each account) with their matching account (from a linked table column) that way we can use the colors of single field selects, but behind the scenes, it’s still linking the tasks to relevant accounts.

1 Like

There’s no way to use select options as a linked record; however, depending on your application (and, frankly, it sounds as if this won’t apply to yours) it is sometimes possible to mirror the values of a linked-record field with a single select. You can then use the single select for such things as kan ban grouping, color selection in several of the Blocks, or simply to give visual cues to a grid view.

I made use of this technique in my Black Mirror and SF Tenant Buyout bases, converting linked record fields and data fields with recurring values to single selects. Typically I did this by duplicating the field I wished to convert, changing the field configuration of the duplicate field to single select, and tweaking colors as needed.

For example, in the actual working guts of the base, the code that calculates average score and ranking for Black Mirror episodes is driven by nineteen linked records per reviewing publication. The visualizations, though, take their cues from the conversion of linked records to single selects:

All the usual caveats apply: Since the single select is not tied to the originating field, changes to one are not reflected in the other. It’s very easy to find yourself working with two discrete, divergent data sets — sometimes with no idea which is the accurate one. And, of course, this mirroring is valuable only for certain bases and situations, of which yours is probably not one.

I vote for it too :wink: . any further movement on this?


how do you use emojis in your linked records title?

@Vincent_Tang how do you use unicode symbols?

Search an emoji on and paste it in your title as any text :wink:

Le mar. 11 sept. 2018 à 06:30, Manager DGP a écrit :

1 Like

You have my vote as well. Thank you.

Just another + 1 on this…
My use case would be pretty simple.
Right now I have Notes and Contacts, and it would be great if I could pass my “note type” single select info through to contacts with its color coding such as “Meeting”, “Screening notes”, Interview feedback" so they’re easy to see at a glance. I can even pass that through currently with a formula, but it’s converted to text :confused:

1 Like

Please keep us posted on this useful feature

1 Like

So sad when I decide to change from a single/multi select to a linked record and lose colouring… Please give my workbook some colour back by giving me linked record colouring!!


+1 on this feature. It would be great, thanks!

1 Like

+100 from me - really needs this.

1 Like

Hello moderators! Any update here? Adding mine to the echos begging for this feature!
Please add colors to linked records!

I’d also love to add my +1 to this request! Any updates on if/when it could happen?

Thank you!

1 Like

A +1 from me too. This would be helpful for a base I’m using to keep track of IT equipment reservations.

1 Like

+1 to this. The option to carry color over to linked records would really help reinforce the ‘linked’ aspect…

+1 here too - for example I have a “Project” table and a “Tasks” table linked to the projects and grouped by the projects, as well as a “Supertasks” table linked to the projects to also group the Tasks - with Linked Records however the lack of pill coloration makes the view very hard to digest (lots of text)

+1 for this as well. The projects to tasks use case is big. I’m trying to create visibility for the work my team is doing by just embedding our projects table in Confluence. However, having the tasks all appear as gray boxes (ideally, they’d be color coded by their status field) makes it difficult to understand what’s going on with each project at a glance. Desperately trying to avoid having to create individual pages for each project in confluence with manual tables for tasks.