- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2024 08:18 AM
Hi All
I am creating a link to approve/reject a request. In my email script I have written below script. When user click on the link it should redirect the user to sysapproval_approver table to that record.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 08:48 AM
Hi All
Thank you for all your answer. Really appreciated. Finally I am able to fix the issue. Below is the script.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 12:42 AM
Hi @Prasnajeet1 ,
Can you check the table on which you have write the email script?
Kindly confirm your script is on Approval [sysapproval_approver] table.
Mark helpful if assists.
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 12:42 AM
my notification and email template is written on sc_req_item.
i guess this is the problem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 12:43 AM - edited 02-12-2024 12:54 AM
Yes..
Kindly try using the table I mentioned. (ie. sysapproval_approver)
Please mark this as helpful if this resolves your query.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 12:44 AM
@Prasnajeet1 YES!
I thought you have written it on Approval table, that is the reason you're not getting current.sysapproval.number.
Please mark this as helpful if this resolves your query.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2024 11:06 PM - edited 02-11-2024 11:11 PM
Hi @Prasnajeet1 ,
Use below script
var instanceURL = gs.getProperty('glide.servlet.uri');
var myURL = '<a href="' + instanceURL + '/nav_to.do?uri='+ sysapproval_approver+'.do?sys_id=' + current.sys_id + '">Click here to Approve/Reject ' + current.sysapproval.number + '</a>';
template.print(myURL);
Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand