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

    How to add the total amount values which can be captured on the excel spreadsheet ?

    Asked by Lossuenos on July 08, 2016 at 03:07 AM

    Hi, how do we add the total amount values at the bottom of each column on the export spreadsheet please? 

    Screenshot
    excel amount Excel spreadsheet how
  • Profile Image
    JotForm Support

    Answered by Chriistian on July 08, 2016 at 07:31 AM

    It seems you have created two different thread for the same issue. I have already responded to your other thread. You can check the thread here: https://www.jotform.com/answers/878109. We will attend to your concern on the other thread.

  • Profile Image

    Answered by Lossuenos on July 14, 2016 at 02:11 PM

    Hi Chriistian,

     

    We have tried the settings but it only works for the form total amount. but it doesn't work on the total value amount for (Exported) excel file as shown on my picture above..

     

    after exporting the excel file, I would like to see the total values at each column.

    please advise if this is possible.  thanks

  • Profile Image
    JotForm Support

    Answered by Nik_C on July 14, 2016 at 03:13 PM

    Unfortunately, you will not be able to do that, however, if you create the Google spreadsheets integration you should be able to add the total calculation for all forms. 

    Create a new column for the calculation in the part of spreadsheet that will not be overwritten when users submit the form. 

    The important part when using Google spreadsheets with custom fields is to avoid changing the fields that are generated.

    Let us know if you need more information.