I’m considering using jqxgrid to allow users to enter financial forecast data by month. They need to see the values entered for the previous year to assist them. The grid would have a cost category column (e.g. Software) followed by a column for each month that would show last year’s forecast, underneath this would be a text box to enter this years forecast. For example:
————————————————————————–
|Category |..Jan.. |..Feb..|..Mar..|..Apr..|………
—————————————————————————
|Software |$ 100 |$ 200 |$ 300 |$ 100 |………
|………………|$ NNN|$ NNN |$ NNN |$ NNN|………
—————————————————————————
The top set of numbers in each row are read only fields (or labels) showing the previous year’s forecast. The “NNN” represents an input field for this year’s forecast.
I’d like to use inline editing. The backend is a SQL Server database accessed via PHP.
Is this possible with jqxgrid? Does anyone have any example code? Is there a better way to do this?
