send one email once one of the request assessment questionary is filled and submitted and the answer

[Debasis Pati]

send one email once one of the request assessment questionary is filled and submitted and the answer

i have a risk assessment questionay impacting x if it is yes then i have to send one email to group.

for this i have created one br in asmt_metric_result table and triggering one event and from event notification.
My question is my email is on change_request. tbale now if i put number and all directly on the subject will it be in the below manner

${number} details .

@Ankur Bawiskar  can you guide how i can have the number and other details as i do not have the details now/or i have to call a email script again and then set the body and subject from there only?

as the email is triggered when event is fired.

[Ankur Bawiskar]

@Debasis Pati 

notification is on which table and data is to be fetched from which table?

if both are different then you need to use email script to print the data.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Debasis Pati]

Hello @Ankur Bawiskar ,
I was able to do it using event and email script.