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="+FormatNumber([TouchPoint Unique Identifier];"#")+"&ElementID="+FormatNumber([Question Unique Identifier];"#")+"&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="+FormatNumber([TouchPoint Unique Identifier];"#")+"&ElementID="+FormatNumber([Question Unique Identifier];"#")+"&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="+FormatNumber([TouchPoint Unique Identifier];"#")+"&ElementID="+FormatNumber([Question Unique Identifier];"#")+"&SubjectID="+FormatNumber([Subject Identifier];"#")+"&FileName="+URLEncode([Answer as Attachment Name])+"\" target=\"_blank\">View</a>"
The example below shows the formula with a set Form ID and Element ID, which can be helpful when showing data for only one set touchpoint. The example formulas above will adjust this to whatever data is brought into the report so it can be used for several touchpoints in the same table.
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!
Tips and Tricks
Want to show the attachment name as the hyperlinked text? Use the formula below:
="<a href=\"https://secure.etosoftware.com/SingleForm/DownloadAttachment.aspx?ResponseID="+FormatNumber([Response Unique Identifier];"#")+"&FormID="+FormatNumber([TouchPoint Unique Identifier];"#")+"&ElementID="+FormatNumber([Question Unique Identifier];"#")+"&SubjectID="+FormatNumber([Subject Identifier];"#")+"&FileName="+URLEncode([Answer as Attachment Name])+"\" target=\"_blank\">"+ [Answer as Attachment Name]+ "</a>"