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

    Set default values in input table cells

    Asked by iondjp on May 04, 2017 at 02:26 AM

    Is there a way to set the default values in an Input Table where the Input Type is Text Box or Numeric Text Box.

    I have found info describing how to set Calculation Values in an Input Table, so I hoped that I could set these to numeric values (i.e. 300.00, 350.00,etc) and hoped those values would appear in text box.

    But, no such luck.

    The reason for this....I want to create a simple table as a price list and then use the values in the cells in calculations (either in a condition or a Calculation Wizard field). I tried to use the spreadsheet widget for this purpose, but it does not appear to allow me to pull the values out of the spreadsheet cells to use in the Calculation Wizard or to specify the specific cells to insert as FormFields in Text areas.

    Any assistance would be appreciated

  • Profile Image
    JotForm Support

    Answered by Sven on May 04, 2017 at 03:07 AM

    Hi, 

    You can use the values in cells in an input table to perform calculations, either using the form calculation widget, or conditional logic. Here's a guide explaining how to achieve that:

    How-to-Perform-Form-Calculation-in-the-Matrix-Field

     

    I hope this answers your question, please let us know if you need any further help.

     

    Thank you!

  • Profile Image

    Answered by iondjp on May 04, 2017 at 09:19 AM

    Sorry for the confusion here...I thought I got this to work, but it appears not.

    The problem is, it appears that when you use the Text Boxes as Input Types, the values do not work.

    In fact, my testing shows the following;

    Radio Buttons and Check Boxes work as described

    DropDown Boxes will use the DropDown Options, not the Calculation Values

    The Text Box, Currency Box, & Numeric Text Box do not work for this purpose.

    I expected and hoped that the values I inserted in 'Calculation Values' would be inserted in the Text Box as the default.

  • Profile Image
    JotForm Support

    Answered by BJoanna on May 04, 2017 at 11:01 AM

    Please note that calculation values can only be assigned to check box and radio button fields. It is not possible to assign calculation values to other type of fields. 

    If you are using Number or Text box fields inside of you Input Table field, values that are entered inside of the field will be used for calculation.

    Only way to pre-populate values inside of the field is via URL parameter or with pre-populate app:

    http://prepopulate.jotform.io/

    Prepopulating Fields to Your JotForm via URL Parameters

    Here is my demo form: https://secure.jotformpro.com/71233999026967?q5_input5[0][0]=1&q5_input5[0][1]=2&q5_input5[0][2]=3&q5_input5[0][3]=4&q5_input5[1][0]=5&q5_input5[1][1]=10&q5_input5[1][2]=15&q5_input5[1][3]=20

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