Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

View (group by)

124 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Community,
I need your help !

I have a webshop.
All my product and collection are sync from Shopify to Airtable.
My need : i want a view by collection and i want to see all the product in the collection.

Actually i have 2 views :

First :
One column with a list a product and one column with all the collection by line.

Capture d’écran 2022-07-06 à 22.31.34

Second view :

I have the collection on the first column and all the product associate in one line on column 2

Capture d’écran 2022-07-06 à 22.34.53

My need : i want to see my product by collection (group by)

For exemple :

Collection A :
Product A
Product B
Product C

Collection B
Product A
Product B

Knowing that there may be the same product in several collections.

Can you help me please ?

Thank’s a lot,

Matthieu

1 Reply 1

That is only possible by creating a many-to-many relationship, which requires a 3rd table.

Airtable’s guide on many-to-many relationship is here: