Catalog item fields should autoPopulate by email Link.

[Anjaneyulu1]

Hii everyone,

1. Create a Notification and trigger daily Via scheduled job. Condition: If User’s Manager is Inactive send Notification to manager’s Manager.

2. Create a Catalog form. Make 3 fields (Inactive manager- Reference type)(New Manager-Reference type)(Impacted user’s-List collector).

3. If Inactive manager is blank show all active user’s in Impacted user’s field else only show the reportees of Inactive Manager.
4. Provide a link in notification. If recipient clicks on the link populate the Inactive manager field and their reportees.

-->I have Completed 1st ,2nd & 3rd points.

Please help me on 4th point .

I have written Email Script :

Preview Notification looks like this :- In notification Body

Hi manager.managers.user_name

If Manager clicks on the Link it should open catalog item form and autopopulate fields Inactive manager & impacted users in service portal.

please help me How to acheive it this.

[chidanandadhath]

Please check below link

https://community.servicenow.com/community?id=community_blog&sys_id=596dea29dbd0dbc01dcaf3231f96190b

[Anjaneyulu1]

Hi Chidanandadhathri,

Im fresher & im new to servicenow.

I have written scheduled job:-

var user = new GlideRecord('sys_user');
user.addEncodedQuery('manager.active=false');
user.query();
while (user.next()) {
//gs.log('inactive managers : ' + user.getRowCount());
gs.eventQueue('melco',user,'','');
}

If you don't mind,

can you write onload client script i'm unable to understand above link what you have provided to me.

please help me to sort it out.

[chrisperry · Accepted solution]

Hi Anji,

Please refer to your other thread where I provided this solution: https://community.servicenow.com/community?id=community_question&sys_id=c3146fcfdb124d10dd886c8e13961960

If this answer is helpful please mark correct and helpful!

Regards,

Christopher Perry