auto populate email in order guide using first name and last name entered.

[KushagraPratap]

Auto Populate the email id in order guide from the first name(first_name) and last name (last_name), and check sys_user table for a match if found add a number at the back (ex. - abeltuter1@example.com).

Variable set variables - first_name, last_name (data to be picked), email (to populate)

Kindly help with the script.

Thanks

[Samaksh Wani]

Hello @KushagraPratap 

which number you wanna add.

[KushagraPratap]

any it just email should not match any email in sys_user table

[Harish KM]

hello instead of looking for first_name, last_name variables why dont you have a variable referenced to sys_user table which can show list of user data from Servicenow and then populate emailID?

[Samaksh Wani]

@KushagraPratap You should keeep the email reference field there which is referred to sys_user table. Because there can be multiple persons having same first name and last name.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh