Skip to main content
Is it possible to export a multiple select list in one field into a separate table?
 
For example, I have a field in one table that is a Multiple Select field of Categories. I want take that list of Category options and export that list (i.e. each option as its own record) into a separate Table so I can further work with that data.
 
Is this possible?
 
Thank you in advance for any ideas!

If I understand this correctly, you want to view the data associated with each category in a separate table. 

Create a new table within the same base, create a new linked field between the two tables, in original table copy data from Categories field to linked field for the new table. Airtable automatically seperates multi-select items using comma. When you copy paste fields in a Linked Type field it will populate as individual records.

Happy to help!

Harleen


If I understand this correctly, you want to view the data associated with each category in a separate table. 

Create a new table within the same base, create a new linked field between the two tables, in original table copy data from Categories field to linked field for the new table. Airtable automatically seperates multi-select items using comma. When you copy paste fields in a Linked Type field it will populate as individual records.

Happy to help!

Harleen


Thanks for your idea, Harleen. But unfortunately, I don't think my question was clear though.

I don't want to copy the individual record data from the Categories Field that is in one table to another.

I want to export the List that is created inside the Multiple Select Field for the Categories (ie list that user pulls down to select a Category - such as Personal, Business, Other). Then have each Category be a record in another Table that would be in its own Table entitled "Categories".

Hopefully that is a little clearer. Thank you again for your help!

 


Thanks for your idea, Harleen. But unfortunately, I don't think my question was clear though.

I don't want to copy the individual record data from the Categories Field that is in one table to another.

I want to export the List that is created inside the Multiple Select Field for the Categories (ie list that user pulls down to select a Category - such as Personal, Business, Other). Then have each Category be a record in another Table that would be in its own Table entitled "Categories".

Hopefully that is a little clearer. Thank you again for your help!

 


There are two scripts in the marketplace that might do what you're looking for:

  


There are two scripts in the marketplace that might do what you're looking for:

  


Super! That's what I was hoping existed! Thank you so!


Reply