A formula to associate two differents arrays?

Hello everyone :slight_smile: ,

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": [{
   "name": "category name",
  "products": [
                     {
                       "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.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.