OnCellEdit client script is not working?

[Shantharao]

Hi All,

OncellEdit client script is not working, please tell me the issue in the below code

I have to use g_form.getReference call back function to populate user email 

u_name is reference filed refering to USER table

u_email is string filed, onCellEdit of Name(refernce) filed I have to populate user's email in the email string filed

function onCellEdit(sysIDs, table, oldValues, newValue, callback) {
var saveAndClose = true;
alert("test on cell edit");
if (newValue != oldValues) {
var userEmail = g_form.getReference('u_name', populateEmail);
alert(userEmail.email);
saveAndClose = true;
} else {
saveAndClose = false;
}

function populateEmail(userEmail) {
g_form.setValue('u_email', userEmail.email);
}
callback(saveAndClose);
}

[Jaspal Singh]

Hi Shantarao,

g_form will not work from list. You can use a onChange() client script or a before update business rule to update the field. Something as below

if (current.u_name.changes()){
  current.u_email= current.u_name.email;
  current.update();
}

[Shantharao]

Hi Jaspal,

I tried before business rule, but it is not working as expected, any other suggesions please

Thanks

[Ankur Bawiskar]

Hi,

Can you share the Business rule script?

Regards
Ankur

[Shantharao]

Hi  Bawiskar,

Please find the code below

if (current.u_name.changes()){
  current.u_email= current.u_name.email;
  current.update();
}