Katlyn,
- Do you have Pipelines yet? During the webinar they said there was going to be a For Next loop. If it really will loop on a field [Quantity] creating child records, this is easy.
- PHP Script. This would be a simple script for someone familiar with the Quick Base API
On a related note what is your architecture for the Inventory Transaction? What do your tables look like to manage increasing and relieving the Inventory? Does your structure allow you to enter a record with a quantity and serial number at the same time? The downside is that you could have:
Record ID#: 1234
Quantity : 2
Serial Number: 654321
The system would claim that you have two parts with the same serial number. At year end when you have to do Inventory Adjustments after a count, you ability for those offsetting transactions would be very difficult.
Good luck and I hope the design question is helpful now while you are building instead 12 months into operations.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Original Message:
Sent: 03-04-2020 16:42
From: Katlyn Allen
Subject: Inventory Troubles
I am in the process of building an app to track inventory. The biggest problem that I face is that some items are tracked by serial number, while others are tracked by quantity. I want to be able to use my Purchase Order table to input the quantity purchased, then create that many new records in my inventory table (where I can input the serial numbers if need be) when I click a checkbox. Alternatively, I wouldn't mind inputting the serial numbers in the PO, but quantities could range from 1-200, and creating 200 separate "serial number" fields (and then automations after) seems like a lot of extra work that can probably be avoided.
------------------------------
Katlyn Allen
------------------------------