How can I make a form to provide a predetermined price when the user submits 2 dimensions?

  • Profile Image
    Andy
    Asked on March 05, 2017 at 09:14 AM

    I run a window blinds business. I am looking to sell my blinds on line.

    I want to produce a form that when the customer enters the width and drop of the blind, a pre determined price is produced. A third field may be required, ie. width; drop and thickness of blind slat.

    How you can help

  • Profile Image
    liyam
    Answered on March 05, 2017 at 12:26 PM

    Hello Andy,

    You can make use of the form calculation widget to run calculations for dimensions, thickness, etc for your blinds. You can check out this guide for more information on the details on matters on form calculations for your form: https://www.jotform.com/help/chapter-9-Form+Calculations

    And here are guides that explain details about making use of form calculations widget: 

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

    If you need assistance, please let us know.

  • Profile Image
    dandypro
    Answered on March 07, 2017 at 02:15 AM

    Hi Thanks for your help, but what I am looking to do is like this http://www.247blinds.co.uk/ecowood-provincial-fine-grain-venetian-blind by putting in two sizes a predetermined price will appear.

     

  • Profile Image
    liyam
    Answered on March 07, 2017 at 04:15 AM

    Hello,

    Perhaps you can give us a formula and we'll give a sample on how it should print results.

    Thanks.

  • Profile Image
    dandypro
    Answered on March 07, 2017 at 04:29 AM

    Hi,

    I am asking your advise on how to do it or if it can me done with a jotform.

    I have price lists on excel, in tables with the width on the horizontal axis and the blind drop on the vertical axis. What I need to know is how can these prices be picked up when a customer puts width and drop into boxes on the form.

  • Profile Image
    Chriistian
    Answered on March 07, 2017 at 08:49 AM

    You can set this up by using conditions in JotForm and/or using Calculation widget. Condition setup can be found in Form Builder form in Settings > Conditions tab. In your case, we will be using the Update/Calculate Field condition.

     

    Here is a sample form that I have created: https://form.jotform.com/70653620412952. In my sample form, I have set the following conditions:

    For more information about conditions, you can check this article: Smart Forms Using Conditional Logic. On the sample form, when I input 5 in Width (cm) and 5 in Drop (cm) the price displayed is $50.

    And when I input 10 in Width (cm) and 5 in Drop (cm) the price displayed is $100.

     

    You can also clone the sample form that I have created to have a closer look on the setup. To clone form, just follow the instructions provided How to Clone an Existing Form from a URL.

     

    Do let us know if you need further assistance.
    Regards.