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 could I make a reply to a submission to display a tally

    Asked by LADSON on May 07, 2012 at 12:59 PM

    I have constructed a form that my employees use to input thier time worked throughout the day. I would like them to be able to see a running total of hours per day per employee. Any ideas?

    Page URL:
    http://ladson.yolasite.com/

  • Profile Image
    JotForm Support

    Answered by jonathan on May 07, 2012 at 04:12 PM

    Hi,

    You can achieve this by using source code embed and adding some customize scripts that can sum/total a value. As is now, JotForm does not have an existing tool/fields that compute values except those in the payment tools.

    If you can put the excel in the server and be able to read it using javascript or php, then I believe you can sum a column from it and display it in your website for the users to see the equivalent total from that excel report you displayed in your form.

    Hope this provided help in some way. Please inform us should you have further inquiry.

    Thanks.

  • Profile Image

    Answered by LADSON on May 07, 2012 at 05:22 PM
    Thanks for the response but I am perhaps a little over my head with this. Im not sure how to do any of the options you mentioned.

  • Profile Image
    JotForm Support

    Answered by jonathan on May 07, 2012 at 07:21 PM

    Hi,

    Here's how I immediately thought you can achieve this.

    1. In your website, you will use source code to embed the form

    2. Since you are using source code, you can then add custom scripts (functions) on the web page.
    i.e. <script type="text/javascript"> "custom scripts here" </script>
    3. You must have access to your Excel file, (if you put it in your website, you can probaly access it), put some formula on the Excel to have total for a column
    4. Now, use the custom script to access the total column of the Excel file and have its value displayed in the web page where the form is also embedded. 
    Or
    5. Display the whole excel in your website as part of the page with the total column already included.
    We actually have just released our newest JotForm integration : -Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

    This was what I was thinking that can be done even before the new integration =)
    Hope this help. If you are interested to pursue this I can probably provide you assistance (in my spare time) to achieve it.
    Thanks.
  • Profile Image

    Answered by toriqul1976 on August 06, 2015 at 09:47 AM

    Hi Jotfom Support,

    My company is thinking to buy Jotform service and wondering whether Jot form had the capability to integrate data with Tally accounting software. Any help regarding this will be highly appreciated

  • Profile Image

    Answered by Ben on August 06, 2015 at 10:23 AM

    Hi @toriqul1976,

    I have moved your post to a new thread here: http://www.jotform.com/answers/630744 where we will be answering it shortly.