Hello 👋
We are trying to publish new blog post articles from Airtable to Webflow using Make (Integromat).
The table for the new articles is set up identically for the fields in the Webflow CMS collection. There are quite a few fields to map, some of which are single-select and multi-select fields. (Example below)
https://ibb.co/Kyp5xQ7
These single-select and multi-select fields are Webflow collections for category and topic tags used in the articles and are multi-reference fields in the Webflow CMS. The single-select and multi-select items are set up in the same base as separate tables to the articles table. The articles table uses a link to another record field to add these to the article record.
https://ibb.co/Yjqvr2D
https://ibb.co/02Ys3x9
https://ibb.co/df7dfrB
We have added the Collection ID and Item ID in each linked record table. This is not essential at this stage, but adding new items to these linked records/collections from Airtable may be necessary. We suspect this will require a different Make Scenario to add these to the respective collections and cannot be achieved in the same workflow.
The images below show how we have set up a Make Scenario set up with an Airtable module to "Watch Records" on the articles table, with the trigger being on the Last Modified/Updated On field, the label is set on Name, and the view is set on Published. We are trying to catch the single-select and multi-select fields using Iterator, Search Records, and Array Aggregator modules. We have also shown the error codes we are getting and suspect we have not correctly set up the Iterator/Array modules.
https://ibb.co/4Jqp3vT
https://ibb.co/9nrpRDS
https://ibb.co/TqLyYJN
https://ibb.co/q0yPTBk
https://ibb.co/fvLtqZL
https://ibb.co/bXgwhBy
https://ibb.co/bHQsnF2
https://ibb.co/5jqgWXd
https://ibb.co/G0WH6NG
https://ibb.co/z8mpsMK
Does anybody have a solution to this conundrum? 🙂