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

    Can I create multiple submissions from one submission determined by multiselect?

    Asked by duncan_macdonald on July 20, 2014 at 01:46 AM

    HI,

    Is there any way to allow multiple submission creations from one form submission based on multi select of values?  For example on my form I would like someone to be able to select paddocks 10,11,12 and relevant data which applies to all three paddocks and then press submit to create individual submissions for paddock 10, another for paddock 11 and another for paddock 12.  Currently I get one submission with paddocks listed as 10,11,12.

    I am linking my form to a google sheet and it is much easier to handle the data with a different row for each item selected, however for the user it is much easier to enter multiple items on the same form. 

    An example of my form where I have been playing with different pdk select options is below.

    https://secure.jotform.co/form/41613314930850

    Thanks

    Duncan

    Submissions create JotForm multiple submission different
  • Profile Image
    JotForm Support

    Answered by jonathan on July 20, 2014 at 03:19 AM

    Hi Duncan,

    I am linking my form to a google sheet and it is much easier to handle the data with a different row for each item selected, however for the user it is much easier to enter multiple items on the same form. 

    Unfortunately, the setback will be here. As each row in the integrated Google sheet will be equal to each submissions. Meaning, the only way to have new row/record in the spreadsheet is to have submissions (each submission is equal to row)

    But I think it will be easier if you use the Multiple Selection Widget to allow a single field to have multiple answer.

    When using this widget, the data will appear as single column in the spreadsheet with multiple data separated by comma. 

    Tell us if this widget can work already for what you need.

     

    Thanks.