All Collections
Help Articles
Reporting in ETO
Functions and Formulas
ETO Results | Formula: Hyperlink to TouchPoint Attachment Upload
ETO Results | Formula: Hyperlink to TouchPoint Attachment Upload

Make a link to a document that was uploaded to a TouchPoint response in ETO Results. #results

Updated over a week ago

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>"

Did this answer your question?