Hi,
I have a field which is multiple select in the airtable, and for one record there are 119 selections to be made. Is there a way to load them in go, than adding every single option under multiple select for that particular record. thanks
+5Hi Deepthi,
Here is what I would recommend.
If you've got a multi-select field in Airtable and you're tired of manually adding each option one by one, here's a quick and easy trick.
Copy and Paste: Copy the list of options you have, whether it's from Word, Excel, or any other source.
Paste into Airtable: Paste those values right into your multi-select column. Now, Airtable will ask if you want to expand the table. Go ahead and say yes.
Dropdown Delight: Voila! Your dropdown list now boasts all 119 options. How cool is that?
Clean Up Time: You can now do a little cleanup – delete the 119 rows or records that popped up during your copy-paste extravaganza.
Hope I hit the bullseye with your question! If not, no worries! Feel free reach out with a reply or any questions. Here is how you can get in touch: prosperspark.com
Take care!
+2Hi,
Thanks for the response, I tried it. 119 options got added to the list by follwoing the steps.
Still I have to select the 119 options for that particular record by hitting add button each time.
+25Hi,
Thanks for the response, I tried it. 119 options got added to the list by follwoing the steps.
Still I have to select the 119 options for that particular record by hitting add button each time.
a short morning mind exercise, with this little script as a result
You should just adjust Table name in code, Run, and choose field / record.
let table=base.getTable('Table1')
let field=await input.fieldAsync('pick multiselect field',table)
let record=await input.recordAsync('Choose record',table)
if(field.type!='multipleSelects') throw new Error('Field must be MultiSelect')
let allItems=field.options.choices.map(choice=>({name:choice.name}))
if(record) await table.updateRecordAsync(record.id,{[field.name]:allItems})
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.