Step 1 – Use the "Standard Touchpoint Universe (NEW)" - unflattened data

Step 2 – Bring the following objects in to your Query: [Answer as Attachment Name]; [Question Unique Identifier]; [Response Unique Identifier]; [Subject Identifier]; [TouchPoint Identifier]

In the Query above, we filtered down to the TouchPoint, Question, and Subject Name.


Step 3 – See the Objects Returned.

Step 4 – Create a New Variable.

Step 5 – Create a Variable with the following formula:

For US clients (.com)

="<a href=\"https://secure.etosoftware.com/SingleForm/DownloadAttachment.aspx?ResponseID="+FormatNumber([Response Unique Identifier];"#")+"&FormID="+"34"+"&ElementID="+"11403"+"&SubjectID="+FormatNumber([Subject Identifier];"#")+"&FileName="+URLEncode([Answer as Attachment Name])+"\" target=\"_blank\">View</a>"

For CA clients (.ca)

="<a href=\"https://secure.etosoftware.ca/SingleForm/DownloadAttachment.aspx?ResponseID="+FormatNumber([Response Unique Identifier];"#")+"&FormID="+"34"+"&ElementID="+"11403"+"&SubjectID="+FormatNumber([Subject Identifier];"#")+"&FileName="+URLEncode([Answer as Attachment Name])+"\" target=\"_blank\">View</a>"

For AU clients (au.com)

="<a href=\"https://secure.etosoftwareau.com/SingleForm/DownloadAttachment.aspx?ResponseID="+FormatNumber([Response Unique Identifier];"#")+"&FormID="+"34"+"&ElementID="+"11403"+"&SubjectID="+FormatNumber([Subject Identifier];"#")+"&FileName="+URLEncode([Answer as Attachment Name])+"\" target=\"_blank\">View</a>"

There are two numbers you will need to change:

  1. Form ID= [TouchPoint Unique Identifier], in this case "34"

  2. Element ID= [Question Unique Identifier], in this case "11403"

Step 6 – Your Dimension/Variable will first come in like this:

Step 7 – Right click the Cell and Choose "Format Cell..." .

Step 8 – Choose to read the content as "Hyperlink".

Step 9 – You're all done! 


Did this answer your question?