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:
="<a href=\"https://secure.etosoftware.com/Modules/Dashboard/Participant.aspx?ActorID=C" + FormatNumber([Participant Site Identifier];"0000") + "\" target=\"_blank\">Participant Dashboard</a>"

Canadian Users:

="<a href=\"https://secure.etosoftware.ca/Modules/Dashboard/Participant.aspx?ActorID=C" + FormatNumber([Participant Site Identifier];"0000") + "\" target=\"_blank\">Participant Dashboard</a>"

Australian Users:

="<a href=\"https://secure.etosoftwareau.com/Modules/Dashboard/Participant.aspx?ActorID=C" + FormatNumber([Participant Site Identifier];"0000") + "\" target=\"_blank\">Participant Dashboard</a>"

Public Sector Users (ARMS/Monster)
="<a href=\"https://secure.etosoftwareau.us/Modules/Dashboard/Participant.aspx?ActorID=C" + FormatNumber([Participant Site Identifier];"0000") + "\" target=\"_blank\">Participant Dashboard</a>"

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 – Click into the column the formula/variable is located to bring up the Report Element Formatting panel to the right.

Step 3 – Under the Appearance section expand the Display option if it is collapsed.

Step 4 – In the "Read content as" dropdown, select Hyperlink.

Did this answer your question?