User name is in a string field. How to get email of that user?

shweta14
Tera Contributor

I want to send notification to user but user is in a string field how to get email of that user

1 ACCEPTED SOLUTION

Ok, Got it..

Follow the steps below... It works...tested..

Step 1: Create a event registry record like below.

1.) In navigator, type this "sysevent_register.LIST" and click on new and fill the below details.

find_real_file.png

 

Step 2 : Create after insert/update business rule

find_real_file.png

 

In advance write the below script

(function executeRule(current, previous /*null when async*/ ) {
    getUsername = current.write_serviceowner_fieldname;
    var gr = new GlideRecord('sys_user');
    gr.addQuery('user_name', getUsername);
    gr.query();
    if (gr.next()) {
        gs.eventQueue('notify.event', gr, gr.email);
    }
})(current, previous);

 

Step 3: Create notification like below.

find_real_file.png

find_real_file.png

I hope it helps, if so please mark my response as helpful and correct.

 

View solution in original post

12 REPLIES 12

not working

find_real_file.png

Hi,

Use gs.log("test " +getUsername); 

and check what is coming under this..

@Shweta and can you please create a new question for this, I can follow up over there..