Mar 28, 2023 12:32 PM
Solved! Go to Solution.
Mar 28, 2023 10:50 PM
There are two scripts in the marketplace that might do what you're looking for:
Mar 28, 2023 12:46 PM
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!
Mar 28, 2023 01:15 PM - edited Mar 28, 2023 01:16 PM
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!
Mar 28, 2023 10:50 PM
There are two scripts in the marketplace that might do what you're looking for:
Mar 28, 2023 11:44 PM
Super! That's what I was hoping existed! Thank you so!