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.

Quantity, Calculations, Totals & an extra $40,000.000

  1. I am attempting to build a form that will present a product that has 2 different prices based on quantity ordered. If a user enter less than 36 in the Quantity Field, then the price is $69.95 per. If the user enters more than 35 in the Quantity Field, then the price is $34.95 per.
    Here is my current setup:

    • Quantity Field ( Labelled "4th Quarter")
      No special properties
    • Product Field (Labelled "Special Pricing")
      Properties: Calculation and Merger Tag of {4th Quarter:15} * 34.95
      Conditional Logic (All): Show if 4th Quarter is greater than 35
    • Product Field (Labelled "Regular Pricing")
      Properties: Calculation and Merger Tag of {4th Quarter:15} * 69.95
      Conditional Logic (All): Show if 4th Quarter is greater than 0
      Show if 4th Quarter is less than 36
    • Total Field

    If 35 or less is entered into the Quantity Field, all is well and the Total Field displays the correct amount. However, if 36 (or more) is entered into the Quantity Field, the form calculates it, puts the total in the Price, but then multiplies the Price by 34.95 to get a Total. In other words:

    35 quantity X 69.95 = Price and Total displaying $2,448.25 (CORRECT)
    36 quantity X 34.95 = Price of $1,258.20 and a Total of $45,295.20 (INCORRECT)

    Soooooo...what am I doing wrong

    TIA
    Rat

    Posted 12 years ago on Tuesday November 27, 2012 | Permalink
  2. David Peralty

    You have an overlap in your conditional logic. Do you have it set to "all" or "any" in terms of the rules it must follow? What happens if you use 37? Same error, I'm assuming? Can you take a screenshot and upload it somewhere and link it to us so we can see these two fields and their conditional logic?

    Posted 12 years ago on Wednesday November 28, 2012 | Permalink
  3. Sure thing, David. The logic to both is set to ALL ( I did a poor job of notating that above.) Screenies are here --> https://www.dropbox.com/sh/eo11rfyn6hrl9dn/dzm5amLlG_

    And yes, same error with anything 36+.

    Posted 12 years ago on Wednesday November 28, 2012 | Permalink
  4. Were you able to see the screenshots I posted?

    Posted 12 years ago on Wednesday November 28, 2012 | Permalink
  5. David Peralty

    Can you e-mail me a form export to peralty@rocketgenius.com so I can try to play with it? If I can recreate the issue to show the developers, it would be super helpful.

    Posted 12 years ago on Wednesday November 28, 2012 | Permalink
  6. I can, I can also make the page "live" if that would help as well...

    Posted 12 years ago on Wednesday November 28, 2012 | Permalink
  7. CODE --> http://pastie.org/5450022
    URL: http://4dsupplements.com/coaches-special-pricing/
    TEMP PW: Ju5t4Ud3v5!

    Posted 12 years ago on Wednesday November 28, 2012 | Permalink
  8. CODE --> http://pastie.org/5450022
    URL: http://4dsupplements.com/coaches-special-pricing/
    TEMP PW: Ju5t4Ud3v5!

    Posted 12 years ago on Wednesday November 28, 2012 | Permalink
  9. Any updates on this?

    Posted 12 years ago on Tuesday December 4, 2012 | Permalink
  10. @David Peralty did you get my email?

    Posted 12 years ago on Thursday December 6, 2012 | Permalink
  11. David Peralty

    Sorry, I received it but I was travelling to the rocketgenius head office. I'll try it out now and see what I can find out for you. Sorry about the delay.

    Posted 12 years ago on Thursday December 6, 2012 | Permalink
  12. No worries! Thanks for the help :)

    Posted 12 years ago on Thursday December 6, 2012 | Permalink
  13. David Peralty

    Hi again, I've sent you instructions on what you'll need to do. The biggest issue is that Quantity can only be associated with one product, and that's why the issue with the calculations. You also have conditional logic on that quantity field where they can't see the submit button until they add a quantity, and if you don't remove this before deleting the quantity field, it then creates a form error.

    Posted 12 years ago on Thursday December 6, 2012 | Permalink