If I wish to allow our customer to add entry row and perform calculation within the table, how can I do it please?

  • Profile Image
    Yiu_Terence
    Asked on October 27, 2021 at 12:34 AM

    1635309163_6178d66b93898_I.e. I need the add row function of configure list and the calculation function of the table

    allow customer to add row while performing a average calculation in the table data, please advice

  • Profile Image
    Sam_G
    Answered on October 27, 2021 at 07:11 AM

    Hello Yiu_Terence,

    1) Unfortunately, there is no way to have more rows dynamically added to the Input Table element, there is a similar widget that supports this, but it doesn't support calculations, here is the link to the widget: https://www.jotform.com/widgets/configurable-list

    2) The dropdown element allows selecting more than one option, you can enable this on the field settings:

    1611260857_6009e3b94a0d4_

    This way you can show as many Input Tables as needed.

    3) You can perform calculations on the Input Table, I would recommend you to kindly check this guide for more details about it: https://www.jotform.com/help/343-how-to-perform-form-calculation-in-the-input-table-field

    If your purpose is to only have a visual table with the results, I would recommend you to pass the calculation fields values to a table in the Paragraph element, this guide will provide you more details about it: https://www.jotform.com/help/418-pass-an-input-field-to-a-paragraph-element

    If you have any questions, let us know.

  • Profile Image
    Yiu_Terence
    Answered on October 27, 2021 at 11:54 PM

    is it possible to provide a calculator close to the configure form for customer to have easy calculation within the form??

  • Profile Image
    Basil_A
    Answered on October 28, 2021 at 03:20 AM

    Hi,

    If you would like to add a calculator to allow the user to make their own calculations, you can use our calculator widget.

    https://www.jotform.com/widgets/calculator

    Please let us know if you have any further questions.

  • Profile Image
    Yiu_Terence
    Answered on October 28, 2021 at 05:55 AM

    May I add it as a tool instead of an entry?

    1635414809_617a731902f27_What we really wanna do is help our customer to easily calculate with the avg. value of the item details rows.

  • Profile Image
    Amos_W
    Answered on October 28, 2021 at 06:55 AM

    Hi,

    You can try achieving that by using the field calculator in order to perform mathematical calculations on different fields, you even have an average function you can use

    Here is a guide on how to do that

    https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget/


    Also, you can have a look at that page, which provides alternative ways on calculating fields

    https://www.jotform.com/help/chapter-9-form-calculations/


    Please let us know if you need further assistance

    Thank you

  • Profile Image
    Yiu_Terence
    Answered on November 16, 2021 at 05:07 AM

    Can we make a Dependent Drop Down List in configurable list please?

  • Profile Image
    Bojan_J
    Answered on November 16, 2021 at 07:07 AM

    Greetings.

    If you wish to add a dropdown list to your configurable list, you need to use the following:

    {label}:dropdown:{option1},{option2},{…}:{placeholder}

    For example, if you wish to create a dropdown with days of the weeks, you can add the following to your widget:

    Select a day of the week:dropdown:Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday:Select a day

    This will result in the following:

    screenshot_8263.png

    Let us know if this solution will work for you.