Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Quotation Marks around a [Field] when used as a URL/URL+Ticket# opens up Ticketing Tool Search Page

Question Hello All, I am using Power Query Editor to check over the data and add a Custom Column that is going to be Type:WebURL. It will be used to open a Ticketing Tool Search Page and i...
Need Help
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi Anonymous ,

     

    Have you tried the following:

    "company.website/forms/xxxxxxx = " & """" & [ticket_number] & """"

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

 

Have you tried the following:

"company.website/forms/xxxxxxx = " & """" & [ticket_number] & """"

 

Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Pete, first Thank you! I tried many ways to add more and take away the "" marks ... but 

    this was my last try

    & "" &"[ticket_number]"&""