How to Populate Multi-Select Field in Airtable with Make.com
Have you ever tried to populate a multi-select field in Airtable using make.com with array data from a form? If you have, you might have found that you can update a single value using make.com but updating all the values in the array can be a bit tricky. Don't worry, we've got you covered!
Problem
The challenge here is to find a way to update all the values in the array with one record update. If that's not possible, we need to figure out how to iterate through the array to make multiple single updates.
Solution
The solution to this problem is actually quite simple. You just need to use an array as the value for the field. If you have a comma-separated string of values you want to add, you can split them into an array using a split() function. Then, submit the result of that as the value for the multi-select field.
Step-by-step guide
- Take your comma-separated string of values.
- Split them into an array using a split() function.
- Submit the result as the value for the multi-select field in Airtable.
Troubleshooting
If you're still having trouble, make sure that the values in your form match the values set up in the multi-select field in Airtable. Also, check that you're correctly using the split() function to turn your string into an array.
Conclusion
And there you have it! With these simple steps, you can easily populate a multi-select field in Airtable using make.com with array data from a form. Happy making!
You do have further questions?
Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.