How to Trigger Notifications when Form runs a Stored Procedure?

Eric Allen

I'm familiar with notifications for IDO events like IdoOnItemInsert, IdoOnItemUpdate, etc. Unfortunately, even though a form may ultimately insert a record into an IDO, if the form uses a stored procedure to do so, the notifications don't trigger. In a post from 2022, it seemed this was a deficiency in the notification system.

I'm currently trying to trigger a notification (email) when a new item is added. Since a large number of our items are added via the "Copy Items" form this doesn't work. Looking at the form, it runs the SLItems.ItemCopyDataSp procedure. Any advice?

nfelicioni

I have you considered using the Framework event IdoPostInvoke? You can then check if the IDO Method ItemCopyDataSp was ran and send emails accordingly.