Need help with "New Record" button in grid

[WindForce]

Hi
I have a grid with a few fields, and a EditRecord button on each row. Clicking on that button will bring up a dialog to edit the current record.
In this grid, i would like to remove the empty line for adding new records, and instead use a "Add Record" button. The button should do the following:

- add a new record to the grid
- click on the "EditRecord" button of the newly generated row

How do i do that?

Thanks
Jaime

[Lance Gurd]

Re: Need help with "New Record" button in grid

video d24 should be what your looking for here

[WindForce]

Re: Need help with "New Record" button in grid

Hi Lance
Thank you for your help. I already use a lot the dialogs to add or edit records. The problem here is that i cannot use the dialog in "Add new record" mode, since i need to know the primary key upon entering, hence my request to *always* use the EditRecord button...

[Davidk]

Re: Need help with "New Record" button in grid

SQL or DBF? How is the key being set? What is the key? Auto Incremental? No new record rows displayed... hit a button somewhere on your grid (not on a row) that adds a new record row, then immediately opens the dialog to edit this new record. So... the key is being set and the record saved in the grid, then opened for edit in the dialog.

[WindForce]

Re: Need help with "New Record" button in grid

Yes David you got it right. It's mySQL and key is autoincrement

[Davidk]

Re: Need help with "New Record" button in grid

One way to get this done is to use a couple very nice features Alpha 5 puts in, but you have to be happy with how they work... and we have to cheat a little bit.

In the Grid, Update Settings, set Number of new rows to 1
Next, in the Editing Properties, there is a New records edit style. Set this to ShowOnDemand.
Check on Hide New Row after Insert.
There's a property that reads New records button label, and you can set this, but it's not a button... it's a Hyperlink (unless there's somewhere you can change this, but I can't see it.)
Check on Allow individual rows to be saved.

Next, in the Grid Properties, go to the bottom where it reads Javascript - System Events. There's an event in here named onNewRowsShow. In here put...

{grid.Object}.setValue('G','CUSTNAME','-1','X');
{grid.Object}.submitGridPartRow(-1);
//place this Javascript in your code, and then reference the rowNum variable.
setTimeout("var rowNum = {Grid.Object}._selectedRow;{grid.Object}.setValue('G','CUSTNAME',rowNum,'');$('{Grid.ComponentName}.V.R'+rowNum+'._UNBOUND_BUTTON_1').click();",2000);

So, when the New Record hyperlink is clicked, Alpha shows the new row.
Here's the problem... the new row is shown but we need to save it now, so that the auto increment will fire. So, write something into a field... here I'm writing X into my CustName field.
Next, submit it. Now we have a key.
And next, we have to cheat a bit more. Everything now happens too fast and all at once.

Our record has been saved, and we're on the current existing row, so we go get that row number.
Now change the field CustName back to nothing, and then click the button.
But, we have to delay everything a bit, in order to let the data submission happen. So we wrap these statements in a setTimeout and delay everything for a couple of seconds.

Try it and see how it works for you... then you can start seeing how to make it better.

EDIT: Forgot to make the button click variable

[WindForce]

Re: Need help with "New Record" button in grid

Hi David
Was going to write you i was getting all the time a "Method not supported" error of some sort in the javascript, but luckily the 2 seconds delay you put showed me the reason.
When running the code, i see the 'X' get into the field and the record is saved, then the delay of 2 secs, then the error. I noticed that the newly entered row, while waiting for the click to trigger, *was not selected*. So i did a test in a grid where i already had 1 record, selected it, then clicked on the "Add new" link and voila, no error, but of course the record that shows up for editing was the selected one, not the newly added. What javascript does select the newly saved record right after submitGirdPartRow(-1) ?

Thanks for your great help!!
Jaime

[Davidk]

Re: Need help with "New Record" button in grid

Hey Jaime,

We must have some different settings on the grid because my newly saved record is, by default, always the current, selected record after it's saved. That's why I didn't have any code in there to set the current record.
Setting a current record is a bit tricky because you don't really know what the latest record is. There is a grid method for this... {grid.Object}.setSelectedRow(rowNum) but you have to know the row number. You could try putting this into the setTimeout statement.

So... if you comment out the whole setTimeout statement, and run your grid, adding a new record and submitting it... your current record is not record just added? If not, why is it that way on my system, under Live Preview, Firefox and Chrome?

[WindForce]

Re: Need help with "New Record" button in grid

Maybe the fact this grid is a linked child grid has something to do with it?
I will comment the timeout and check with 1 record then with many records to see what's going on with the current record. Will report back

Jaime

[WindForce]

Re: Need help with "New Record" button in grid

Ok the problem is that it's a linked child grid. Upon adding the new record, the first record is selected ( maybe a refresh of the parent is the cause ? )
Anyway, is there someway , before the setttimeout, to set the focus on the newly added row? In my case, i entered 'new' in the carid field, so is there some way in javascript to search for 'new' in the carid field, select this row, then go on with the settimeout call?

Jaime