Create many records from one form

Good Day,

I apologize if this has been addressed before, I can't seem to find it directly.

My project is this: I'm going to create an inventory management system that will track individually ID'd equipment, along with some parameters for each piece.

I'd like to have the ability to have a form that will allow, say, 20 pieces of equipment to be entered, and create a record based on each piece that is entered. That way, the user can barcode scan in up to 20 at a time, instead of one, then submit the form, then another, etc.

I've got a form that will allow the creation of 20, but it of course saves into one record. I can work with that if necessary, but I think it will be much better if I can separate out the records. . . is this possible?

Cheers
Michael

Hi Michael,

It's possible but not automated.

You can do it with PHP in a Custom Code action in the On Submit event of your form.

I would collect the data in an array and then look through it; for 20 or so records I'd probably build a set of 'values' to go into a single MySQL query - though you could equally do it by saving one row at a time.

Bob