Welcome to the community, @Laura_Gluhanich!
Great news for you — you can do this in a matter of seconds, with no scripting required.
Simply duplicate your field 2 times, so this field shows up a total of 3 times in your database. Be sure to choose the option to “duplicate cells” as well. (After duplicating the fields, you can rename the fields to more accurately describe what you want each of them to represent.)
Then, for each of these 3 fields, customize the field & delete the multiple-select options that you no longer want to appear for that particular field.
After you save the field, Airtable will automatically go through all of your records and remove the data from the records that no longer match any of the remaining multiple-select options.
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question.
Welcome to the community, @Laura_Gluhanich!
Great news for you — you can do this in a matter of seconds, with no scripting required.
Simply duplicate your field 2 times, so this field shows up a total of 3 times in your database. Be sure to choose the option to “duplicate cells” as well. (After duplicating the fields, you can rename the fields to more accurately describe what you want each of them to represent.)
Then, for each of these 3 fields, customize the field & delete the multiple-select options that you no longer want to appear for that particular field.
After you save the field, Airtable will automatically go through all of your records and remove the data from the records that no longer match any of the remaining multiple-select options.
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question.
Thanks so much! Makes sense and I should have realized based on the combining I’ve done the past few days