Discussions
Dynamic Link field - extra characters created
I created a custom concatate formula field to add a name to a dynamic hyperlink as follows:
Custom Field: Customer PS Name Change
Custom Field ID: custentitycustomerpsnamechange
Custom Field Formula: CONCAT(REPLACE({companyname},' ','%20'),'%20Price%20Summary%20History.xls')
Customer: Allegheny College
Customer Field Result in NS: Allegheny%20College%20Price%20Summary%20History.xls
No problem at this point
I then created the hyperlink custom field as follows:
Custom Field: Price Summary History Lookup
Custom Field Hyperlink: http://campus.net/Shared%20Documents/Price%20Summaries%20-%20BEST%20FINAL/{custentitycustomerpsnamechange}
Custom Field Result in NS: http://campus.net/Shared%20Documents/Price%20Summaries%20-%20BEST%20FINAL/Allegheny