Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Build a URL based on row data

Hi,

 

I am trying to build a URL with values from the rows within the table, I want to add the Packet_ID into a URL so it can create a ticket in ServiceNow 

https://dev46654.servicenow.com/nav_to.do?uri=%2Fincident_list.do%3Fsysparm_query%3Dsys_class_name%253Dincident%255Eu_packet_ID%253D[Packet_ID]

 

I know the URL works but it just passes the Value [Packet_ID] into the correct field rather than the actual value of the highlighted row.

Thanks

 

Andy

  • Your link does not work for me.

     

    That being said, if you want to build a url link from other pieces in the row you can add a custom column like:

    "https://" & [account] & ".visualstudio.com/_apis/" & [api] & "?property=" & [propValue]

    where account, api, and propValue are your column names. 

2 Replies

  • artemus's avatar
    artemus
    Icon for Microsoft Employee rankMicrosoft Employee

    Your link does not work for me.

     

    That being said, if you want to build a url link from other pieces in the row you can add a custom column like:

    "https://" & [account] & ".visualstudio.com/_apis/" & [api] & "?property=" & [propValue]

    where account, api, and propValue are your column names. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi

       

      This worked I didnt end the string before using the &[myfield]