A very good morning to all.
I have a ‘spreadsheet’ style layout on my webpage. It’s made up from an HTML table and a form with input boxes. I have a total column on the end of each row and when I submit the form it does the math and adds up numbers from several boxes on that row and adds them to a total box. It’s also saved into a database so the total can be redisplayed later.
Each box has a unique name. As I loop through an array I create the table row on my page and add the increasing integer into the name to make it unique.
What I’m looking to do is a enchantment that when something is typed into one cell it calculates the values from each input on that row and adds the total into the final box.
So here for example. If I added 3 into field 2, and 5 into field 3, I’d get 7 into field 4
I’m not sure where to start given I have so many rows. If I had just one row, it’s just get the values from all those boxes on a keydown event and do the math and update the designated total box.
Many thanks to all who can help.