How do I retreive a calculated value from a child grid

[jackp_MDB]

I have a UX with a repeating section. In the repeating lines I have a button to open a grid where the user can add in purchases for that record.

The expense grid includes a calculated total expense field. I need to return/pass this total field back to the repeating container line.

How is this done?

Jack

[Michael1954]

Re: How do I retreive a calculated value from a child grid

Hi Jack

When you set up the button the calls the grid you need to give the grid an unique Alias.
You can then get a pointer to the child (Grid)

With the pointer you can then use methods GetValue you then want to use this to setValue.
Because you are using the repeating section you need to pass in the rownumber, care this needs to be zerobased.

You also need to decide what will trigger this.

Michael

Tomorrow I should be at my desk, reply if you want more details.

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

Thanks Michael...I'll give it a go and get back if I can't get it working.

Jack

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

How do you capture the calling parent when going from a repeating row in a UX component to call a linked grid.

Everything I try always get a "false" or blank id/name.

Since I guessing this might be a common requirement, I must be missing the issue.

My latest failed coding (in the grid, Client-Side onGridRender event) is:

var myparent={grid.Object}.getParentObject();
if (myparent) {
alert(myparent)
}
else
{
alert('No parent object detected.');
}

Jack

[Michael1954]

Re: How do I retreive a calculated value from a child grid

Hi

I am not up to speed yet as I have just arrived in Hong Kong and I don't have Alpha on my laptop yet.

Is your syntax correct? You are calling from a dialogue but using {grid.object} I cannot check this.
Another thought is, is the grid the parent or child?
If the UX was launched from the grid then the grid is the parent. If the UX calls the grid then the grid is the child.

Michael

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

Michael,

I've tried using {grid.Ojbect} and {dialog.Object} both with negative results...does not see the parent.

The grid is called from a button located in a repeating section of a UX component. The UX (or more correctly, the row in the repeating section) is calling the grid.

I think the grid should be a child of the UX/repeating row in the UX.

Jack

[Davidk]

Re: How do I retreive a calculated value from a child grid

Jack,

You're opening a Grid, using Action Javascript I assume... you don't say... from a UX Repeating Section.

You're right that the Grid is a Child of the UX.

You really don't need to deal with the Repeating Section Active Row at the point of opening the Grid. You can get that when you're saving values back to the UX from the Grid.

Once you're in your Grid... you're dealing only with the {Grid.Object} object... nothing else. (That's why any attempt to use {dialog.Object} will fail.)

Your code should work... it works for me... except that you're trying to do an Alert on an Object... which doesn't really work.

Your Calculated Total Expense field... is that per row? Or for the whole Grid... doesn't really matter... just curious.

I assume you put your code into the onGridRender event just for testing... since it doesn't really help to have it there.

You don't say what you're using to "invoke" setting the UX value from the Grid... a button? A Grid event? Again... doesn't really matter too much... just curious.

This code should work for you... I've got this running from an Action Button I've added to the ToolBar of the Grid...

var pobj={grid.Object}.getParentObject();
if (pobj) {
     //alert('There is an object.');
     var currentRow = pobj.getRepeatingSectionActiveRow('CONTAINER_1', true);
     //alert(currentRow);
     pobj.setValue('EXTENSION:'+currentRow,'44.44');
     }
else
{
     alert('No Object Detected.');
}

So... get the Parent of the Grid Object
Now that you've got the dialog parent... you can execute dialog methods on that object.
Go and get the current Active Row of your Repeating Section. Mine is named 'CONTAINER_1'.
Now set a value (e.g. my UX control 'EXTENSION') with a value. Your value is going to be your calculated value.
And... you're setting a Repeating Section control... so the syntax is controlName:rowNumber

In your UX, have a look at the help for the function getRepeatingSectionActiveRow to understand the optional flag.

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

Davik,

Thanks...getting closer. Mine is working using a button on the grid also...

Answers to your questions:

1. In the UX repeating row, I'm using a button that calls an Action Javascript to "Open a Grid Component."

2. I need to deal with the calculated total expense field...updates as individual grid records are updated. Each addition/deletion/change on a grid row could change the total expense calculation. (The grid is "linked" to the id in the UX repeating row...only those records in the Grid associated link are shown...not the entire grid.)

3. OnGridRender was used to attempt to get the .getParentObject() code working...not as final use.

4. I am looking for an "automatic" way to set the value in the UX repeating row equal to the calculated total expense field in the grid. I was thinking that once I had the code correct to add it to the grid Client-side events of "afterRowDelete" and "afterRowSubmit."

Right now, I've added an action button to the grid's tool bar as you spoke of...it correctly copies the "44.44" back into the UX repeating row.

How do you reference a "e" field in the javascript code. (I believe its the "e.summaryValue.EXPENSECOST.Total" field?)

[Davidk]

Re: How do I retreive a calculated value from a child grid

How do you reference a "e" field in the javascript code. (I believe its the "e.summaryValue.EXPENSECOST.Total" field?)

Is that your Grid Calculated Field?

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

Davidk,

Yes...the grid row has an "ExpenseCost" field that the user enters the actual cost of the item(s) they purchased.

That field has a calculated "total expense" field that is then updated/changed as the individual rows are updated.

I believe on the Server side, the codes reference the summary fields as "e.summaryValue.FIELDNAME.Total" or count or average, etc.

Jack

[Michael1954]

Re: How do I retreive a calculated value from a child grid

Hi Jack

Just got up and just got Alpha working. You are lucky enough to have a reply from David. I am not going to add to this discussion as David is a master and I am just a student. Alpha keeps me informed of changes on the thread, if I can help I will.

The knowledge that I was trying to impart came from David; he is clear in his language and generous with his time.

Michael

[Davidk]

Re: How do I retreive a calculated value from a child grid

So... this gets a little complicated... and so that leads me to believe there's an easier way. That being said... here it is.

First... here's the challenge: You want to open a grid... from a UX... and change a value in a grid. Then, have a summary value in that grid recalculate... and pass that new summary value back to the UX.

Second... here's problem #1: The summary values in a grid do not recalculate unless the grid is refreshed. Not a row refresh... but a full grid refresh.
The full grid refresh poses a bit of a new problem... but we'll get to that.

Third... here's problem #2: We're trying to grab the summary value and send it back to the UX. We're doing this in Javascript on the client side... which is... faster than a speeding bullet. Meanwhile...we're waiting for the grid to update SQL tables, refresh, and recalc summary values all on the server side... which is always a step behind the client.

The solution is to ask the client to slow down a bit... let the server catch up.

In the Grid, Server-side event, onSummarySectionRender...

e.javascript = "{grid.Object}.__summaryTotal = " + e.summaryValues.TOTAL.Total + ";"

Here we are setting a variable in the grid object namespace which holds the value of our summary field.

In the button which updates the UX...

var pobj={grid.Object}.getParentObject();
if (pobj) {

	var rowNum = {Grid.Object}._selectedRow;
	{grid.Object}.submitGridPart();
	
	setTimeout(function(){
	{grid.Object}.refresh();

		setTimeout(function(){
			var currentRow = pobj.getRepeatingSectionActiveRow('CONTAINER_1', true);
			var summaryTotal = {grid.Object}.__summaryTotal;
			pobj.setValue('EXTENSION:'+currentRow,summaryTotal);
			{grid.Object}.setSelectedRow(rowNum);
			},500);
			
		},300);
	}
	else
	{
	alert('No Object Detected.');
	}

Here we are using 2 setTimeout functions. One to allow the submit to take effect... and one to allow the refresh to take effect.
The submit takes place... then the refresh takes place... now we have our current summary total which was placed into a grid object variable in that server-side event.
We grab that variable and send it over to the UX.

A new problem is that when we refresh the Grid the current record jumps to the top of the displayed page. So... we first grab that row... and then set the current record back in place after doing everything else. It's not the prettiest... but not too bad.

Now... all this is way too complex... it works... but it's not necessary. Kinda neat... but too much trouble.

So... in the morning I'll post a much cleaner solution using the same code, but just using the Server-side event. I think that will work.

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

Davidk,

Updated my grid with your coding and it works as desired...but I don't understand your note on the total update issue.

I see that when I press the "update" button on the grid toolbar that we are refreshing the grid, but prior to this, when I change a value in the grid, either a new record/row or change the cost value in one of the existing rows, if I submit the change/update the total field shows the proper calculated amount.

Is this "built-in" to the grid and happening in the background, or is it a false sense of "working?"


Jack

[jackp_MDB]

Re: How do I retreive a calculated value from a child grid

Michael,

It is amazing to me how much the user community knows about Alpha 5. I'm a bit of a thick skull at times and seem to be easily lost without some type of documentation to explain the intended working of the various pieces, components, tools, etc.

Once the solutions are found, it seems so easy. What a powerful program once you learn the "tricks."

Jack

[Davidk]

Re: How do I retreive a calculated value from a child grid

Davidk,

Updated my grid with your coding and it works as desired...but I don't understand your note on the total update issue.

I see that when I press the "update" button on the grid toolbar that we are refreshing the grid, but prior to this, when I change a value in the grid, either a new record/row or change the cost value in one of the existing rows, if I submit the change/update the total field shows the proper calculated amount.

Is this "built-in" to the grid and happening in the background, or is it a false sense of "working?"


Jack

This may depend on your grid settings. In your Grid Update settings... in the property Row Refresh after Edits... what that's set to? Mine is set to <auto select> and my Summary values do not change after an edit. If set to Full-Page then the summary value updates because the grid is refreshed. What is the behaviour of your current row. When using the Grid Submit, when you submit a change, does the current row stay where it is?