What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    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

     

     

     

     

                   
                   
                   
                   
                   
                   
                   
                   
    Page URL:
    https://www.jotform.com/?formID=60065664072150

    Screenshot
    size name unique create
  • Profile Image

    Answered by Carina 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.

  • Profile Image

    Answered by Carina 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:

    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.