Spreadsheet for quick input

[Morten]

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

[Martin]

Hello, Morten,

In the change event, you have the e.range argument which gives you information which column was updated. You can then use the range method to select the header row to get the column name. You can also use the value method to get the new value. Here's a small example for reference.

Let me know how that works for you.

Regards,
Martin
Progress Telerik

[Morten]

Thanks Martin. Just what I needed. I'll proceed.