Guriddo » Topic: How to use rowid in script after successful Add/Edit (form)

How to use rowid in script after successful Add/Edit (form)

Guriddo
How to use rowid in script after successful Add/Edit (form)

This topic has 2 replies, 2 voices, and was last updated 6 years, 7 months ago by bogdanm.

Creator

Topic
January 18, 2018 at 11:09 am #126582
bogdanm
Participant
I’ve tried the following event:

$grid->setNavEvent(‘edit’, ‘afterSubmit’, $myScript);

where the PHP variable $myScript contains the javascript I need to run.

It does trigger when adding or editing, but in my script I need to use the rowid of the row that’s being edited.

Is there a way to read the rowid in an ‘afterSubmit’ event?
- This topic was modified 6 years, 7 months ago by bogdanm. Reason: typo
Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies

January 19, 2018 at 5:57 am #126584

guriddo.support

Participant

Hello,

The afterSubmit event used in form editing accept 3 parameters:

– response is the data returned from the server (if any)
– postdata is the data sent to the server
– oper – determine in which mode is called – add when add row and edit when it is edited

If nothing is changed in the default settings of prmNames then the postdata rowid is stored in postdata.id property. In this case you can yse the following code to get the rowid in edit mode in case the datatype is not local

afterSubmit : function( response, postdata, oper) {
   if(oper === 'edit') { 
      var rowid = postdata.id;
   }
}

afterSubmit : function( response, postdata, oper) {

if(oper === 'edit') {

var rowid = postdata.id;

}

Kind Regards
Will

Guriddo Support Team

January 19, 2018 at 9:17 am #126585

bogdanm

Participant

Thank you.

At first it didn’t work but I dug deeper into the parameters and figured out what I was doing wrong.

Here’s my code, in case someone else is trying to do the same thing and finds this thread:

$grid->setPrimaryKeyId('someColumn');
$myScript=<<<BLABLA
function(response, postdata, oper)
{
    if(oper === 'edit') {
        var rowid = postdata.someColumn;
    }
    //
    // here I put the stuff I need to do
    //
    return [true,''];
}
BLABLA;
$grid->setNavEvent('edit', 'afterSubmit', $myScript);

$grid->setPrimaryKeyId('someColumn');

$myScript=<<<BLABLA

function(response, postdata, oper)

{

if(oper === 'edit') {

var rowid = postdata.someColumn;

}

// here I put the stuff I need to do

return [true,''];

}

BLABLA;

$grid->setNavEvent('edit', 'afterSubmit', $myScript);

Author

Replies

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Registered Users: 12,249
Forums: 7
Topics: 10,947
Replies: 23,146
Topic Tags: 324
Empty Topic Tags: 9

5 Users Online

Users: 5 Bots

Stay connected with us in your favorite flavor!

How to use rowid in script after successful Add/Edit (form)

Search Forum

Recent Replies

Forum Statistics

UserOnline