I have created a Geoform on ArcGIS Online based on a feature service from data stored in a versioned SQL database. Ideally, I would like to have an email sent when the user clicks on the "Submit" button, with or without the geoform details. There seems to be many requests online for this functionality but it is not implemented yet. (Side question...any plans for this to be implemented). So, in the meantime, I'm trying to find a work around that does not involve the GeoEvent Processor extension. I have tried to create a Trigger on the SQL database but the sp_send_dbmail procedure seems to only work on the msdb system database, not user defined databases. I also tried to enable Editor Tracking on the feature class in the GIS but I don't see a way to automatically send an email when a new record is added/inserted.
Am I completely overlooking something? Any other options out there that do not involve GeoEvent Processor or hosting the geoform app locally? Thanks for any suggestions.