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

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

    Asked by skrishna 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.

     

    addition dynamic fields
  • Profile Image
    JotForm Support

    Answered by jonathan 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

    Answered by skrishna 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

    Answered by Sammy 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

    Answered by skrishna 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
    JotForm Support

    Answered by Charlie 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

    Answered by skrishna 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

    Answered by skrishna on November 11, 2015 at 01:40 AM

    Never mind. Figured it out. :)

     

  • Profile Image
    JotForm Support

    Answered by Charlie 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

    Answered by skrishna 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
    JotForm Support

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