How can I determine a price for a product in the Purchase Order payment widget by the resulting drop-down selection of another field?

  • wigginsb
    Asked on August 12, 2015 at 6:01 PM

    I have a Conference Registration form for County Officials that has two different prices for a particular item based on the County Classification of the Registrant.  If the County is either a Charter or First Class County, the product price for "Personal Property Data" is $1,500, if the County is Second, Third or Fourth Class, the product price for "Personal Property Data" is $800.  I would prefer that the price should auto-change based on the "County/Jurisdiction" drop-down selection that is outside of the payment widget.  I currently have it achieved through special pricing built into the "Personal Property Data" product with the registrant needing to choose which Classification is appropriate, but would prefer to use the "County/Jurisdiction" drop-down field because it can't be relied upon for the registrant to select a Classification or if they choose an incorrect Classification it could result in a grossly inaccurate invoice.   The Registrant does however have to select which "County/Jurisdiction" that they are from.  I have Calculation Values already set for each of the "County/Jurisdiction" drop-down selections equal to the correct price.  I just don't know how to have those two fields connected programmatically in your system.  Any help would be greatly appreciated.

  • Welvin Support Team Lead
    Replied on August 12, 2015 at 11:28 PM

    Unfortunately, this is not possible in your current configuration. Changing the product item price based on a selection from the other field is not possible, not even when configuring a conditional logic.

    Your current setup through special pricing is a great workaround, but if you really want to take control of the pricing based on the other field input/selection, you can restructure the form and use checkbox, radio or a dropdown field for product items. Use calculation widget to get the total and add a conditional logic to change the value.

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    http://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Caculation-into-a-field-using-a-Condition

    Let us know if you want to try this method.

    Thanks

  • wigginsb
    Replied on August 13, 2015 at 8:53 PM

    Used your workaround suggestion.  It works okay.  Thank you for your assistance.

    http://form.jotformpro.com/form/52233841420950

  • BJoanna
    Replied on August 14, 2015 at 2:14 AM

    On behalf of my colleague, you are welcome.

    Feel free to contact us if you have any other questions.