How do I trigger an event for sysapproval_approver table from an approval activity in a workflow?

[gjz]

Hi - I need some direction on how to set up a custom approval email from a workflow for one specific workflow.  I've searched the community, but I haven't found a solution that helps me.

Scenario:

I have a specific workflow where I need to send a custom approval email to approvers that will allow them to approve/reject the RITM from the email.

From my search on the community, it appears I need to do the following:

1. Create an event in the Event Registry on the Approval (sysapproval_approver) table, which is used to trigger the email.

2. Create a custom email Notification (on the approval table) that is triggered when the event is fired.

3. Call the event from the Approval - User activity in the workflow.  This is where I'm stuck.

4. Create an Inbound email action to handle the approval email response (although it appears the OOB inbound action will work).

How can I call an event from the Approval - User activity that will run on the Approval table and not the Requested Item table?  From what I've read, using gs.eventQueue() doesn't trigger the event correctly since it gets triggered on sc_req_item and not sysapproval_approver - which is the table I need.

[csimms8]

Hi, You can create a client script that runs "on-load" of a sysapproval_approver record. Add a sys_param to the URI you use to navigate to the sysapproval_approver record. Since the script will run every time a record is loaded, you can use this sys_param in the URI to know that you came from the email to approve or reject. You can then manipulate the record using logic in the script based on what was passed in the URL you used to arrive at the record. This question is old, but I ended up here somehow, so I figured someone may still find this information useful.