I've tried to create an email Notification that triggers when a record is inserted into a Database View, however, it doesn't seem to work. I'm wondering if this is because it's a Database View or whether I'm doing something wrong.
The Database View I'm using is the out of the box 'task_survey_detail'. The condition for my Notification is as follows:
When I navigate to the task_survey_detail_list table and run that condition I get results:
Does anyone have any ideas?
The requirement for me to do this is that Team Leads what to receive an email when a low score is given on our customer satisfaction survey. If there's an alternative way to achieve this I'd be interested to hear it.
