Display hyperlink in the mail html body that fetches a particular record from a table

[Hemamani Prabha]

Hello all,

I need to display a hyperlink in the email notification body and by clicking that link it should navigate to that particular record from the particular table.

There are ${sysapproval.u_job_role} users on the role ${mail_script:sc_req_item_options_job_role}, please consider this before approving.

In the above,  I need to modify text so it hyperlinks(highlighted in blue) to the exact permission that is asking for the access. It should take me to the particular record on clicking it. How can I achieve this?

Thanks in advance,

Hema

[Omkar Kumbhar]

HI @Hemamani Prabha ,

How are you triggering the notification if you are using the event, Please pass the sys_id through event as parameter.

once you pass it you can call it in email script e.g  var sys_id  = event.parm1

and then in the link you can use it 

var link = '<a href="table_name.do?sys_id=' + sys_id  + '" >Please click to approve the record</a>';

[Hemamani Prabha]

Thanks @Omkar Kumbhar for your help!