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

  • Profile Image
    duncan_macdonald
    Asked 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

  • Profile Image
    jonathan
    Answered 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.