Creating a Custom Table and configure an email Notification to trigger to an Assignment Group

[Fredy Voke]

is it possible to create a custom table and configure an email notification to trigger to assignment group once any request is been submitted from the custom table, the client does not want any RITM or Task to this custom table.

I need to configure email notification field to automatically populate the email address of the Requested For user to this request, I created the custom table and also created a record producer with the same field names but still trying to figure out how to configure the requested for and email field.

Thanks

[nayanmule · Accepted solution]

Hi @Fredy Voke ,

Yes, you can definitely achieve this. If you have already created a custom table and mapped it to a record producer then here's a simple way to achieve the notification.

Create a Standalone notification- 

1. Go to the System Notications table and create a new notification.

2. Once you click on create new notification , select the custom table that you have created and add the trigger condition like on insert , active is true something ..

3. In the 'Who will receive' tab click on the Users/Groups in the fields andd select the requested for .

4. In "What it will contain" , add the subject and body of your wish . You can also add the fields from the table in the body of your email.

Click Submit and test your notification in the email logs.

If my response was helpful to you , please mark it as helpful and accept the solution.

Regards,

Nayan

[Ankur Bawiskar]

@Fredy Voke 

why are you not using standard service catalog request and use the OOTB REQ and RITM tables?

why to use custom table and record producer for this?

I don't think your requirement is valid

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

[Fredy Voke]

I already configured a catalog item for it but my client requested a custom table, they do not want to deal with RITM and SCTASK approval process - they want it quick, thanks

[Mohammed8]

@Fredy Voke 

Yes,

You can create a custom table and use and to insert records directly into it, then configure an email notification on that custom table to trigger when a record is inserted and send the email to the assignment group. The variables be mapped to the custom table fields. To automatically populate the email field, use a Before Insert business Rule on the custom table to copy the email address from the Requested For (sys_user) record and then go to email notification and set conditions email notification for this custom table. Basically what  you need to do is replicate and see how OOTB REQ and RITM table works, and configure/customize as per your requirements

So short answer Yes you cn do it.

Regards,

Mohammed Zakir

[nayanmule]

@Fredy Voke  , were you able to achieve it ? Please let me know if you are facing any more challenges. 

Kindly accept the solution if it has helped you.

Regards,

Nayan