Flow Design action: Generate Link to Table Record

Winnie P
Mega Sage

Hello there.  Short story - I have a request to insert a record link into generated Tasks if the RITM has attachment/s. I am trying to use Flow with this action 'Generate Link to Table Record' and add a work note update to the Task - Is this possible? I have used the above action in my Flow, however it does not create the record number / link, it spits out the code instead ie:

Results:

find_real_file.png

Expected results - I was hoping for something like this:find_real_file.png

This is my Flow:

find_real_file.png

tableName = 2-Look up Record > Requested Item Table
recordSysID = 2-Look up Record > Requested Item record > SysID
linkDisplayName = 2-Look up Record > Requested Item record > Number

find_real_file.png

3-Generate Link to Table record > link

Thank you.

 

1 ACCEPTED SOLUTION

Hi @Winnie Poelima

use this script and place inside f(x) inline script for work notes field

var sysId = fd_data.trigger.current.sys_id;

var rec = new GlideRecord('sc_task');
rec.get(sysId);

var text = "Note 1: There is an attachment/s in the RITM. Scroll down to RITM Attachments related tab to view the attachment.<br/>";

var url = "Note 2: Click the following to view the RITM record and it's attachments " + '<a href="' + gs.getProperty('glide.servlet.uri') + '/nav_to.do?uri=' + 'sc_req_item' + '.do?sys_id=' + rec.request_item + '">' + rec.request_item.getDisplayValue() + '</a>';

return '[code]' + text + url + ['/code'];

find_real_file.png

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

16 REPLIES 16

Thank you Ankur. I copied and pasted your suggested script but the work note still does not show the RITM number as a link:

find_real_file.png

Results in worknotes:

find_real_file.png

RRegards,

Hi,

it should work fine since you are using [code] tag

can you simply try this and verify if link comes

return '[code]' + '<a href="https://www.google.com">Visit Google</a>' + '[/code]';

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thank you for your time Ankur.  Appreciate it. I replaced the script with your above & results are below:  

find_real_file.png

However, I did some further readings and your initial script does actually work, but the issue is our side where this system property: glide.ui.security.allow_codetag - is set to False.  Switching the value to 'True' gave me the link - but will probably need another way as this is set to 'False' for security reasons (I guess):

find_real_file.png

Regards. Winnie.

@Ankur Bawiskar 

When I use this code in the 'Send Email' action of Flow Designer it gives an error while activating the flow.

Error: attempting to use undefined input = 'current' from DRP request

 

Note: I do not have the 'Generate Link to Table Record' action available.

 

How can I add the link to REQ or RITM in this case in the 'Sent Email' action of Flow Designer?

Hi Sir,

 

I have used code which you suggested.. I'm doing integration from servicenow to ado..I want a current record clickable link in ado worknotes.. the code is working but in output it is showing code tags.. how to avoid this?