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

    Can we implement a calculation option within the chart an a grand total at the end?

    Asked by weingutbuehler on November 26, 2014 at 08:16 AM
    By chance - is there a possibility that you can implement a calculation option within the chart an a grand total at the end? In this specific request:
    Equation: Row 2 x Row 3 = Row 4
    All results of Row 4 = Grand total
    Thank you very much for your help!
    Holger
  • Profile Image
    JotForm Support

    Answered by EltonCris on November 26, 2014 at 10:15 AM

    Hi Holger,

    I think this widget will help. http://widgets.jotform.com/widget/spreadsheet

    Just like normal spreadsheets, you can create formula to calculate the rows and a formula to get the grand total.

    Hope this helps. If you need further assistance, let us know.

    Regards!

  • Profile Image

    Answered by adminweinguthuelsde on November 26, 2014 at 10:44 AM

    Dear EltonCris!

    Thank you for your reply. Somehow I don't get the calculation form to work. Row D should display the result of multiplication of row B and C: Can you help.

    I'm not good at CSS coding - can you also help to determine how to change the size of the rows and how to change their color?
    Is it possible to change the header row names, e.g. "A" to "Product number"?

     

    Thank you so much for your help!

    Holger 

  • Profile Image
    JotForm Support

    Answered by EltonCris on November 26, 2014 at 11:50 AM

    There are samples on the widget description which you can try. I have just tried it and it's working fine.

    Header letters (e.g. A, B, C) are default and can't be changed just like spreadsheet. However you can add text values on the first row as your headers.

    Example with formula D = B*C

    A1 First Header
    B1 Second Header
    C1 Third Header
    D1 Grand Total
    D2  = B2*C2
    D3  = B3*C3

    Screenshot:

    With regards to the CSS codes, I have move it to a separated thread. We'll assist you with that once we get there.

    Thanks!