How to create Magento editable grid?

Question

I couldn't find a better tutorial for creating an admin grid which is editable. And the grid column contains dropdown boxes. And there's only one save button for the entire grid. (Means there's no Action column anymore). I'll provide a mock diagram of the grid which I want to generate. Please suggest if found any tutorials or way to achieve this easily. I have created this grid form. But it's not saving data.

Answer 1

Here is a tutorial

http://www.atwix.com/magento/inline-editing-in-magento-backend-grids/

It suggests you override the column renderers

Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Input

to allow inline editing, it will save the data as each control is edited rather than at the end with a save button.

Answer 2

I have never seen such a thing, but what you want is more or less, what phpmyadmin implemented in one of the last versions:

1. you have a <form> around the whole grid
2. you click in a cell and get a input/dropdown/whatever editable element
3. you click the save button and submit the form
4. you process the data in the backend and save it.

Your question is far too broad to answer it concrete. If you have implemented parts of it and have problems, come with the magento parts here and with the JS problems on stackoverflow or here.