Create a Task/Survey based on survey response

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2018 01:49 PM
I've a requirement where I need to create a task/case if the customer satisfaction survey result for a question falls a certain threshold.
Any idea where I can start?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-27-2018 02:55 AM
Hi,
You can write a after insert BR on survey instance table (asmt_assessment_instance) with a condition that state is completed i.e. response has been recieved.
Then you can use Gliderecord query on asmt_assessment_instance_question tbale to fetch all varibales and their values based on the reponse. You can apply own logic for threshold in it and finally is its acheived, you can create a task through the same BR itself.
Script will look like this
Please mark it correct/helpful based on the response.
Thanks
Gaurav

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-27-2018 06:09 AM
Thanks Gaurav. I will try this and get back to you/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2019 08:09 AM
Gaurav - Did you ever get this figured out? What was the result?