How to show total and how calculator adds up this total

  • narrowbridgecandles
    Asked on August 19, 2016 at 4:32 AM

    Also, I am trying to integrate an appropriate widget and learn how to use it. I need some that can generate a total live in the form from a number of different fields.

    6 pairs of fields in which someone has said they want ______ # of something and want to pay _____ amount for it.

    and then the calculator adds up those totals. I figured out how to do this with the calculation wizard, but can't figure out how to use the for calculation widget- do you have any instructions on that?

    The reason I am exploring both is that I am trying to figure if one of these widgets can add up all of those tallies and then add $5 to each person's total for shipping if they have ordered any of 5 out of the 6 products and $15 for shipping if their order includes one of the products (a very large heavy one).

    I also want these calculations to be included in the automatic reply e-mail.

    I want them to submit the form and then get an e-mail that says:

    THanks so much for your order

    Order Summary (taken from the fields in the form)

    1 ___

    3 _____

    2___

    You total including shipping is _______ (taken from calculator in the form)

     

    Any guidance you can offer would be very helpful, thanks so much

    Jonah

  • Rose
    Replied on August 19, 2016 at 7:43 AM

    Could you please let me give some time to work on it to find most appropriate solution. It won't be so long. I will get back to you in a short time. 

    Thank you in advance for your understanding. 

  • Rose
    Replied on August 19, 2016 at 9:27 AM

    I thank you again for your understanding. 

    If I figured out what you are requesting correctly, you would like to add 15$ if your enduser order        " Large Havdallah Candles " and add 5$ if your enduser does not select " Large Havdallah Candles "  but selects any of remaining. 

    You can create any scenario like this by using Update/Calculate Condition. You can find condition details as below. 

    1. Click on "Calculation Wizard " and then Click "Condition Icon"

    How to show total and how calculator adds up this total Image 1 Screenshot 110

    2. Click "New Condition" and Choose "Update/Calculate Field"

    3. Write the first condition according to chosing of " Large Havdallah Candles ". If this field is filled by user differ than 0, shipping cost is adding as 15$ to the total. Calculation field is configured as multiplying related fields, adding them up and then adding 15$. 


    How to show total and how calculator adds up this total Image 2 Screenshot 121
    4. Write the second condition according to  not choosing of " Large Havdallah Candles ". If this field is filled by user as  0, 5$ will be added to the total. Calculation field is configured as multiplying related fields, adding them up and then adding 5$. 

    How to show total and how calculator adds up this total Image 3 Screenshot 132

     

    Now, the answer of your second question which is about showing order summary. 

    1. Click E-mail icon.

    How to show total and how calculator adds up this total Image 4 Screenshot 143

    2. Click Edit of AutoResponder

    How to show total and how calculator adds up this total Image 5 Screenshot 154

    3.  Select rows that you do not want your user to see and then Click Delete row icon and clean table.

    How to show total and how calculator adds up this total Image 6 Screenshot 165

    4. Make a single row one of them and then write the message you want to show there. To to that; select the row and then click table icon>> Cell >> Merge cells. After merging it, write that row what you want.

    How to show total and how calculator adds up this total Image 7 Screenshot 176


    5. In order to show quantities of each selection, follow below steps:

    * Click Form Fields

    How to show total and how calculator adds up this total Image 8 Screenshot 187


    * Choose related field, click and copy the ID to the related row of that field and save it. 

    How to show total and how calculator adds up this total Image 9 Screenshot 198


    Here is the screen shot of what I got after I applied all of above.

    How to show total and how calculator adds up this total Image 10 Screenshot 209

    Hope these helps you and solve your issue. 

    If you need any further assistance from our side, please do not to hesitate to contact us.