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

    Calculation of Fields using Google Spreadsheet...

    Asked by guest_23471344991054 on January 02, 2013 at 12:42 PM

    I need for my form to calculate separate fields for my customer BEFORE they submit the form.  I've never used the Paypal integration modules but, from what I read in the forum, I don't think that it will work.  In addition, I don't understand what the Grading field is or how it works.  But, from what I read, I'm not sure that it will work, either (though I could be wrong).

     

    HERE'S MY QUESTION:  If I my customer selects a few drop down options for dollar amounts on my form, can I have the dollar amounts that my customer selects transferred to a Google Spreadsheet where the calculations would be made and then the calculated result transferred back to my form while the customer is still filling it out?  Is this possible?  If so, how?

  • Profile Image

    Answered by guest_23471344991054 on January 02, 2013 at 12:43 PM
  • Profile Image
    JotForm Support

    Answered by EduardoMendez on January 02, 2013 at 03:02 PM

    Hi there, 
    Here are some answers to your questions.  Please let us know if you have any other concerns. 

    I need for my form to calculate separate fields for my customer BEFORE they submit the form.

    You can use the "Purchase Order" field on the Payment Tools tab in order to accomplish this without integration with a payment tool.

    I've never used the Paypal integration modules but, from what I read in the forum, I don't think that it will work.  In addition,

    You can only use one Payment tool in your forms.  if you need to use a Paypal field, then you can not use the "Purchase Order" field suggested before.

    I don't understand what the Grading field is or how it works

    This field is to allow users to grade a product or service. Used in satisfaction surveys.

    HERE'S MY QUESTION:  If I my customer selects a few drop down options for dollar amounts on my form, can I have the dollar amounts that my customer selects transferred to a Google Spreadsheet where the calculations would be made and then the calculated result transferred back to my form while the customer is still filling it out?  Is this possible?  If so, how?

    Unfortunately, this is not posible at this time.
    There is a feature request that has been submitted in order to allow calculations between fields on the form.  This feature is not yeat available.

  • Profile Image

    Answered by Ashley  on June 17, 2017 at 06:35 PM

    Hi

    Could this happen through zapier? 
  • Profile Image
    JotForm Support

    Answered by jonathan on June 17, 2017 at 06:44 PM

    @Ashley

    We will resolve your concern here https://www.jotform.com/answers/1176565