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

    Feature Request: Calculating Fields Similar to a Spreadsheet

    Asked by NACUMS_org on February 19, 2013 at 05:05 PM

    I've been asked to create a form with fields that total amounts entered by the user.  I see that questions similar to this have been asked and it sounds like you are working on a solution.  This isn't a rush and I don't want to learn or even really need to buy another form package (like ElbowSpace) just to produce one form.

    I can hold off on this for a while, if you are working on a solution.  Please, will you have something in the next few months?  If you say no, I'll understand.  I love JotForm and will keep using it for everything else.

    create a form JotForm next another form
  • Profile Image
    JotForm Support

    Answered by EduardoMendez on February 19, 2013 at 05:24 PM

    Hi there, 

    Thanks for the kind words! :)

    Unfortunately, we do not have an ETA on this ticket.  However, the more votes for a request the higher it goes in priority.

    I have submitted your request to our dev team so that it counts as a vote for this feature.  They will update this thread as soon as they have any news on the feature,

    Thanks for your feedback and also for your patience!

  • Profile Image
    JotForm Support

    Answered by EduardoMendez on February 19, 2013 at 05:34 PM

    Meanwhile, 

    Would integrating to Google Spreadsheet and doing the calculations on the sheet be a workaround?

    Also, we have a "Purchase Product" field under the "Payment Tools" tab which acts as a payment tool but has no integration to process the payment.

    Can that be a workaround as well? Please let us know!

  • Profile Image

    Answered by NACUMS_org on February 19, 2013 at 06:18 PM

    I would need to see how Google Spreadsheets link to your forms.  Do you have instructions for this?

    The Purchase Product function won't work because the amounts will be entered by the users and will vary.  The form would need to show the individual amounts entered with the accumulated total, similar to an expense sheet.

  • Profile Image
    JotForm Support

    Answered by ardy0689 on February 19, 2013 at 07:08 PM

    You can refer to this guide on how to integrate on Google Docs and using Google Spreadsheet to receive your submissions. This is probably what Eduardo meant. You will need to receive your submissions from Jotform containing the values that need to be calculated and it will be automatically go to their corresponding column in Google Spreadsheet. You can use a 3rd column and set a formula to automatically calculate their values.

     

    Please let us know if it worked for you thanks!

  • Profile Image
    JotForm Support

    Answered by jonathan on February 19, 2013 at 07:08 PM

    @ NACUMS_org

    Hi, please review this article -Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-  . This will help you integrate your form to google docs spreadsheet.

    ---

    The Purchase Product function won't work because the amounts will be entered by the users and will vary.  The form would need to show the individual amounts entered with the accumulated total, similar to an expense sheet.

    This is on the feature request list already submitted to our dev team. You will be inform immediately when update on its progress is available.

    Hope this help.

    Thanks.