As long as the user is logged into ETO already, and has security to see the participant information and the site they are enrolled in, the following formula will create a link to a participant's dashboard in ETO:
.COM Users:
="https://secure.etosoftware.com/Modules/Dashboard/Participant.aspx?ActorID=C" + FormatNumber([Participant Site Identifier];"0000")
Canadian Users:
="https://secure.etosoftware.ca/Modules/Dashboard/Participant.aspx?ActorID=C" + FormatNumber([Participant Site Identifier];"0000")
Australian Users:
="https://secure.etosoftwareau.com/Modules/Dashboard/Participant.aspx?ActorID=C" + FormatNumber([Participant Site Identifier];"0000")
Public Sector Users (ARMS/Monster)
="https://secure.etosoftwareau.us/Modules/Dashboard/Participant.aspx?ActorID=C" + FormatNumber([Participant Site Identifier];"0000")
- Cut/paste this formula into a cell or create a variable that can be used in other places in the report.
- Right-click onto the field after placing the formula into the report.
- Select Linking.
- Check Read Content as Hyperlink.