How to add a total on my dropdown list fields?

  • pixeltavoworld
    Asked on September 11, 2023 at 7:29 AM

    I intend to have buyers buy customized pc. Here is the form that is still a work in progress: https://form.jotform.com/232533224412444

    Need guidance on how to sum up the products and final amount displayed.

  • Janice_B JotForm Support
    Replied on September 11, 2023 at 9:20 AM

    Hi Sayan,

    Thanks for reaching out to Jotform Support. You need to add a Form Calculation Widget and assign values to your dropdown options to be able to sum the dropdown values. Let me show you how:

    1. In Form Builder, select your Dropdown field.
    2. Go to the Options tab, scroll down, and toggle On the Calculation Values.
    3. Set the prices on the Box.

    How to add a total on my dropdown list fields? Image 1 Screenshot 40

    After that, you can the Form Calculation Widget and create a formula to add the total amount of the selected items on the dropdown. Here's how to do it:

    1. In Form Builder, click on the Add Form Element.
    2. Go to the Widgets tab.
    3. Add the Form Calculation Widget.
    4. Click on the Wand icon.
    5. Add this formula:

    How to add a total on my dropdown list fields? Image 2 Screenshot 51

    Here's the result:

    How to add a total on my dropdown list fields? Image 3 Screenshot 62

    If you like, you can also use a Product List element and show the total at the end of the products. We've got a guide here explaining How to access and use the Product List field.

    Give it a try and let us know if you have any other questions.

  • pixeltavoworld
    Replied on September 13, 2023 at 6:00 AM

    Thanks! Dropdown are showing in light grey and difficult to read. Could not find button to change the color of the text with dropdowns.
  • pixeltavoworld
    Replied on September 13, 2023 at 6:12 AM

    Also I have been trying to add Form Calculation Widget. But not getting correct result. Help appreciated.How to add a total on my dropdown list fields? Image 1 Screenshot 20

  • Marlon_T Jotform Support
    Replied on September 13, 2023 at 8:44 AM

    Hi pixeltavoworld,

    Thanks for getting back to us. If you want to get the total of your dropdown list, you need to add an operation in between the added field in your form calculation widget. Please check the screencast below:

    How to add a total on my dropdown list fields? Image 1 Screenshot 20

    I need to move your additional question about the color of your dropdown list to another thread. You can click here to check that out.

    Reach out again if you have any other questions.

  • pixeltavoworld
    Replied on September 14, 2023 at 5:18 AM

    I have tried to follow the instruction but not getting amount updated in Total. Should be missing something.How to add a total on my dropdown list fields? Image 1 Screenshot 30How to add a total on my dropdown list fields? Image 2 Screenshot 41

  • Christopher JotForm Support
    Replied on September 14, 2023 at 9:53 AM

    Hi pixeltavoworld,

    I have cloned and reviewed your Form Calculation widget and it looks like you have added an extra + at the end of your calculation as shown in the screenshot.

    How to add a total on my dropdown list fields? Image 1 Screenshot 20

    Since there is no form field after it, this is causing the issue. Please remove it and your Form Calculation widget should work properly.

    Let us know if there’s anything else we can help you with.