Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 30, 2021 01:18 PM
Is it possible to manage an inventory within Airtable and show a beginning and ending amount on a sales order form?
Apr 13, 2021 10:35 AM
Hello @Scott_Noll!
It is possible to manage an inventory in Airtable using multiple tables. The usual workflow for this kind of situation would be to have a table for each product, client, and sales order (as a many-to-many relationships / junction table). You could track each sales order date fields and the number fields can track how much is due for each sales order.
I recommend checking out our Inventory Tracking Template as an example for an Inventory management workflow in Airtable.
Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .