- conroeartleagueAsked on January 24, 2016 at 11:45 AM
I need the output on a spreadsheet to create mail merge labels and lists. Below is a link on Jotform.com to the form I created; however, it won't work because I need a separate row for each piece of art for each artist. In a relational database, you would create a separate table with a key field such as the artist's full name. Multiple artwork entries must be allowed. This is a "many-to-one" relationship.
Below (and also attached) is an Excel pdf excerpt from a previous show in the format I need it downloaded from Jotform.
First Last Home Artwork Title Div Cat Medium Size Price Jane Adams CAL Sweet Zone III B Acrylic 18 x 28 x 1 300 Carrie Brown CAL Ancient Messages I E Acrylic 31 x 36 x 2 500 Carrie Brown CAL Boot Scooten Boogy I B Watercolor 36 x 32 x 2 400 Carrie Brown CAL Middle Earth Ii I H Acrylic 29 x 37 x 2 2000 Nancy Smith CAL Early Morning, Alpine, TX III B Watercolor 17 x 14 x 1 Nancy Smith CAL Ft. Bragg Cliff III B Watercolor 28 x 25 x 1 600 Nancy Smith CAL Moved On (old adobe) III B Watercolor 12 x 10 x 1 200
- CarinaAnswered on January 24, 2016 at 01:48 PM
Each submission will create one line in the spreadsheet. This means that in order to have the same artist with several rows he will need to make several submissions.
I will work on a workaround that allows several submissions, but without the user having to fill in the form multiple times.
I will let you know as soon as I have a solution.
- CarinaAnswered on January 24, 2016 at 03:43 PM
I cloned the form and added a radio-button field so that user can select if he wants to add another artwork.
I added a condition so that if "add another artwork" is yes, than change thank you page url:
The thank you page is the same form but with url parameters so that the form gets pre-populated with fields like the name:
You can test and clone the demo form:
You can see here more details on how to use url parameters:
Let us know if we can assist you further.