How can I have artwork submitted to different lines, in the Excel sheet?

  • conroeartleague
    Asked 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

     

     

     

     

                   
                   
                   
                   
                   
                   
                   
                   
    Jotform Thread 754502 Screenshot
    Page URL: https://www.jotform.com/?formID=60065664072150
  • Carina
    Replied on January 24, 2016 at 1: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.

  • Carina
    Replied on January 24, 2016 at 3: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:

    How can I have artwork submitted to different lines, in the Excel sheet? Image 1 Screenshot 20

    The thank you page is the same form but with url parameters so that the form gets pre-populated with fields like the name:

    https://form.jotform.com/60236405669963?lastName={lastName}&firstName={firstName} 

    You can test and clone the demo form: 

    https://form.jotform.com/60236405669963 

    You can see here more details on how to use url parameters:

    http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters 

    http://www.jotform.com/help/351-How-to-automatically-pass-form-data-to-another-form 

    Let us know if we can assist you further.