Regarding filling Survey responses from script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 03:55 AM
Hi Experts,
Have a requirement based on email responses , we need to set the survey response.
Attaching the screenshot of the survey response form, this should be auto
filled from email responses from end users.
The below image shows assessment_take2.do in URL, but this is not a table, so let me know if anyone has filled this via script.
When I open any survey instance and click user's response, it should be filled with email responses. I made it work till here but how to fill the survey response kind of stuck.
If in survey email if user selects 0, it should update 0 in satisfaction and whatever comments user types should be updated in comments section.
Regards,
Gayathri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 05:29 AM
Can you share the email they are responding to? How is this information coming in?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 06:05 AM
@Mark Manders Hi Mark,
By clicking on smiley, satisfaction value will be sent and by typing something in comment , it will be received as an email to an servicenow instance.
For that i have written BR on sys_email and updating survey instance but unable to fill survey user response
Attaching the screenshot for your reference
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 06:08 AM
Why a business rule? Why not an inbound email action?
From there, update your assessment_instance (which your survey is), by getting the values from the email and putting them into the form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 08:35 PM
@Mark Manders Hi Mark,
I have used BR can use inbound action as well, but by updating asmt_assessment_instance, its not updating survey response!!!!!
I could update asmt_assessment_instance state to complete but its not filling updating satisfaction and comments as values are stored in url which has assessment_take2.do and that's not table