Spreadsheet for quick input

1 Answer 27 Views
Spreadsheet
Morten
Top achievements
Rank 2
Iron
Iron
Veteran
Morten asked on 30 Aug 2024, 04:49 PM

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.

ABCDEFG
1LocationLocation groupCountryManagerSalesVMTotal
2AX1I639
3BX1I224
4CY1II314
5DY2II426
6Total23

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

1 Answer, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 04 Sep 2024, 10:48 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Morten
Top achievements
Rank 2
Iron
Iron
Veteran
commented on 05 Sep 2024, 06:13 AM

Thanks Martin. Just what I needed. I'll proceed.
Tags
Spreadsheet
Asked by
Morten
Top achievements
Rank 2
Iron
Iron
Veteran
Answers by
Martin
Telerik team
Share this question
or