Inventory Troubles

If I were doing this with a client, I would make a table of records numbered from say 1 to 1000. Call this Serial Source. 

Then I'd make a formula URL button to set a value on a focus record with the values needed to create the child records and then look those up down to the Serial Source table and then execute a saved table to table import. 

This would be all in one click. It's too much explanation to provide all the code if you have not done URL formula buttons before, so I'd probably need to have you book an hour or so with me to get this working. 

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Katlyn,

1. 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.
2. 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
------------------------------