Calculation of Fields using Google Spreadsheet...

  • Profile Image
    guest_23471344991054
    Asked 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
    guest_23471344991054
    Answered on January 02, 2013 at 12:43 PM
  • Profile Image
    EduardoMendez
    Answered 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
    Ashley 
    Answered on June 17, 2017 at 06:35 PM

    Hi

    Could this happen through zapier? 
  • Profile Image
    jonathan
    Answered on June 17, 2017 at 06:44 PM

    @Ashley

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