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
