- Use the "Standard Touchpoint Universe (NEW)" - unflattened data
- 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
- Form ID= [Touchpoint Unique Identifier], in this case "34"
- 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!