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.


  • Profile Image

    Can I create a complex price calculation form using Boolean Operators in Jot form?

    Asked by Richard Cross  on April 27, 2017 at 01:13 AM

    Hi, 

    I'm in the process of launching a translation agency and I'm working with a web developer to build an interface whereby a customer/prospect can insert their document word count, choose a language, service package, specialism and speed etc and this then provides an instant quote. 

    I've successfully created a spreadsheet that performs the calculation using the 'IF' function and I was wondering if it would be possible to get this level of functionality into Jotform? 

    I'm not at all well versed with web development - so I don't know, but would the code be able to be converted into something like Javascript and then integrated into Jotform? 

    Jotform sounds really great - and the functionality offered will be really great for my new business - but this quote calculator is a really essential part of my website and I want to know if it is going to be possible to have a quote calculator such as this integrated with Jotform. 

    Please let me know

    Thanks very much for your help. 

    Richard 

  • Profile Image
    JotForm Support

    Answered by Nik_C on April 27, 2017 at 03:35 AM

    Actually, you don't need any coding skills when you're creating the form with our tool, even for calculations. But also, you can not insert any script code to our forms, it's a security issue.

    You can check this guide for a start https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic, but we could assist you more if you can tell us what is the calculation you would like to create. 

    We'll wait for your response.

    Thank you!

  • Profile Image

    Answered by   on April 27, 2017 at 03:41 AM

    Hi Nik, thanks for the info. 

    Here is the link to my spreadsheet on Microsoft OneDrive 

    https://1drv.ms/x/s!Aiit9YlEPv4ScwYB8Um2Ugzghio

    Please have a look and let me know if this level of functionality is achievable with Jotform 

    Thanks for your help. 

     

  • Profile Image
    JotForm Support

    Answered by Nik_C on April 27, 2017 at 04:19 AM

    Thank you for additional information.

    I checked your Spreadsheet, calculations there are possible with our form, like, multiplication, show/hide fields based on some value, sum of few fields etc. 

    What I didn't understand is do you want to create a form from those fields like in Spreadsheet?

    I mean, your users fill the form, calculations are done and you just receive that information.

    If that is the case, then yes, you should be able to create such form with our tools.

    For example, if you want to show/hide the certain field(s) if some other field is filled you can use Show/Hide condition:

    Then, if you want to have a condition that will do some actions in the form (show/hide, calculations) if some number is greater than/lower than, you can use this condition (but field must be number type):

    You can use our Form calculations widget (https://widgets.jotform.com/widget/calculation) to SUM or some other Math operations, here is the guide on how to use Form Calculations Widget: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    You can also integrate your form with Spreadsheet: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Hope this information helps.

    Let us know if you have any further questions.

    Thank you!