Client Scripts

[Phani Pasupulet]

There are 2 tables 
sys_user 
s1(custom table)

here user is referencing the sys_user table
I want to auto populate email when user was selected 
I have written some code but it is not working why....?
Can anyone help

[Aman Kumar S · Accepted solution]

Hi @Phani Pasupulet ,

I would suggest using GlideAjax, as getReference has performance impacts.

Even if you choose to use GetReference, use it with callback function.

var user = g_form.getReference('u_reference_4', getEmail); // doAlert is our callback function } 
function getEmail(user) { //reference is passed into callback as first arguments
 g_form.setValue('u_string_2',user.email);
}

[Aman Kumar S · Accepted solution]

Hi @Phani Pasupulet ,

I would suggest using GlideAjax, as getReference has performance impacts.

Even if you choose to use GetReference, use it with callback function.

var user = g_form.getReference('u_reference_4', getEmail); // doAlert is our callback function } 
function getEmail(user) { //reference is passed into callback as first arguments
 g_form.setValue('u_string_2',user.email);
}

[Ankur Bawiskar · Accepted solution]

@Phani Pasupulet 

Why not add the email field as Dot walked field on form fromt he User Name field and make it readonly?

Then no script is required

[Phani Pasupulet]

I auto populated ph no 
why I am gettting number as above format

even when I updating the abel number it is taking in the same format

[Ankur Bawiskar]

@Phani Pasupulet 

Ph no is of what type? It looks it's string type.

The format comes based on how it's stored in sys_user record