Add new record with SigmaGrid

[stani]

Hello Steven,

I had posted this problem earlier, but you were on vacation it seems, hence I never heard from you. Im using SigmaGrid for one of my project and I need to do the following:

1) Grid at http://www.themotoroilevaluator.com/admin/php/crud/viewoilData.php  uses loadurl and saveurl  for dynamically loading data from the database
2) the user clicks on + sign or the Add new record button on this page (currently not provided)
3) A blank row appears on the grid
4) the first column is a drop down
5) When the user selects an item from the drop down, I want to go back to the database and pick values for the remaining fields for the new row. After fetching those values I want to show those values in the respective fields.
6) User if required can change those values before clicking on the SAVE button.
7) On clicking SAVE button, data is saved to the database.

Steven, I would like to know if #5 is doable using SigmaGrid and if yes, how should we approach towards it.

A reply will be highly appreciated as I have been waiting for this reply for a long long time.

Warm regards,
Stan

[steven]

I really understand your requirement.
You can't do that unless you change some sigma grid code by your self.

[humi]

If you wanted something simple, without editing the grid. Do a static html form, written in JavaScript to do what you need, and place that above the grid.

Because as of this version (SigmaGrid 2.1.02) The grid is not capable of reading user input before it has been saved.

You can test this by enter information, and using:
var newrows = mygrid1instance.getSelectedRecords(); // example of getting the user input data: // newrows['0']['columnname']

This will show that the grid cannot read it. And hopefully in a later version, this will be resolved, and added to the feature list.