JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How can I have artwork submitted to different lines, in the Excel sheet?Asked by conroeartleague 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
size name unique create
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.
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.