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

  • Profile Image
    Richard Cross 
    Asked on April 27, 2017 at 01:11 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
    Charlie
    Answered on April 27, 2017 at 03:32 AM

    Thank you for your interest in using JotForm.

    Our product is an online form builder that allows you to create different kinds of forms. I strongly suggest that you sign up an account to us and explore the form builder's features and functionalities. 

    Now for your requirements, I am not exactly sure on how you would like to do this, but here are my suggestions: 

    1. First, you can use the Conditional Logic and Form Calculation widget to perform calculations and other smart features on your form. You can check the following links to learn more: 

    https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic 

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

     

    2. Aside from widgets, you can also integrate JotForm to different 3rd party applications. You mention that you have successfully performed the calculation on a spreadsheet? If that is the case, you can integrate JotForm to Google Spreadsheet. The submission made on your form will automatically be populated on your online spreadsheet, you can then perform different functions from there. Here's a guide on how to integrate your form to Google Spreadsheet: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Now if I may suggest further, instead of directly editing the spreadsheet integrated to your form, I suggest using the function IMPORTRANGE, reference the data on the integrated spreadsheet and populate it on a custom spreadsheet where you want to make or add changes like new columns, formulas, graphs, charts, etc... We want the integrated spreadsheet to remain as it is with the purpose of only receiving submission data, further editing on the integrated spreadsheet might break the integration. 

     

    3. If you are a developer and is familiar with Javascript, then you can incorporate your script directly to your form by downloading the form's full source code. To learn more about this, you can check this guide: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    If you are familiar with API and want to integrate your own application to JotForm, then that is possible using our API. You can check our developers' page here: http://api.jotform.com/

     

    I hope that helps.