What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How can I determine a price for a product in the Purchase Order payment widget by the resulting drop-down selection of another field?Asked by wigginsb on August 12, 2015 at 06: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.
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.
Let us know if you want to try this method.
Used your workaround suggestion. It works okay. Thank you for your assistance.
On behalf of my colleague, you are welcome.
Feel free to contact us if you have any other questions.