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