Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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..