Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Can we batch add/delete multiselect, member, or cell reference entries?

Topic Labels: Data
66 1
Showing results for 
Search instead for 
Did you mean: 

I'm making up the example, but it's a lot simpler than my actual use case: Let's say I've got a table with a large menu of dinner items. I have a column of food preferences (vegetarian, vegan, gluten-free, etc) which is a multi-select field. Now let's say someone points out that it would be a good idea for me to track what options are halaal or kosher. I would like to be able to select all of the menu items that are appropriate and add "kosher" or "halaal" to only those items, without overwriting the current values (vegetarian, etc). What's the best way to do this? I think this would also affect any property that functions like multi-select, most importantly links to another table.

1 Reply 1

For multi-selects Airtable's Batch Update extension works

For links, you'd probably need to do some workarounds involving formula fields / automations I'm afraid