Jun 09, 2020 08:16 AM
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!
Jun 11, 2020 01:14 AM
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
Jun 16, 2020 03:40 AM
Hi Mo Thanks very much for your help! Managed to get it working eventually. Moved onto another part that is really confusing me…
Haha