Initial Value

[swest]

Can you set a intial value of a field from another field that is not a session variable? For example, I have an id field that has numbers 1,2,3,4.... in one grid, I want to set the intial value of a field in a second grid to the same value as the id field in the first (one) grid. Can this be done?

[Davidk]

Re: Intial Value

You could use Window variables. In whatever you're using to open the 2nd grid (e.g. a Button, Action Javascript) you could put some Inline Javascript before it and use the .getValue method.

E.g. window['id1'] = {grid.Object}.getValue(part,name,[row - omit for Search and Detail View part]);


Then, in the 2nd Grid, use the Javascript onGridRender event and use the .setValue method

E.g.

var id1 = window['id1'];
{grid.Object}.setValue(part,name,[row - omit for Search and Detail View],id1);

Another method, playing strictly by Alpha stuff, would be using the technique in video M53... excellent stuff.

[swest]

Re: Intial Value

Thanks, not sure this is exactly what I am looking for, let me see if I can explain what I am trying to do more. I have a parent grid that has a linked grid. In the linked grid I am going to have a file upload action. When the user uploads the file I want to write an id value (that comes from the parent grid) into the linked grid. This id value will tie who the document belongs to, for example, if Jane from the parent grid with the id of 1 uploads a file then the linked grid will have that value '1' written to its id field. A one to many relationship.

[swest]

Re: Intial Value

Let me add some more that I left out. The parent grid id field is not tied to Jane, but to what Jane might own. For example, the parent grid might have dinner plate, breakfast plate, spoon, fork, knife, etc. So each of these objects in the parent grid as a number id and the linked grid is where Jane would upload the file and needs the id from dinner plate written in the linked grid as '1'. It also needs to be able to change, for example if Jane clicks on breakfast plate in the parent grid and uploads a file, then '2' needs to be written in the linked grid id field.

[Davidk]

Re: Intial Value

Hey Steven,

Is your linked grid open and displayed with your parent grid? Or do you click on "plate" and your linked grid opens? Or is the Row Expander Linked Grid stuff. There are so many ways to get a linked grid that we all have to be really specific now. How your linked grid opens may determine the best way to get this done. Overall, though, you'll be setting a window variable on the parent grid and then grabbing that window variable when you starting working with the linked grid.

[swest]

Re: Intial Value

The linked grid is going to open with the parent grid. I want the linked grid to be a document repository that holds information about each document and shows an icon for each document that the user can click on to open or download the document.

[agillbb]

Re: Intial Value

Sounds like you need to set the linked grid inside the parent's row expander.

[swest]

Re: Initial Value

David,
Can you clarify where you put the code. Also what do you mean in the code where you say part,name,[row - omit for Search and Detail View part]. Also is this [row - omit for Search and Detail View part] in the code necessary?

[Davidk]

Re: Initial Value

Steven, what is the Link between the Parent Grid and the Linked Grid? It's kinda like a shopping cart... you have a list of items, a user clicks on an item and it gets added to the Linked Grid, where that user can then upload an image for that item. But the definition for a Linked Grid requires a Parent field linked to a Child field... what's that in your case?

[swest]

Re: Initial Value

Under Define Linked Content, I have ID field (parent) to MID (child). Is that what you are talking about?

[Davidk]

Re: Initial Value

Can you post a screen shot of your parent grid and linked grid? Sometimes these things are a little tough to see.

[swest]

Re: Initial Value

Sorry still trying to get use to linked grids. Do you just want a screen shot of the 'Define Linked Content'? Thanks for your help!

[Davidk]

Re: Initial Value

The Main grid and the linked grid... with data showing.

[swest]

Re: Initial Value

Attached.Linked table.jpg

[Davidk]

Re: Initial Value

Hey Steven,

Still trying on this one... your image is of a parent grid with names. The linked grid has items, in this case a plate that Brad owns.

The parent grid is showing Rec. # 1, Row # 1. Is this the number you want to feed into your linked grid? Or is there a hidden field in the parent grid?

Your earlier post says...

For example, the parent grid might have dinner plate, breakfast plate, spoon, fork, knife, etc. So each of these objects in the parent grid as a number id

But your image doesn't look like this. The Parent grid is holding names, not objects. The Linked grid is holding objects. Unless... there's another grid in there that opens up once the Upload button is pressed.

The image looks like a one to many relationship where Brad owns a number of objects.

Sorry... I'm still missing something.