Hi!
I have a question.
I want to display products that belong current category.
So, I have categories and they are linked to another record (products). I use airtable.
Can you help me with it?
Hi!
I have a question.
I want to display products that belong current category.
So, I have categories and they are linked to another record (products). I use airtable.
Can you help me with it?
Hi @anastasia ![]()
It sounds like the lookupArray formula might be helpful here.
Hi @Joyce !![]()
I record the video to the better explain.
I hope it will be helpfull ![]()
Hi @anastactia ![]()
Well done for getting this far!
You’re very close to the solution! ![]()
If you hover over the lookup formula, you will see the help text:
Notice that the second argument should be an array.
What the lookup formula does is:
value – for example a category idarray – for example a list of productskey – for example a column with the categoriesDoes that help?
Feel free to share a link to your editor on here if you’d like me to take a closer look ![]()