How do you create an item that takes a user entered ticket number and concatenate that with a URL to create a hyperlink to the ticket in the ticketing system.

User enters ticket # 123456

URL to ticket system: https://Ticket/Display.html?id=<ticket#>

Best answer would hide this url and allow users to click the 12345 number and open the website to that ticket.

Other options???

I'm just getting back into Sharepoint and this server will be upgraded to SP2019 in the next few months so I need the solution to be simple :) and I need it to survive the upgrades (2010 > 2013 > 2016 > 2019).


You could try calculate column.

enter image description here

Additional steps would need for SharePoint 2016/2019


  • There is a limitation in the calculated column in the SharePoint 2013 onwards after the June 2017 PU update, here is a Microsoft documentation: support.office.com/en-gb/article/… – GSD - SharePoint Apr 3 '20 at 6:14
  • I created a calculated field that resulted in the following: <a target='_blank' href='myapp.mydomain.org/Ticket/Display.html?id=555555'>Show Details</a>. But the entire string is showing instead of just "Show Details" and you can't click it to launch the app. – hswipf Apr 3 '20 at 15:03
  • As per Microsoft above article, this does not work after June 2017 public cu update from sp 2013 version onwards.. yes you are right, I also couldn't render as short text link finally did through workflow – GSD - SharePoint Apr 3 '20 at 15:46
  • I'm currently using SP2010 so it should work shouldn't it? – hswipf Apr 6 '20 at 15:34

Use the SharePoint designer workflow or if you have Nintex workflow. Create a column in the task list name as something open task with hyperlink type. Using workflow after creating the task, update this new column(hyperlink) with the SiteURL +taskid (what user entered).. this will be linking to the task but this link should be displayed just as the number like "1234567" (the task number what you have mentioned), now you can even send this link as an email to the user as a notification.

The above solution could be achieved using the calculated field as well but there is a limitation in that - after the June 2017 Public Update (PU) we cannot add custom HTML in the calculated column for SharePoint 2013 & 2016 version onwards.

Please refer to the below Microsoft article for the calculated field limitation in SharePoint:

Handling HTML markup in SharePoint calculated fields


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.