I’ve been playing for quite some time now and just can’t get a result.
I want to use Airtable as an inventory management tool. In a table orders are automatically imported via the store. One row is automatically created per order. There I get the product with SKU and the associated size. My problem is that the SKU is the same for all sizes:
Product A Size 11 (SKU: 123456)
Product A Size 12 (SKU: 123456)
In a second table I have created the products and entered the stock level. Now I want the stock level to change automatically as soon as an order is received.