Forum Discussion
wkeicher
7 years agoHelper III
Hyperlink
Trying to add a column in Query editor as a hyperlink that considers the value in another column. The Url is static with the exception of the field I want to add. The purpose is to generate this column and also apply a short URL to a visual Table.
https://servicesportal.domain.com/Ticket_InsertEdit.aspx?Id=[TicketNo]
1 Reply
- AnonymousNot applicable
Link = CONCATE("https://servicesportal.domain.com/Ticket_InsertEdit.aspx?Id=", "[TicketNo]")
After running the formula make sure to change the column data category to web URL.