1. Use the "Standard Touchpoint Universe (NEW)" - unflattened data
  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.

3. See the Objects Returned.

4.  Create a New Variable.

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"

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

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

8. Choose to read the content as "Hyperlink"

9. You're all done! 

Did this answer your question?