Change colors on linked records

[Vincent_Tang]

I can’t seem to figure this out. Normally on “multiple select” or “Single select” options, changing colors is fairly easy

however with linked tables, the colors are always blue. Cannot find any options to change it

I found this support thread here, but it wasn’t answered either

Show Link to record/table list as colored? Ask the community

When using Link to another record/Link to table option, is it possible to show the list as colored similar to how the options look in the Multiple select option?

is this a supported feature?

Reference:

[Matt_Bush]

No, this is not a supported feature at this time. We’ve heard this request a few times and are considering ways to support it in the future.

[Vincent_Tang]

okay thanks for the update

[Florian_Gouy]

Hey Vincent,

I also miss this feature.
Nevertheless, I found a workaround which could help you:
Use some emojis in your linked records title (see https://emojipedia.org)

Have fun with Airtable :winking_face:

Best regards,
Florian

[Vincent_Tang]

ah okay I could use unicode symbols as well forgot about those

:zap: ✪ ◆ ✗ ✓

[Dave_Thorne]

It would also be useful to be able to show the linked records shaded different colours depending on their status. For example in my Suppliers’ Table I have a column which is linked to the table containing invoices from the suppliers but once these invoices are paid and the date is added to the invoice on the invoice Table it would be useful to signify which invoices are outstanding or paid in the linked table column of the Suppliers’ Table.

Better still it would be good to be able to link to a view of a Table so I could have a view just for outstanding invoices not those that have been paid.

[Elias_Gomez_Sai]

And why not Gouping, Filter, or even creating a View for them? :thinking:

Dave_Thorne:

Better still it would be good to be able to link to a view of a Table so I could have a view just for outstanding invoices not those that have been paid.

You can already to that based on a Expected Payment Date field, for instance.

[Dave_Thorne]

Thanks for replying but not sure I understand your post, I want to be able to see on the Suppliers’ Table either a visible indication of the status of their invoices in the Linked Table column or an option to choose which ones I see by linking to a View of the Invoice Table.

[Elias_Gomez_Sai]

So you have a Suppliers table, with a Linked Record field to connect with Invoices table, isn’t it? And you have several Invoices linked to every Supplier. So, you could have:

• All Invoices paid
• Some Invoices paid, and others not paid
• None Invoices paid

So you can’t do this:

Dave_Thorne:

see on the Suppliers’ Table either a visible indication of the status of their invoices

You could have a Field indicating if there is a pending Invoice, for instance.

Dave_Thorne:

option to choose which ones I see by linking to a View

You cannot do this neither, because the Linking field is like an auxiliary field, like a ghost :grinning_face_with_smiling_eyes: You have to work with Invoices in the Invoices table. You could Filter them (and even Group by Supplier) in a new View, to see only pending ones.

Also, in the same way, you could create a new View in Suppliers table, seeing only those with pending Invoices (but in the Invoices linked record field you will see ALL the invoices related to that Supplier).

[Dave_Thorne]

Thanks again

Also, in the same way, you could create a new View in Suppliers table, seeing only those with pending Invoices (but in the Invoices linked record field you will see ALL the invoices related to that Supplier).

The only problem with this solution, if I have followed it correctly, is that the invoices that now appear in the Pending Invoices (Lookup) column in the Suppliers’ Table are not links to those invoices.

[Elias_Gomez_Sai]

Afaik, you can’t create a Lookup on Suppliers table to get ONLY the unpaid Invoices. How have you done that? :thinking:

I’ve made this demo base, maybe it clarifies a little bit:

Airtable

Suppliers Invoices - Airtable

Explore the "Suppliers Invoices" base on Airtable.

It has 2 Views on Suppliers:

• More Invoiced, all records orderer by Number of Invoices. Even you could have a Amount field in Invoices, and Sum all amouts per Supplier, and order Suppliers by more Amount invoiced.
• Due Invoices, where I have Filtered to see only Suppliers with due Invoices, ordered by Count of Invoices due. Also, you could order it by Total Amount doing the same as before.

It has 2 Views on Invoices:

• All, ordered by Due Date.
• Due, only due Invoices grouped by Supplier and ordered by Due Date.

You also could create Amount field and order by it, and do many many more things.