update a column not displayed in the grid

I have a column CustomerId that I do not show in my grid. It is passed as a paramater to the php file that i use to display the grid. when i add a row in the grid, how do i update the CustomerId when the grid row is inserted?

Hi Bill,

If the CustomerID field has a default value in the MySQl table, the add operation will use that. Alternatively you can give the customerID field an auto_increment property in MySQL and there will be an ID for you generated.

If that you want to assign a special customerID to the non-displaying field, you have to use the addparams option to pass the ID from javascript to the SQL backend (see exampleGrid9 on Drasticdata.nl). Of course, this only works if you have this id or you add a mechanism for the user (extra field) to specify the customerID as you specified it not to be displayed in the grid.

Hope this helps,

regards,

dd