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

    Data grid with drop down, text fields and totals

    Asked by CuttingHorsesAust on February 14, 2017 at 03:20 PM

    Hello, i am new to JotForm and need a little help.  i have volunteered to do a website for a local sports club who want to accept entries online, sounds easy enough, phew!  I spent all of yesterday trying to do what they want and i am sure it can be done and am hoping someone can help me please.  this is what they want, so the first field is a drop down with the event name which feeds the entry fee value.  I just dont seem to be able to get a dropdown and text fields in a Data Grid form.  Can anyone help?  

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 14, 2017 at 05:57 PM

    We have some widgets that will allow you to display the fields as you need, for example, the configurable list will allow you to do it, here's the link to the widget where you will also find a demo form: https://widgets.jotform.com/widget/configurable_list 

    But, you cannot get a total calculated using the widget, we have also a matrix field, but it cannot have multiple field types, you can only use only use one field type with this field, here's a link that will help you to set up the matrix field and perform calculations with it: https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field 

    An option would be to use basic fields: 

    You can display them inline, as shown in your screenshot, by following this guide: https://www.jotform.com/help/90-Form-Field-Positioning 

    You could also assign calculation values to fields like drop downs, here's a guide with more info about it: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

    And finally calculate the total amount based on information entered in these fields, here's  a guide with info about it: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    If you have any question, please let us know. 

  • Profile Image

    Answered by CuttingHorsesAust on February 15, 2017 at 11:19 PM

    Thanks Kevin, got everything sorted but the sub total (total entries).  am using the calculation widget but doesnt seem to be doing what i thought.  can you please give me an idea of what i am doing wrong.  thanks once again :)

    https://form.jotform.co/70426674188868

  • Profile Image
    JotForm Support

    Answered by Charlie on February 16, 2017 at 04:39 AM

    This is because you have two extra "+" operators in the start and in the end. 

    You are basically adding nothing before the first "+" operator, and you are also doing it at the end. Remove those two and your calculation should work. Here's my test cloned form after that changed:

     

    I hope that helps. 

  • Profile Image

    Answered by CuttingHorsesAust on February 16, 2017 at 05:42 AM

    Thanks you, works great :)