Need an intelligent, spreadsheet style grid
Posted on 2003-12-10
In a cfform I've got a cfgrid component that list rows of employees with columns representing hours worked for each day in a week with a Total Hours column as the last column. The user enters in hours for each day and when they press submit the action page adds them all together and populate to totals. Works fine.
Client now wants the grid to display a running total in the Total Hours field as they enter values in each day, so that if they enter 8 for Monday, the Total Hours column for that row will show 8, then they enter 8 in Tuesday's Hours and the Total Hours increments to 16. This needs to happen dynamically as they enter values without having to press submit.
I don't think cfgrid can do this. Does anyone have any ideas on the best way to accomplish this?