PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Calculation Field double counted in total & other issues

  1. I have a form for a design service where a homeowner can order photo masking for a design application or a floorplan service. I have a calculation field based on a quality level (basic or pro) and on the number of layers someone wants us to mask on the photo (1, 3, 5). The form calculation is:
    {Quality Level Desired:105}* {Number of Layer Masks (up to...):107} for each photo uploaded.

    On the form, when I had an Option field for the Quality Level, the total for each photo scene, and then the total at the bottom of the form was correct, but when I sent it to paypal it was double counting. When I changed it to a product field, it is now duplicating in the total at the bottom of the form. So, I am obviously doing something wrong. The floorplan service oks ok...and I even have a variable pricing based on the size of a property and it calculates that correctly.

    I have also tried adding a product for Masking Service at $0 and then a product option at the $14.99 and $29.99 and then in the calculation taking the option times the level....and it still is duplicating the amount when you go to paypal.
    Right now I have a product field as my option, which is either basic or pro quality masking level. I have prices in these fields of $14.99 or $29.99. On the number of layers, I have a drop down of 1, 3, or 5 and no values. The calculation is the product of the quality (basic or pro) * number of layers (1, 3, or 5). So it should be $14.99 or $29.99 if I just had 1 layer. It is showing as $29.98 or $59.98.

    I can PM an account login which might be the fastest way to look at the issue.

    Also...I was going to use woocommerce for more of a shopping cart functionality...but that might be overkill. I would like to show users what they ordered in terms of the design service somehow in their account....ideas on how to do this without a shopping cart installed?

    ANother issue is I have a multi select field with 5 or 6 things in it. If the user does not complete a required field, the form refreshes with the error message...but it does not save the user's selection for the multi field....and it populates ALL answers in the field. So unless they catch it, they will submit the form with all answers.

    Finally...do you have suggestions on how to handle a failed paypal transaction. with the easy way to do this...the form gets submitted, but in GF it shows as processing if the payment failed. It would be good to be able to keep the entry and try to resubmit it manually.

    The form is at http://homediary.com/design-service/ however it is currently locked down...so I would have to send you a pm with admin login details....

    Posted 11 years ago on Saturday December 8, 2012 | Permalink
  2. Hi...still need help. I have a product field that is a calculation of a product * an option field . the calculation total is ok, and the total at the bottom is correct, but when I sent it to paypal it is duplicating....looks like it is picking up one of the product fields but not sure what I need to to enable the calculation field....site is accessible right now.

    If I have a sub total for each option (which is a Product, the factor of quantity * quality), do I need to reverse out the sub total to get to the total? I creates a simple form to test and when I take the quality * quantity it adds the sub total but then in the total, it duplicates the amount. If I use the quality (Product Price) * quality (product price) then nothing shows in the sub total...but the total is correct.

    So....I need to be pointed in the right direction on how to use this calculation setting, as it is not working for me....

    Posted 11 years ago on Tuesday December 11, 2012 | Permalink
  3. I have gone to another site I have and tried to just recreate the options, quantity and product fields. See this page http://floorplanonline.com/form-test/
    The code I have is as follows:
    Quantity Product Field: options 1, 2, or 3
    Option Field: Basic ($14.99) or Pro ($29.99)
    Calculation Field: (Quantity * Option).
    If I use the merge tags of
    {Product Name (Price):1.2} * {Product Name (Quantity):1.3} the Product Price does not display anything....but the total does total up correctly.

    If I use the merge tags of
    {Quantity:2} * {Option:3} the product total will update with the right price for the options selected, but then the total is double counting the total. The total does not display on the screen but when you submit the form, it does double count the total calculation.

    So it seems something is not working correctly with the calculation field, as I have narrowed it down to 2 options to get the product total and I still can't get it to work correctly.
    I really need help...where is the documentation...as seems like it would be easy but nothing is working...on 2 different sites with different plugins.

    Posted 11 years ago on Tuesday December 11, 2012 | Permalink
  4. If you use a calculated product field based on values of other product fields - then the form total and submission will double up. You can always use number fields to do calculations as well which would not affect the price.

    The reason is if a user has selected or chosen a product field that another calculated product field relies on and is also selected - then you have two product fields in play here. The original and the calculated.

    Posted 11 years ago on Tuesday December 11, 2012 | Permalink
  5. Ok, I see if I make the quantity and quality (which has a price associated with it) regular dropdown fields vs use the product fields, then the product total works, and then the form total works....but
    1. what is the point of having the product related quantity and options fields then....and 2. how can I get the price to show for the option (Basic being $14.99 and Pro being $29.99) on the form. With the Product option, it would show the price if I used the radio button - like if I selected on, then it would say +$15 on the other.

    It seems like you should be able to adjust the total field to a calculation as well so you could just add up the product totals....not the product totals and then the options associated with those products. It seems counter intuitive....to me.

    Posted 11 years ago on Tuesday December 11, 2012 | Permalink