I have a list of video assets that I was originally tracking in Google Sheets. I have three sheets/tables- the first table has the main data and the following tables include tags for the videos. All the records on all three tables are the same, they just have different tags. I couldn’t link the records in Sheets and so I was manually updating the records with the tags. Now I’ve discovered Airtable and this would have made my life a million times easier. So, I need to convert those other tables into a new field and this will solve the issue of this table being too big (too many records).
Because I was using Sheets, on the tags sheets, each tag is a column/field. It should just be 1 field that is multiple select that I just choose which tag applies to that video. I’ve converted one table to single select and fixed the labels, but now I need for those single select fields to all combine into one field that can become a linked record. Do I use rollup? I really don’t know what to do.
I could go through and individually pull those tags into that one field, but there are over 500 records and I don’t have the time to do that. Help!