Re: How to automatically create and update a multi-select field based on a linked record or a text field

1027 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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:

  1. A linked record column:
    I want to have whatever is in this column to always be added to a multi-select field
  2. 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!

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Screen Shot 2022-02-04 at 1.20.21 pm

And set the action to amend the multi-select fields to the new values of the linked and roll-up fields.

Screen Shot 2022-02-04 at 1.20.31 pm

And you should get something like this:

automation (1)

Hope this helps!