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

Fredy Voke
Tera Contributor

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

20 REPLIES 20

nayanmule
Tera Guru

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

 

Thanks  for your response Nayanmule, I have already configured a catalog item for this requirement but my client insist the whole process of going through RITM and SCTASK for approval takes too long hence they wanted a custom table, I am currently waiting for them to provide the list of Assignment group so I can commence work on that story, I appreciate your insight.

FredyVoke_0-1765783977476.png

I am yet to add the assignment group field to this form with the list of the assignment users, still waiting on my client to get me those list, do you have an idea on how to go about configuring the "Requested For" and Email field to auto-populate the sys_user and thier email address once they login or selected on this form? I already have that taken care of on the catalog item i configured but I am not familiar with the custom table, Kindly assist.

Hi @Fredy Voke 

 

For requested-For you can use this step:

 

Mohammed8_0-1765784513584.png

 

Go to dictionary in default value:

 

Mohammed8_1-1765784622294.png

 

Regards,

Mohammed Zakir

Thanks Mohammed, I appreciate your help. I have tried the javascript:gs.getUserID(); on the default value earlier but it did pull out the user ID as expected. there was no option for type specification field to add the "User[sys_user]" like you will have it on catalog items. I tried with just the default value but that did not work out for me. Thanks for your assistance, If you have any ways to resolve this, I will appreciate it.