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:
Form ID= [TouchPoint Unique Identifier], in this case "34"
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!