I am looking to have the user enter the qty of records to add to the database and also a starting s/n.

I would like the user to be able to submit the request and then the records are created in the database.

example: 5 records with starting s/n 5659

database records to be made: 5659,5660,5661,5662,5663

this is an appconnect page with php serverconnect actions.

Create an INTEGER field and make it auto-incremental. You could even use the ID field, starting with 5659.

the s/n is not always incremental... the next entry could begin with a different number...

ie 1- 5656

then next user could be 2125 - 2123 ; 3256, 3159 ect....

i was thinking of this method:

post qty of records & staring number

then use the repeater function [not sure how to have it run for '$post.qty' value]
then in each repeat have a insert task that will post the record with the sn + $index, so it will be sn 1 [1+0] then sn 2 [1+1] then sn 3 [1+2] ect until the repeat ends.

Hello Carlin,
Check this tutorial please: www.dmxzone.com/go/32972/inserting-multiple-database-records

As for the serial number increment - yes, just use value + $index.

Teodor,

I set the s/n to be $post.value + $index but the results were

93410 , 93411, 93412 ect when it should be: 9341, 9342, 9343 ect

also how to do i set the repeat expression to run only based on the $submit.qty value... I used {{$_POST}} and it ran the number of items passed in the post.

I already made the form so do not need the builder... plus the video shows it will just make a form that has x number of duplicate fields.. and I do not want the user to have to enter the date over and over... all the submitted fields are the same for each insert except for the s/n as that should auto increase on each pass of the repeat...

$post.value + $index must be $post.value.toNumber() + $index as form field values are always strings, and need to be converted to numbers.

I don't really understand what you mean for the form repeat?? The video shows what exactly you need in order to create a multi insert form.

Ah, sorry i got your idea now.
All you need is a repeat step in the action file and put the insert step inside it.
The repeat expression is the value of the field, where the user enters how many records to insert.

This reply was removed on 3/8/2018 1:32:23 PM.
See the changelog

ok, the number thing is working now. but the repeat only runs once. I am only passing a single item with a value greater then 1.

got it to work. had to add .toNumber() to the expression.

ok, the piece to my puzzle is this:

{{$_POST.snprefix + $_POST.serialnumber.toNumber() + $index}}

snprefix is a string ie, 2018- or A- ect...

got it to work,

{{$_POST.snprefix}}{{$_POST.serialnumber.toNumber() + $index}}

Thank you for sharing the result!