Dynamic addition of a set of similar fields in the forms?

  • Profile Image
    skrishna
    Asked on November 08, 2015 at 03:06 AM

    Hi there,

     

    Please see the screenshot attached. I was wondering if there was a way to hit  + or ADD button in JotForm and dynamically create a set of similar fields so that users can add multiple items one below the other? 

     

    The Line# set of rows is what I want. So users would use the + to continue adding new set of 5 fields.

     

    Any thoughts?

     

    Thank you.

     

  • Profile Image
    jonathan
    Answered on November 08, 2015 at 03:37 AM

    Hi,

    You can use widgets instead to achieve this.

    You can find them here link: http://widgets.jotform.com/category/multiple_entries

    Example:

    Dynamic Textbox - http://form.jotformpro.com/form/51233651283955?

    Configurable List - http://form.jotformpro.com/form/43222928180957?

     

    Hope this help. Let us know if you need further help.

    Thanks.

     

  • Profile Image
    skrishna
    Answered on November 10, 2015 at 04:14 AM

    Hi Jonathan - That is very useful indeed. Works well!

    One more question: Is there way to SAVE the submissions coming in in some sort of CSV or XLS automatically? I know emails are sent but any other storage possibility?

     

    Thank you.

  • Profile Image
    Sammy
    Answered on November 10, 2015 at 05:26 AM

    You can integrate you form to google spreadsheets so that the submissions are synced to it automatically as they come in.

    http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

     

    There is also an option to export the submissions to an excel or CSV file under the form submissions section.

  • Profile Image
    skrishna
    Answered on November 10, 2015 at 06:07 AM

    Thank you Sammy. I figured it out.

    Final question: Is there a way to make one of the headers in the matrix a dropdown box with pre-set values?

     

    I am using a Matrix Dynamique widget.

     

    Thanks.

  • Profile Image
    Charlie
    Answered on November 10, 2015 at 09:10 AM

    Unfortunately, the Matrix Dynamique widget only has a fixed static text on the column headers. Same with the other dynamic widgets, however, in the Configurable list widget you can set different input types on each column.

    I hope that helps.

  • Profile Image
    skrishna
    Answered on November 11, 2015 at 01:35 AM

    Hi Charlie - Thank you. This is helpful. One last question:

    Can all of the fields in that matrix be made required? The problem is that if I fill up even just one column it accepts the entire widget.

    Any thoughts?

    Thanks.

  • Profile Image
    skrishna
    Answered on November 11, 2015 at 01:40 AM

    Never mind. Figured it out. :)

     

  • Profile Image
    Charlie
    Answered on November 11, 2015 at 02:51 AM

    Glad to hear that you have already figured it out. I presume you are referring to the Configurable list widget? That should be possible there as mentioned in this guide.

  • Profile Image
    skrishna
    Answered on November 15, 2015 at 12:24 AM

    Hi Charlie - Yes.That was the one.

    LAST QUESTION : I know I know :P

    This is my form now:

    https://form.jotform.me/53130227893454

    Is there a way I can dynamically calculate Shipping Cost by the following formula for each row?

    (Qty x Unit Price) + 30% if Currency is NOT QAR ?

    It would be great if the value got automatically updated in that field every time data was added. Any way to make that conditional logic work?

    I have connected the results to a Google Sheet where I have written a script. But since data comes in a single cell, parsing it is becoming a bit of an issue. So was wondering if this form can do it for me instead.

     

    Thanks!

  • Profile Image
    Kevin_G
    Answered on November 15, 2015 at 11:00 AM

    Hi,

    To assist you better, I've moved your question to this thread : 

    http://www.jotform.com/answers/705058

    I will answer there.

    Thanks.