URL Field

[amacqueen]

I've tried posting something similar to this before without getting any answers so I thought I would try one more time.

I'm trying to create a URL field that when exported to Excel would allow me to click the URL and have it open in a new browser window.

I've created my field, made it calculated and in the calculation box I have:-

"https://myinstance.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=" + current.sys_id + "%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true"

This generates a URL like this:-

https://myinstance.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=f0124d160f7b350055b138b362050e...

However when I choose to 'Export the URL' from incident record it generates this:-

https://myinstance.service-now.com/nav_to.do?uri=incident.do?sys_id=f0124d160f7b350055b138b362050e41

Using the URL generated once the record is exported I click on the link all I get is the Service Now home page, scanning through the list it appears that the sys_id is there but just not being picked it up. I have verified that the value for sys_id in the generated URL is the same as the sys_id for the record in question, see above.

The link does work when clicked in Service Now and opens in a new tab, the link generated by 'Copy URL' from Incident record also works when pasted into a browser.

I would welcome any suggestions.

TIA

[Gurpreet07]

The reason may be ... if you are already logged in into service now in a browser and then hitting the link , you are redirecting to right page but if you are not already logged in then after login its not redirecting to the Target URL .

Try to hit some other service now url (https://myinstance.service-now.com/nav_to.do?uri=incident_list.do) into a browser where you are not logged in and check if its redirecting properly or not.

If you are not redirected to proper page after above test then you may need to review login scripts of your instance .Also if you are using SSO for login then you need to verify that its redirecting properly after lo

[amacqueen]

Thanks for responding, we aren't using SSO but I tried your suggestion of logging out and then trying the generated URL and it worked. However that really defeats the object as I wanted to send reports out allowing people direct access to incidents from Excel. The way it's working they would have to sign off every time which won't work for them (

[Anurag Tripathi · Accepted solution]

populate just this much in your URL field

"https://myinstance.service-now.com/incident.do?sys_id=" + current.sys_id

[amacqueen]

Perfect Anurag.

Many thanks