I'm looking into using Spreadsheet to enter data into an underlying database quickly.
Like the table below, where the columns A, B, C and D would be loaded from the database, the columns E and F (Sales and VM) should be editable (from row 2), and the Total column (G) should sum Sales and VM.
A | B | C | D | E | F | G | |
1 | Location | Location group | Country | Manager | Sales | VM | Total |
2 | A | X | 1 | I | 6 | 3 | 9 |
3 | B | X | 1 | I | 2 | 2 | 4 |
4 | C | Y | 1 | II | 3 | 1 | 4 |
5 | D | Y | 2 | II | 4 | 2 | 6 |
6 | Total | 23 |
The underlying database would be updated whenever a cell in either column E or F (Sales or VM) was updated (onChange).
On change I would need to be able to get the value of the column header (row 1 ), and the value in the cell from the updated row in column A.
Is all this possible?
/Morten