Hello Everyone,
I have developed a custom service with its own table and custom states. The service is submitted through a Record Producer, and upon submission, a sequence of approvals is triggered.
My requirement is the following:
When an approver requests additional information, the request state is changed to "Additional Information Requested". After the Opened By user provides the requested information and the request moves back to "Awaiting Approval", I would like the approver to receive an email notification informing them that the requested information has been provided.
My questions are:
- On which table should the email notification be created? The custom request table or the approval table (sysapproval_approver)?
- What conditions should be used to trigger the notification only when the request transitions from Additional Information Requested back to Awaiting Approval?
I tried creating the notification on the approver table (sysapproval_approver) using the configuration shown in the screenshot below, but the notification was never triggered.
The relevant states in my custom table are:
- Additional Information Requested (custom numeric value)
- Awaiting Approval
Any guidance on the correct notification setup would be appreciated. Thanks!
