Hello everyone ,

I’m using airtable with graphql and i need to do a product list with ITEMS & LINKS (those are Lookups from two fields of my PRODUCTS table)

Here is my table (CATEGORIES table):

https ://image.noelshack.com/fichiers/2020/01/7/1578236429-capture-d-ecran-2020-01-05-a-15-44-28.png

(delete space after https, links seems to be forbidden)

In the formula field, i’m looking for a solution that can do something like that but i’m stucked

"allCategories": i{

   "name": "category name",

  "products": c

                     {

                       "item-1",

                       "link-1"

                     },

                     {

                       "item-2",

                       "link-2"

                       },

                      ]

                     },

                   ...

                  ]

As it’s my first website with Airtable, i don’t know how to proceed. May i can sort the data directly in airtable, may i can do this in my vue.js app with some function filtering data. Any tips ?

Hope it’s understandable for you guys, thank’s in advance.