Open 2nd modal Grid after new record

[Peter.Greulich]

Ideally*, I would like to do the following:

Open a modal grid for new record only (no problem).
On the submit, I want to:

1. Get the auto-increment id value (which is shown as <auto>)
2. Close the modal entry form
3. Open a different modal grid synced to display new record I just created.

There seem to be different ways to do this, but I can't them to work. One significant stumbling block is that I think the grid closes on submit and never holds the newly created autoinc ID. Thus I get an error message saying "ID not found".
---
* I'm willing to compromise on the modal aspect, and if need be, I'll substitue an a5w page for the grid, although I would prefer the grid.

Gotta be a way to get this to work!

[Peter.Greulich]

Re: Open 2nd modal Grid after new record

Using the grid's onPageRedirect event works and opens the a5w page:

e.url = "Pay_Allocate.a5w"
Of course, this displays the 1st record in the table, not the one I just created.

But this doesn't work:

e.url = "Pay_Allocate.a5w?Payment_Id=" + e.rv.v.r1.Payment_Id

The error message says it can't find the e.rv.v.r1 subelement.

[Lance Gurd]

Re: Open 2nd modal Grid after new record

Hi Peter,

If I am understanding this correctly this is how I do it.

Grid with the Detail view set to enter new record. On the grids properties tab, in JavaScript - system events, in the AfterDetailViewSubmit event I put the following JavaScipt

{grid.Object}.closeDetailView();
{grid.Object}.pageNavigate('last')

[bea2701]

Re: Open 2nd modal Grid after new record

After insert record returns the key from the database put that in a session var and open the other grid. By using LAST it is not 100% that it is your key unless your app is single user.

Eric

[Bob Moore]

Re: Open 2nd modal Grid after new record

I've covered this before ... In V10 you need to reference the rows of an uncommitted new record as r_1 instead of r1.

Now, since you are creating a new record and the key field is set to auto-increment by the database, it never gets set until you actually commit the record to the table.

So what I do is setup a uuid field that I can populate with the api_uuidcreate() function for it's initial value and then reference that field as the linking field on submit. This is very reliable and works great.

I like to use session variables here to keep the URL untouched but you can use either technique.

[Bob Moore]

Re: Open 2nd modal Grid after new record

To document the workflow I just described ..

In the grid update settings, set the redirect page to <Event>.
In the grid Events, on PageRedirect ...

e.rv.session.uuid=e.rv.v.r_1.uuid ' create session variable
e.url="target.a5w" ' page redirect

Now to handle the grid filter on the target page, set an argument in the grid to be a session variable and filter the grid on that argument.

[Peter.Greulich]

Re: Open 2nd modal Grid after new record

e.rv.session.uuid=e.rv.v.r_1.uuid ' create session variable
e.url="target.a5w" ' page redirect

Now to handle the grid filter on the target page, set an argument in the grid to be a session variable and filter the grid on that argument.

Bob,

What I fail to understand, how is uuid different than autoincrement? IOWs, where does uuid get set? If it is set in the table, isn't that the same problem as autoinc? Or do you set it as a calc field in the grid itself? Even that requires a trip to the server. I'm missing something here?

[Peter.Greulich]

Re: Open 2nd modal Grid after new record

After insert record returns the key from the database put that in a session var and open the other grid. By using LAST it is not 100% that it is your key unless your app is single user.

Is there a command to close the grid itself? If I can get the value using AfterInsert, close the grid automatically and open the 2nd grid filtered on the value, I'm in business.

[bea2701]

Re: Open 2nd modal Grid after new record

Latest release subject: about GRID refresh [row] should do the job

[Bob Moore]

Re: Open 2nd modal Grid after new record

In V10, use the initial value property. This will set the value on the client side, prior to submission to the server.

http://screencast.com/t/7jffQY0k

[Peter.Greulich]

Re: Open 2nd modal Grid after new record

In V10, use the initial value property. This will set the value on the client side, prior to submission to the server.

http://screencast.com/t/7jffQY0k

Bob,

Thanks. Seems to good to be true. Strictly speaking, that's not possible. api_uuidcreate() is an xbasic function, so it has to fire on the server side. But maybe, if I understand you, it fires that server side, returns it to the grid, and then submits the grid to the server/table write. Is that what is happening?

[mmaisterrena]

Re: Open 2nd modal Grid after new record

In this situations i filter the second grid using the table max or dB max functions and in the filtre part of the funcions i just filter by the user, i normaly put tht filtring code in the a5w page not the grid itself, IT works perfectly in v 9 but havent tried it on versi�n 10

[Peter.Greulich]

Re: Open 2nd modal Grid after new record

Maurico,

Thanks. Interesting method. Of course, I would prefer to use the grid itself, rather than a page. Think Tabbed_Ui.

[mmaisterrena]

Re: Open 2nd modal Grid after new record

I dont think that table max or dB max would work in the grid filter but you can try
another option would be to filter the grid by user and order r�cords inversly by record number and set the properties to only show 1 r�cord. Easy but not as clean because the r�cord navigator Will be there

[Bob Moore]

Re: Open 2nd modal Grid after new record

Peter,

Sorry, poor explanation on my part. I was thinking along the lines of the database server (SQL).

Obviously the xbasic function, api_uuidcreate() is running on the Alpha WAS and the value is being set prior to the display of the row, most likely in something like the OnInitialValueCalculate event.

If you wanted to you could choose not enter the initial value as a property and add the following to the OnInitialValueCalculate event : e.newValues.uuid=api_uuidcreate().

So you can run xbasic in any of the server side events and of course javascript on any of the client side events. You can also write an ajax callback to run an xbasic script that can return a javascript object and/or return the javascript or html code to run on the client. V10 offers some amazing capabilities once you get the hang of it!