![Tim_Steppich Tim_Steppich](https://community.airtable.com/legacyfs/online/avatars/3X/9/6/96e29fb63e336462af6d59982bf202e3fe75de2c.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 03, 2022 12:07 PM
Hey everyone,
I’m building my database into a website and in order for me to create filters, I need a lot of data in form of multi-select fields.
I have two cases where I struggle to automate this:
- A linked record column:
I want to have whatever is in this column to always be added to a multi-select field - A roll-up field:
I want the values that the roll-up gives me to be added to a multi-select field
Currently, I need to always copy the entire column and paste it into a multi-select field. That works for now but isn’t really scalable and it’s too easy to forget / make mistakes.
Has anyone come across a way to automate this?
Thanks so much in advance!
Tim
![AirtableBuilds_ AirtableBuilds_](https://community.airtable.com/legacyfs/online/avatars/3X/7/2/72c15d5049c49bfd7ce406f76fc4682e61c222ed.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 03, 2022 07:37 PM
Hi Tim,
Airtable’s automations should definitely be able to take this manual task off your hands :slightly_smiling_face:
I would create an automation that is triggered by either the “linked record column” or “a roll-up field” being updated:
And set the action to amend the multi-select fields to the new values of the linked and roll-up fields.
And you should get something like this:
Hope this helps!
Una
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)