As long as the User is logged into ETO already and has security to see the Participant information and the Site that 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")
Step 1 – Cut/paste this Formula into a cell or create a Variable that can be used in other places in the report.
Step 2 – Right-click onto the field after placing the Formula into the report.
Step 3 – Select "Linking".
Step 4 – Check "Read Content as Hyperlink".
