I have some experience with relational databases (Access/Quickbase) but was intrigued with airtable capabilities. I am trying to create an inventory management solution to fulfill my orders that come from shipstation. I already know I can import orders from shipstation into airtable by way of zapier. Most of the functionality I need I already know exists in airtable. My javascript skillset is limited. My question is there a way to implement asking somebody to input a list of unique serial numbers(could be hundreds of those at a time) and then associate those serial numbers with either an order or a purchase order? Then mark those serial numbers as either in stock or out depending on whether it is a PO or an Order?
