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

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.

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!

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.)

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

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.

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.

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.

Correct.

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.