I want to add RITM details to Survey Notification on the sc_request table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023 05:31 AM
I have created an assessment/survey based on the sc_request table and want to include a list of the RITM's from the request on the survey notification, i.e.
Please provide some feedback by completing a survey for your recent request REQ00012345
Requested Items:
RITM0000001 - Laptop
RITM0000002 - Keyboard
RITM0000003 - Mouse
Etc
I've tried the OOTB mail scripts relating to surveys and requests but none yet done the trick. Any help appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023 07:03 AM
Thanks again, replaced sys_id with task_id which is the reference field name in the assessment table that relates back to REQ and now working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023 07:08 AM
Great!
Keep in mind that field is probably referencing Task, not specifically REQ or whatever. As long as your Assessment applies to those only though, you should be good to go.