- weingutbuehlerAsked on November 26, 2014 at 08:16 AM
- JotForm SupportEltonCrisAnswered on November 26, 2014 at 10:15 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.
- adminweinguthuelsdeAnswered on November 26, 2014 at 10:44 AM
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!
- JotForm SupportEltonCrisAnswered 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
With regards to the CSS codes, I have move it to a separated thread. We'll assist you with that once we get there.