
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2017 04:38 PM
Hello,
I am unable to create a notification on the sys_approval table for my approvals being generated on a non-task table. Therefore I have a trigger on when to send these notifications and I can provide the information from the table they are approving on, but I am unable to give them a link to the approval record only to the table's record.
Has anyone ever been able to create a mail script that will take them to the sys_approval record generated for the custom table?
I hope that's not to confusing.
Thanks,
Stacy
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2017 11:37 AM
I was able to create a notification on the sys_approval table. I created an event registry with my tablename.approval.insert. I used this event as the trigger on my notification. In order to get links in to the item being approved in the email, I had to use document_id.URI as the regular sysapproval.URI would not get to the item being approved.
Thanks for your suggestions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2017 06:00 PM
use email template and add to your notifications.
- create a template on - sysapproval table
message as ${sysapproval}
then add ${mailto:templateName} in your notification.
~Aravinda

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2017 09:08 AM
So the additional problem I am having is because the approval is on a non-task table the even that gets triggered is table_name.approval.inserted. It generates this even based on a business rule for non-task approvals. I can't create an event called table_name.approval.inserted because the system would append my table name to the beginning of that because it is on a non-task table and make it table_name.table_name.approval.inserted.
So now my questions is How do I trigger the approval notification to go out?
Thanks,
Stacy

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2017 11:37 AM
I was able to create a notification on the sys_approval table. I created an event registry with my tablename.approval.insert. I used this event as the trigger on my notification. In order to get links in to the item being approved in the email, I had to use document_id.URI as the regular sysapproval.URI would not get to the item being approved.
Thanks for your suggestions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-24-2018 03:47 AM
Hello Stacy,
Can you please share exactly code you used, I have the same requirement and I can't make it work.
I have created the event registry and made a mailto template with document instead of sysapproval, did you also create an inbound action or something similar?
Thanks in advance