Configurable List: perform calculations with data in the list

Hello,

I've been working on trying to calculate values in configurable lists. As the numerous posts (see end) mention, this seems impossible, but there have been many feature requests.

However, being stubborn, I started to play with configurable lists and conditions. I notice that you can copy the contents of a lists into a text box.

The entries on the same "row" of the list are separated by commas, but subsequent rows are merged together. The addition of a static field provides a pseudo-delimiter.

Example: adding 1, 2 on first row and 3, 4 on second row gives: $,1,2$,3,4 in text box.

If we could split into tokens, would be easy to setup conditions to calculate column totals or similar.

Continue Example: $,1,2$,3,4 --> 1 2 3 4 --> 1+3 and 2+4

However, I'm stuck without delimiter-based split function. Substring widget requires  fixed integers, which works on example above, but not if 1 --> 100.

Any thoughts on solutions/alternatives?

***** Posts from Others on Calculating in Configurable Lists *****

https://www.jotform.com/answers/581842-Can-I-do-calculation-with-dynamic-fields-like-Configurable-List-widget

https://www.jotform.com/answers/494148-Can-I-use-conditional-calculation-using-the-Dynamic-Dropdown-widget-in-JotForm

https://www.jotform.com/answers/1252993-Is-it-possible-to-dynamically-add-rows-and-get-the-total-entries-in-a-table

https://www.jotform.com/answers/598520-How-can-I-get-my-configurable-list-to-calculate-to-the-calculation-field

https://www.jotform.com/answers/1175563-Confiruable-list-widget-A-way-to-use-conditions-with-fields-from-widget

To my understanding, you want to split the column 1 and column 2 value into two text boxes as well, right? Unfortunately, that's not possible at the moment. Is there any way you can take a short clip of your requirement? That would help us provide you with the appropriate workaround/suggestions if you can elaborate further on what you wanted to do using the form.

My overall goal is to run summations on the Configurable Lists. If someone enters 1, 2 on the first row and then adds another row with 3, 4 then I'd like to calculate 1+3+... and 2+4+...

I tried to capture and process the content.

In JotForm, we can capture the contents of the Configurable Lists, but we cannot easily process that content.

If we have 2 rows in our list with 1, 2 and 3, 4 then we can get

$,1,2$,3,4 but cannot process further.

Hi @ldeemiller!

I was able to get only the numbers to display by using the Form Calculation widget. Please take a look at the modified version of your form and clone it to see how the Form Calculation widget is set up.

Form: https://form.jotform.com/91776046221961

Guide: How-to-Clone-an-Existing-Form-from-a-URL

Thanks denis_calin,

Unfortunately, using the form calculation widget just merges the numbers together into one line.

Without a delimiter, difficult to get the 1, 2, 3, 4 back as separate numbers.

Looking forward, I don't think there is a way to "pad" the numbers to a specified number of digits. Otherwise we could use the substring widget on, for example, 0001000200030004.

Appreciate the continued help.

Regards,

LD

Hi @ldeemiller!

I apologize for the inconvenience, but unfortunately it is currently not possible to perform calculations, like calculating the sum of columns, in the Configurable List widget. I will raise this as a feature request to our developers so that hopefully we can expect this functionality in the future.