to add field in email notification body from other table

[sureshpcse]

Hi Community,

need help on email notification, to add field in the current email body from other table.

[Hayo Lubbers]

If it is a parent/referenced table, you can dotwalk, if it is from another table or child records and you know where to retrieve this data, you can use a mailscript to retrieve and format the data as you wish.

More information on mail scripts : https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/script/server-scripting...

Regards,

Hayo

[Satishkumar B]

Hi @sureshpcse 

check this solution:

https://www.servicenow.com/community/itsm-forum/pulling-a-field-through-from-another-table-into-a-no...

……………………………………………………………………………………………………

Please Mark it helpful 👍and Accept Solution!✔️! If this helps you!!

[Robbie]

Hi @sureshpcse,

Check out the below link on Notification Email Scripts. These are essentially where you are able to query the data and perform GlideRecord lookups etc and pass these back to the notification.

This is best practice. https://developer.servicenow.com/dev.do#!/learn/learning-plans/washingtondc/servicenow_administrator...

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.

Thanks, Robbie