Displaying data

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?


1 Like

Hi @anastasia :wave:

It sounds like the lookupArray formula might be helpful here.

Hi @Joyce !:slight_smile:
I record the video to the better explain.
I hope it will be helpfull :slight_smile:

Hi @anastactia :wave:

Well done for getting this far!

You’re very close to the solution! :grinning:

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:

  • look for a value – for example a category id
  • in an array – for example a list of products
  • based on a column name or key – for example a column with the categories

Does that help?

Feel free to share a link to your editor on here if you’d like me to take a closer look :slight_smile: