Build a URL based on row data

[Anonymous]

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%2...]

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

[artemus · Accepted solution]

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]

Hi

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