Counting Products used on table

[Jonty_Thomas]

Hi!

I have a Base where we get new orders come through on one table. We then pick products to add tot the order afterwards, and do that in new fields to the right. Item 1 as a field, Item 2 as a field etc. I’m trying to work out how I can do a stock count on another table to keep tracking of how many of each product I’m allocating (so I dont run out!) But can’t work out how!

I would normally just do a count function with a lookup of the product if I was in a normal spreadsheet but lost as to how to do it here! THanks!

[Mohamed_Swella1]

Hi @Jonty_Thomas,

Welcome to Airtable Community ! :slightly_smiling_face:

In Airtable, you need a Junction Table to achieve something like that, it is not practical to have each item in a separate field I guess.

You can check this post for more details on how to setup a Junction Table.

If this helps you, please mark this as Solution so others can see it.

BR,
Mo

[Jonty_Thomas]

Hi Mo Thanks very much for your help! Managed to get it working eventually. Moved onto another part that is really confusing me…
Haha