Hi,
I’m trying to create pages within a collection that can house user reviews and metadata. The user reviews and meta data are housed in an airtable and I’m looking for a way for a way to display those comments on each item page that I have.
Right now I have two collections. One of raw reviews and another of the item pages. I want to reference the raw reviews for the relevant item page, but I finding that I have to select each review manually to reference it on the item page. Is there a more scalable solution here?
It sounds like you are cloning the reviews into your CMS Reviews table, so that everything can be referenced from within the CMS?
If that’s the case, the pattern that may suit you better is to have the Reviews single-ref the Item. Then your collection list on your Items collection page will bind to Reviews, and filter them to Item = Current Item.
The main “work step” here is the mapping itself.
If Airtable is your source of truth and reviews are compiled there, you can either find a way to map it to the Item in Airtable before the sync, or you can do it in Webflow after the data has been imported.
I have a suspicion that PowerImporter or Whalesync may have the ability to handle slug-to-ID resolutions for you so that you can import and map data more easily.