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 can I embed calculations in a chart

    Asked by Jon  on April 23, 2014 at 11:42 PM

    I'm trying to create an expense sheet where individuals enter their expenses to a growing chart I.e. add lines to a chart. I need to embed some calculations into the chart such that ColumnA + ColumnB = ColumnC

    calculations chart create expense
  • Profile Image
    JotForm Support

    Answered by jonathan on April 24, 2014 at 03:53 AM

    Hi Jon,

    Unfortunately, there is no means to this. The Form Calculation widget is not meant to be used like that.

    What I suggest you can use instead is the Google Spreadsheet. What you wanted to do is most likely to be achieved using with the integration to google spreadsheet application.

    Refer to this article 

    -Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

     

    If its just report with NO calculation, and you need a graph, you can use the existing JotForm Visual Report

    Refer to this guide

    -How-to-create-a-Visual-Report-with-your-Form-Submissions

    Here is a sample Visual Report http://www.jotform.me/report/22672307678057

    Hope this help. Inform us if you have further question.

    Thanks!