
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2022 07:05 AM
Hi
I have a table with a lookup from another table in a grid view in which the result is Brown. When I go to the calendar view to select the field for the color, it’s not in the list of options.
Thank you!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2022 07:23 AM
Yeah, Airtable’s lookup fields will convert your single-select field to an array, so you’ll have to manually create all of your coloring criteria from scratch.
You may want to bring up this issue to support@airtable.com, so hopefully they can improve this behavior in the future.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2022 09:10 AM
As @ScottWorld said, there’s no default way to do this.
However, there is a workaround that, while a little clunky, definitely will accomplish what you’re looking for. It requires setting up an automation that watches for when a record is linked, and then copies the linked color to a single-select field in the same table as the desired calendar view.
Here’s a quick walkthrough I recorded on setting this up for your base.
Hope this is helpful,
Paul

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2022 11:24 AM
Hi Paul
Thank you so much for taking your time to make the video. I am new to AT but I will give it a try tonight.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2022 04:42 PM
This is a fantastic workaround! Sorry I didn’t mention this earlier, @Russ_Keitel!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2022 05:21 PM
Oh no problem. I just appreciate the the incredible support from the people here
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 11, 2022 06:33 PM
Hah, that’s brilliant
