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

    Accessing the values in sub fields (parts of array of main tool/widget) in the form calculation

    Asked by scopa02 on February 24, 2015 at 09:03 PM

    Q: Array = Survey Tool-Matrix - Input Type: Numeric Text Box

    #input_3_0_0, #input_3_0_1, #input_3_0_2, #input_3_0_3, #input_3_1_0, #input_3_1_1, #input_3_1_2, #input_3_1_3

     

    I would like to "Update a form field value"

    Q: Choose [is equal to ] Row1

    [Add Field]: #input_3_0_2  

    Output Field: Any

     

    Right Now  Q: Array is invisible to conditionals.  I would like it to show up as a list of field values to choose from:

    #input_3_0_0, #input_3_0_1, #input_3_0_2, #input_3_0_3, #input_3_1_0, #input_3_1_1, #input_3_1_2, #input_3_1_3

     

    Likewise they should show up as output field options also.

    Page URL:
    http://form.jotform.us/form/50516546807155

    survey Numeric tool Survey Tool
  • Profile Image
    JotForm Support

    Answered by EltonCris on February 25, 2015 at 06:52 AM

    Hi,

    Unfortunately, matrix field is not supported with the calculation tool. Supported fields for calculations are text box, check box, radio button, numeric and other individual fields. However, you can always implement extra functions on your form by downloading your form source code. http://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    You can also use spreadsheet widget as it supports calculation. http://widgets.jotform.com/widget/spreadsheet

    Let us know should you have further questions. Thank you!

  • Profile Image

    Answered by scopa02 on February 25, 2015 at 02:58 PM

    Thanks!  Two issues with the spreadsheet widget:

    1. I can't get any default value to display after initial setup. I would like it to look like the Array question in the form.

    2 Widget is supposed to have line separated values; Show Properties will not allow line separation. (As soon as you open Properties all line returns are removed and can't be re-added.)

     

  • Profile Image

    Answered by scopa02 on February 25, 2015 at 03:06 PM

    Sorry, One more - How do I access individual cell values? Conditional wants to pull in the whole spreadsheet?

  • Profile Image

    Answered by Ben on February 25, 2015 at 05:15 PM

    Unfortunately you are not able to access individual cells of the spreadsheet widget through the conditions, but as mentioned by my colleague, you can make the calculations within the jotform itself.

    Do let us know if you are still interested in spreadsheet widget and I will move the 2 questions to a new thread and help you with resolution of each.

    Otherwise the only alternative would be to use Full Source Code of your jotform as mentioned by my colleague Elton above and then embed the missing / required functionality.

  • Profile Image

    Answered by scopa02 on February 26, 2015 at 05:13 AM

    Thanks anyway. You guys have great support!

    I don't need calculations. You don't have a separate "Copy field" conditional. I was really looking for an array that could be loaded with defaults and individual cells accessed.

    i.e. If radio button above is equal to row1:

    set ouput1 to be row 1 & column 1 value

    set ouput2 to be row 1 & column 2 value, etc. one condition for each column in the array

     

    I can still do it. It just means for a 6 x 4 array I need to create 24 individual question fields with individual defaults. instead of one "6 x 4 Array Widget" with a list of defaults.

  • Profile Image

    Answered by Ben on February 26, 2015 at 09:14 AM

    Thanks anyway. You guys have great support!

    Thank you :)

    I don't need calculations. You don't have a separate "Copy field" conditional. I was really looking for an array that could be loaded with defaults and individual cells accessed.

    Could you please confirm following:

    You would like to be able to access each field / option of a complex field, such a address, full name, spreadsheet, etc

    #input_3_0_0, #input_3_0_1, #input_3_0_2, #input_3_0_3, #input_3_1_0, #input_3_1_1, #input_3_1_2, #input_3_1_3

    To be able to use #input_3_0_0 and #input_3_0_1 in calculations?

    If that is correct (I just wanted to make sure that I understand it correctly) we will raise this as a feature request to our developers to have it implemented.

    While we can not tell you that this will surely be implemented, or when it would, if our developers implement it they would update you about it through this thread.

  • Profile Image

    Answered by scopa02 on February 26, 2015 at 03:37 PM

    Correct.

  • Profile Image

    Answered by Ben on February 26, 2015 at 04:50 PM

    OK, great, thank you for the confirmation. I will now raise this to our developers and as soon as it is available they will update you through this thread.