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.
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
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.
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!
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
With regards to the CSS codes, I have move it to a separated thread. We'll assist you with that once we get there.