Thanks for the quick response Sachi.
So far have:
- Like-for-like Airtable tables & columns matching CMS collections & fields
- Airtable IDs for each row using RECORD_ID()
- All raw data from each Webflow collection
- Pulled in every table to a Parabola flow, excluding all values except Airtable ID, Webflow ID and Webflow Multi-reference fields (but the problem is these are read in from Webflow’s Data as the slug, not the ID)
i.e.
At this stage the Multi-reference fields get pulled into an Airtable record as:
- Suburb CMS Item “Canada Bay” is read in as ‘canada-bay’ without a Webflow ID next to it
Is there a reliable and accurate method to matching “canada-bay” (and the other suburbs in the comma-separated-values) back to the suburb name and ID in a mapping table via Parabola?
What I was thinking is:
- 99% sure it’s always going to match the slug field from Webflow’s data export.
- Perhaps it’s about creating a column where the slug & Webflow + Airtable IDs are mapped back to that? Not sure if this is conventional or if there’s a more reliable way to do it.
Here are some screenshots below for your reference.
Thanks in advance!
