I’m working on a booking website whereas I push data from a airtable table to Webflow CMS with Zapier.
Now I got most of it working but I have a column in airtable that is set a “multiple select” column that gives an error when I’m trying to push this. (The app returned “ValidationError: Validation Failure”.)
Within webflow CMS I have a collection that is being used for a multi reference field within the main collection. In the main collection the multi reference field values are empty as I want to push them into this field from Airtable.
Do multiple select columns work with the Airtable → Zap → Webflow CMS integration?
If not, does anyone have a good Idea to get this to work? I don’t want to have multiple columns for each of these variables.
I have the same issue, did you manage to sort this out? I already have the collection data in webflow for the multireference fields, I set up multiselect in airtable and matched the names. But I get the Validation Failure when testing the Zap.
I managed to sort this out for my validation failure. What you need to do in Airtable is reference the webflow ID. So in my example I’m selecting a category in webflow. I set up a new table in Airtable for Categories. I listed the name and the specific webflow ID for each category. You can get this from the CMS record for each category. I now reference that field for the new item I’m entering in Airtable. So I pick the category in the items airtable record which does a lookup on the other table and populates the webflow ID in that table view. Now when I enter my Zap instead of using the name of the category to send to webflow, I use the webflow ID for that category. Hopefully this helps you or someone else trying to select a reference field in webflow via airtable.