I have 2 forms, "Lots" and "Mass Create Lots".  I would like to create X number of lots based on the criteria placed in the following form. This will be a useful tool to avoid the manual creation of Lots in the system. I think the best way to accomplish this would be through a Function that fires on submitting a Mass Create Lots record, but I am open to other ideas.

I would also like  Lot Number to increase sequentially always starting at 1.