To create a hyperlink in a report to edit a touchpoint response that is a subform, you will need the following objects in your query:
From the Identity Folder
Participant Site Identifier
Subject Unique Identifier
- First Name Detail
- Last Name Detail
From the Flattened TouchPoint Folder of the Subform
Parent Form Response ID_xx
In this example, the subform is called "Pawnee Child (Form ID 1841).
Once you have these objects in the Results Objects, run the query.
You can include any other objects you need, but you will need these objects in the formula used to create the hyperlink to edit the touchpoint response.
Now that you have the objects you need, create a variable using the following formula:
="<a href=\"https://secure.etosoftware.com/SingleForm/PreviewForm.aspx?ReturnPage=%2fModules%2fDashboard%2fFormDashboard.aspx%3fResponseID%"+FormatNumber([Parent Form Response ID_1841];"#")+"%26DashboardFlag%3d2%26FormID%3d1841%26ActorID%3dC"+FormatNumber([Participant Site Identifier];"#") +"%26ClientName%3d"+[Last Name]+"%252c%2b"+[First Name]+"&FormID=1841&DashboardType=F&DashboardFlag=2&ResponseID="+ FormatNumber( [Response ID_1841];"#")+"&SubjectID=" +FormatNumber([Subject Unique Identifier];"#")+"&CLID=" +FormatNumber([Participant Site Identifier];"#") + "&ParentResponseID=" +FormatNumber([Parent Form Response ID_1841];"#") +"&ParentFormID=1840"+"\" target=\"_blank\">"+[Date Taken_1841]+"</a>"
The objects in [brackets] are the objects you pulled into the query. Populate the formula with the objects you're using.
The numbers in BOLD are hardwired into the formula and will need to be updated to reflect the form IDs for the touchpoints you are using.
In the example 1841 is the subform ID (Pawnee Child_1841), while 1840 is the parent form ID (Pawnee Parent NEW_1840). The form ID is seen in the folder named after the touchpoints in the query.
Once you have the variable created, add it to your table. Right click in the cell, select Format Cell. In the General Tab under Display, change the Read content as: from "text" to "hyperlink". The cell will change to a hyperlink and will take you to ETO to edit the touchpoint response.
Your link should look similar to this:
If you want to change the text of the hyperlink to say "Edit" or something else, simply change the [Date Taken] object at the end of the variable to