Calling a grid from a grid

[Peter.Greulich]

Re: Calling a grid from a grid

It may be a timing issue, but something doesn't seem right here.

Put an alert(vGrid); in after the first line where it gets the field value. If the field value shows then something weird is going on. You can put a 2nd alert at the end of the script as a follow up.

[Peter.Greulich]

Re: Calling a grid from a grid

D is for detail part, G for grid part. Make sure you use the right one.

Some how it is a timing issue. The grid call fires before the field value is retrieved, hence the one step behind. Worse comes to worse, you will have to use an Ajax callback to call an xbasic function after you retrieve the field value. JS is fast, xbasic "slow".

[JimFtex]

Re: Calling a grid from a grid

Thanks Peter,
I made the corrections and that gets me closer....but it seems to run a cycle behind;

first time in - I press the button and nothing
next click - Aciphex form is displayed.
move to Acyclovir and click - the Aciphex form displays
click agian - the acyclovir form displays
move to alesse and click - acyclovir form displays
click again - alesse form displays


I have this in the onClick event, but it seems to be getting the form name from last viewed, if that makes sense.
I tried changing from 'D' to 'G' in vGrid = {grid.Object}._getValue('D','NOTE_TO_BUYER'); but that didn't work
either.

Am I missing a response or a function that should happen first?

thanks for the help,
Jim

[Peter.Greulich]

Re: Calling a grid from a grid

I see the problem. Your case statement is using my example ...

case 'Grid1':


case 'Grid2':


case 'Grid3':


'Grid1' etc needs to be the name of the corresponding grid that the next line opens up. If a field "grid" value is Aciphex, then the statement should read

case 'Aciphex':

etc etc.

Also make sure you close with a } not a { as you show in your document.

Yeah, no need to use a filter.

[JimFtex]

Re: Calling a grid from a grid

Peter, maybe the last Doc did it.

Multi-Grid Display

[JimFtex]

Re: Calling a grid from a grid

Multi-Grid Display.doc

[JimFtex]

Re: Calling a grid from a grid

Multi-Grid.docMulti-Grid.doc

Peter, I'll try to insert the document again. Not sure what I'm doing wrong.

[Peter.Greulich]

Re: Calling a grid from a grid

The doc you attached only contains my post.

[JimFtex]

Re: Calling a grid from a grid

Peter, I tried setting up 3 grids with the information. I've attached a Word doc to show my process. I hope it makes sense or
I've done something wrong....let me know. I'm not sure if the document attached, if not email me at: [email protected]


thanks for the help,
Jim

[JimFtex]

Re: Calling a grid from a grid

OK, Peter....Thanks. I'll give this a try and let you know how it turns out.
Jim

[Peter.Greulich]

Re: Calling a grid from a grid

Jim,

I must have been having a stupid attack. Instead of messing around with that intricate JS that A5 generates, do this:

On your hyperlink or button put in Action JS in the OnClick event. For each grid, create one action. So if you have 25 potential grids to open, you'll have 25 Action JS "Open Grid" rows. Then insert before the first row and between each and every grid row an InLine Action JS. The first Inline will have this:

//get a field value
vGrid = {grid.Object}._getValue('D','SOME_FIELD');

//JavaScript case function
switch (vGrid)
{
case 'Grid1':

Then you will have the first Action JS to open "Grid1"

Then the next Inline is:

break;
case 'Grid2':

And the next first Action JS to open "Grid2"

Then the next Inline is:

break;
case 'Grid2':

and so on...

The last inline at the very end after the last Gird is:

}


If you were to convert the whole thing to text or "view JS", you get something like this:

//get a field value
vGrid = {grid.Object}._getValue('D','SOME_FIELD');

switch (vGrid)
{
case 'Grid1':
 {grid.componentName}_G__UNBOUND_HYPERLINK_1_1({grid.rownumber},'{grid.rowId}',this);
  break;
case 'Grid2':
   {grid.componentName}_G__UNBOUND_HYPERLINK_1_2({grid.rownumber},'{grid.rowId}',this);
  break;
case 'Grid3':
 {grid.componentName}_G__UNBOUND_HYPERLINK_1_3({grid.rownumber},'{grid.rowId}',this);
  break;
case 'Grid4':
  {grid.componentName}_G__UNBOUND_HYPERLINK_1_4({grid.rownumber},'{grid.rowId}',this);
  break;
default:
  {grid.componentName}_G__UNBOUND_HYPERLINK_1_4({grid.rownumber},'{grid.rowId}',this);
  //or whatever...
}

The reason not to convert the whole thing to text is so if you need to change a grid opening setting.

This method works well and this technique can be used for other things such as selecting a report, etc.

[JimFtex]

Re: Calling a grid from a grid

If I understand right you want to open from grid1 another grid2. The selection value comes from a field value in grid1.

If so you can use lookup with linked grid (video #8). You have to create 5 (5 forms) extra grids holding actual grid name and use this extra grid as a primary lookup grid with grid1 (and then select the right one). With this technique you don't have to write any code.

Thanks Ken, that's kinda where I'm at now. I created a new grid with 25 buttons on it. Each calls the correct grid but that is a work-around until I get this figured out. Not sure which video #8, but I've tried linking the grid also.

Thanks guys, I'll keep poking around and trying different things to get this worked out.
Jim

[Peter.Greulich]

Re: Calling a grid from a grid

{Grid.ComponentName}=":WhatGrid"

That's not going to work. You're mixing xbasic with JS. You need to get the field value using

{grid.Object}.getValue(part,name,[row - omit for Search and Detail View part])

and probably evaluate it using JS.

[JimFtex]

Re: Calling a grid from a grid

Thanks Peter. I tried to modify the code, but all I can do is close the window after modifying the code.
I'm not sure where to put the new code. I did put 2 lines in Override Settings {Grid.ComponentName}=":WhatGrid"
All I get is the original grid with the ID filled in from the :WhatGrid argument.

Still working at it.

[kkfin]

Re: Calling a grid from a grid

If I understand right you want to open from grid1 another grid2. The selection value comes from a field value in grid1.

If so you can use lookup with linked grid (video #8). You have to create 5 (5 forms) extra grids holding actual grid name and use this extra grid as a primary lookup grid with grid1 (and then select the right one). With this technique you don't have to write any code.