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.

Formula using Value data and Price data into product Drop Down Field

  1. stonge
    Member

    Hello
    I need help on this issue:

    Using a product Drop Down field,
    how can we get the Value data for calculation purpose (the Value data shown when choosing «show values»).
    In fact I need to make another field with the Value multiply by the Price to get a Total amount (in this case the Value represent a quantity. The Unit cost is changing according the quantity)

    TOTAL field data would be VALUE * PRICE

    How can I create this field with this formula ?

    Thank you for your help

    Posted 11 years ago on Monday February 18, 2013 | Permalink
  2. You can add a product or a number field to your form and click the box "Enable Calculation", you will be able to multiple the price times the quantity to arrive at your total.

    If you're having trouble with this, please post a URL to the page on your site where this form is embedded.

    Posted 11 years ago on Monday February 18, 2013 | Permalink
  3. stonge
    Member

    The problem is that each Quantity correspond to a specific unit Price. It is why I used a Pricing Dropdown field, with the Quantity as Label. So there are 3 values : Label, Value (same as Label) and Price. When I merge the field into another for calculation I got the Price as value.

    There is a way to get the Value data (wich is here the same as Label) to be able the multiply this Value by the Price according to the user selection ?

    Here is a link to see a Screenshot of this field :
    http://saintonge.com/dev05/exemple1/

    Posted 11 years ago on Thursday February 21, 2013 | Permalink
  4. stonge
    Member

    I found the solution reading an another article in the forum.
    {PricingField:Field id:price} * {PricingField:Field id:value}
    Great product!

    Thanks

    Posted 11 years ago on Friday February 22, 2013 | Permalink
  5. stonge
    Member

    Sorry I replied too fast. It does not work.
    So I am asking again
    Thanks

    Posted 11 years ago on Friday February 22, 2013 | Permalink
  6. Bump! I need to get the quantity which is in the "Value" and not get the price of the value.

    Posted 11 years ago on Friday April 12, 2013 | Permalink
  7. bartvh99
    Member

    Help! I know this is an old post but I encounter exactly the same problem I think...

    I use this formula in the product calculations:

    ( {Field:11:value} * {Aantal:16} ) * 0.16

    Field11:value is the nr of products from a dropdown product, eg:
    value = 3 price= $100

    {Aantal:16} is a quantity field. Lets say in this example the value is 10.

    I hope to get this result:
    (3 * 10 ) * 0.16 = 4.8

    But this tag: {Field:11:value}
    Is not getting the value (3) but the price.....

    Any help please?

    Thanks and many many positive karma to you

    ps: running latest version of Wordpress, Woocommerce and GF.

    Posted 11 years ago on Monday May 13, 2013 | Permalink
  8. From what I gather, the :value field is only available in the notifications and not the conditions of the form.

    Posted 11 years ago on Monday May 13, 2013 | Permalink
  9. bartvh99
    Member

    Thanks Cflare,

    I just posted an ad in the Jobboard section of the forum...maybe a programmer can work with it.

    Posted 11 years ago on Monday May 13, 2013 | Permalink