Update Button on Grid

[chadbrown]

Hi everyone here is a little thing that i would like to add to a grid component which to me is a massive time saver. I have attached a image to explain what i would like to do. I believe this one is for the top of the class!

Chad

[wmz]

Re: Update Button on Grid

Hi

I am not sure if this is exactly what you need...I adopted something I used for one of my projects. I use a solution with an input field and a button, both in the grid toolbar. Pressing the button in the toolbar will

a. set the "Clearing" fields in the grid with the value of the input field in the toolbar, but only for currently visible records in the grid. If no record is shown as a result of a search criteria etc. , no values are set.

b. set the grid fields "dirty"

Records can be updated individually. I also added a submit button to the toolbar so you can commit all records.

I attached a gif and a pdf for instructions.

Have fun

Wolfgang

[chadbrown]

Re: Update Button on Grid

Thanks Wolfgang this is exactly what I am trying to do!

Is there any chance you can upload the example component that is in your pdf and image and I can adapt to my table.

Thanks again for the help.

Chad

[wmz]

Re: Update Button on Grid

sure, here you go. I used the export function. You should be able to import the zip as is.

regards

[chadbrown]

Re: Update Button on Grid

Works awesome!
I just have to convert it to a MYSQL table thanks again.
I did a quick little video for all to see this in action, very basic table and info a little ruff around the edges but you will all get the point.

http://www.screencast.com/t/ZTk2NDIy

Chad

[wmz]

Re: Update Button on Grid

Cool video. Well done. Glad it worked out for you.

Just one remark to the toolbar button js code. Since in this example the overall js is rather simple, you could have put all the js code directly in the onclick() event of that button.

However, since I normally do more complex things such as opening linked grids in modal windows etc. I let Alpha generate the action script code in a row based button, I hide the button and I delegate the onclick() from the toolbar to the (hidden) row based button.

regards

[Anis]

Re: Update Button on Grid

Thanks Wolfgang; I was looking to do the same thing.

I will try this and I'm sure it will work .

[Anis]

Re: Update Button on Grid

Wolfgang;


I set this up on my component, I do need some help in some modification if you don't mind.

The field clearing is a field that exists in the database and has a number already, how do I set this to set clearing for only those records that are displayed in the grid and have a 0 (zero) in that field.
Not change anything else, keep all other data in the clearing field intact.

Is that possible ?

Thanks

[chadbrown]

Re: Update Button on Grid

you could just filter the grid to only show items with a zero.

[wmz]

Re: Update Button on Grid

Hi

Follow Chad's advice or modify the code in the button onclick() to check for zero:

var rowcount={Grid.Object}._rowsInGrid;
for(row = 1; row <= rowcount; row++)
{
	if ({grid.Object}._getValue('G','CLEARING',row) ==0)
	{
		{grid.Object}._setValue('G','CLEARING',row,$('{Grid.ComponentName}.CLEARING_INPUT').value);
	};
};

regards

[Anis]

Re: Update Button on Grid

Thank you Chad, Wolfgang.
I understand filtering the Grid is one way of doing this, but I wanted to have this control becuase we have many accounts, and the rate (clearing) changes every month, so this way I can have the use filter for the account only and if there are records with missing rates he can fill in those records.

It not easy to know the rate for each account because it changes all the time. otherwise it would have been easy to filter the grid by account and zero rate.

I think this way will show accounts with rates charged and records missing the rate, so now the user sees the rate and able to add that rate to the missing records.

Thanks again for the help