How can we perform calculations with Configurable list widget?

  • hustra
    Asked on March 14, 2018 at 3:58 AM

    Hallo!

    I must realize a form and the configurable List widget looks very pretty: some colums and a useroriented add/delete-button for 1 to 10 rows. as he needs.

    My problem is the calculation. Three colums should have a final sum. As I read now in the forum, that the Form calculation widget does not support Configurable List widget? Or is there a function added meanwhile? Maybe the solution is a function in the Configuable List Widget (a sum row)?

    The Form https://form.jotformeu.com/80714484984367

    I can realize it with other controlls too, that is only my first idea. But I do not found any?

    This seems to be a very useful request, or? Any idea?

    Hustra

     

  • Victoria_K
    Replied on March 14, 2018 at 8:10 AM

    Unfortunately, it's not possible to calculate values from the configurable list widget. But, I can suggest to split it by adding the regular fields (Date Picker, Text input or Number field, Dropdown field) instead. You'll be able to do the calculations afterwards. 

    I have cloned your form to add an example for you:

    1521029024screenshot Screenshot 10

    To fit the fields into one line, I've used some custom CSS code:

    How-to-Inject-Custom-CSS-Codes

    #id_52, #id_51, #id_50, #id_49, #id_48 {

      padding-right: 0px;

    }

    #id_52, #id_51, #id_50, #id_49 {

      padding-left: 20px;

    }

    Here is the test form:

    https://form.jotform.com/80723358483967

    Feel free to test it and clone:

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

    Here are also some guides which might be of help:

    How-to-Perform-Form-Calculation-Using-a-Widget

    How-to-Assign-Calculation-Value

     

    Hope this helps! But, get back to us if you need further assistance with your JotForms.

     

  • hustra
    Replied on March 14, 2018 at 10:07 AM

    Thank you for your quick advice!!

    Well, of course I am now able to use Form Calculation Widget, the fields are now in the selection of the widget. But I need more rows of Input-fields. The best idea would be to give the user the possibility to add a new line (and delete one too) himself. I use this kind of forms now (with javascript-coding), but the software for that has no future. JotForm shall become the new "Forms-World" of our company. The users like this kind of forms. So I want to rebuild that mostly with all good ideas of the old forms.

    Is there a possibility to extend your solution, so that I can add/delete lines AND be able to use Forms Calculation Widget (or others). A flexible number of rows (max. 10)?

    One question for understanding: In your css there are Identifier like #id52, id49 and so on (and the form runs well). In the form I can only find identifiers #input_52, #input_50 and so. I am absolutely new in css (not in programming), so I am confused.

    Hustra

  • David JotForm Support Manager
    Replied on March 14, 2018 at 11:34 AM

    A way around would be creating each set of fields, and show them based on the amount of entries the user would like to add. Here is this guide that illustrates how to show multiple fields at once: https://www.jotform.com/help/196-Hide-or-Show-Multiple-Fields-at-Once 

    On regards of getting the IDs of each fields, the best way to do it is by using the browser inspect element:

    https://www.lifewire.com/get-inspect-element-tool-for-browser-756549