- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2025 10:05 PM
Hey everyone! I have the following challenge in airtable:
I have 3 bases and tables:
Catalog: Products, Categories, Groups
Inventory: Products (synced with the products table from Catalog), purchase orders, purchase order items
Orders: Sales Orders, Sales Orders Items, Products (synced with the products table from Catalog)
In inventory, In the table "Products" I'm calculating the available inventory based on the Purchase Order Items quantities in a column called "Available QTY", but my issue is: how can I add a column called "Sold QTY" which sums the product quantities from the table "Sales Order Items" from the base "Orders"?
When I sync the sales order items into Inventory, the issue is that makes me sync also the Products table from Orders base. So I end up syncing 2 times the products table in the inventory base and the rollup doesn't work because each table is referencing different synced "Product" tables
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2025 11:12 PM
Hmm, when you sync the Sales Orders Items into Inventory, what if you used an automation to link the new record to the synced 'Products' table based off of the Product data? Then you'd be able to create that 'Sold QTY' rollup?
