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

Inventory Managment

Topic Labels: Automations
270 1
Showing results for 
Search instead for 
Did you mean: 

Is it possible to manage an inventory within Airtable and show a beginning and ending amount on a sales order form?

1 Reply 1

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: .