Need to send notification whenever the record producer record is submitted

[Madhava Raju]

Hi Team,

Whenever the record producer is submitted need to send notificaton to VM SUPORT TEAM.

I have two record producer create dbms and database governance review forms. These two are mapped internally.
1. After submitting the create dbms form the second page (i.e database governance review) is opened automatically and submitting the database governance review form i need to send a notification to this VM SUPORT TEAM.

2. The database governance review is used mainly to create id for this form.

Please help me how to give the conditions and how to send notification.

Thanks in Advance.

[Ankur Bawiskar]

@Madhava Raju 

You can use event based notification and determine if the record got submitted as part of record producer.

if yes then only trigger the event

this table will tell you if record got submitted via record producer or not -> sc_item_produced_record

Query this table with current record sysId and if record found then use gs.eventQueue() to trigger event and subsequently the email

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Madhava Raju]

Hi Ankur,

Thanks for replying me

Which table do i need to query and which scripts do i need to write and give the condition.
How to write email scripts is their any link please forward me.

I am new to servicenow please help me

Thanks,
Madhav

[Ankur Bawiskar]

@Madhava Raju 

you need to use after insert BR on that table and event and notification on that table

which table to query -> I already told above -> sc_item_produced_record

you can check docs for email script etc

If my response helped please mark it correct and close the thread so that it benefits future readers.