Data grid with drop down, text fields and totals

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

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

    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: 

    An option would be to use basic fields: 

    You can display them inline, as shown in your screenshot, by following this guide: 

    You could also assign calculation values to fields like drop downs, here's a guide with more info about it: 

    And finally calculate the total amount based on information entered in these fields, here's  a guide with info about it: 

    If you have any question, please let us know. 

  • Profile Image
    Answered 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 :)

  • Profile Image
    Answered 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 on February 16, 2017 at 05:42 AM

    Thanks you, works great :)