Master Salesforce User Report (Hoopla)

Learn how to build the report in Salesforce that keeps your users in synch with Hoopla

By adding users this way, they will login to Hoopla using their Salesforce credentials via Single Sign-On (SSO).
Create a User Report in Salesforce

  1. In the Salesforce Report Builder, create a new report based on the User object.

  2. Ensure the format is set to “Tabular”.

  3. Add criteria that will return the set of users who should be added to Hoopla. Setting the report to Active Users only will automatically add and subtract users from Hoopla as you add/subtract employees or change people's roles in Salesforce.

  4. Only one report can be used to provision users, so make sure it includes the right people!

  5. Add the "Email" field and the "User ID" field as columns in the report; just click and drag each field from the left menu to the report. (You should also have First Name, Last Name, and Username as columns, by default.)

  6. Run the report and save it. Tip: Create a report folder in Salesforce called "Hoopla Reports" to keep things better organized.

Map the Report to Hoopla User Provisioning

  1. Go to the Salesforce Integration area in the Hoopla Admin panel.

  2. Click Select Report under User Provisioning and find the report you built.

  3. Hoopla will automatically check this report once per day. You can choose "Run Now" anytime to synch any changes in the report. (note: it may take a few minutes to complete)

Salesforce Profile Photos 

The first time users synch with Hoopla,  Salesforce profile photos will automatically be applied as the default Hoopla profile photo. Users and Admins can then customize the photo in Hoopla as desired. Any subsequent changes to Salesforce profile photos will not automatically synch over to Hoopla.

More Info
For more help on building Salesforce reports check out these resources from Salesforce:

Video from Salesforce describing how to build reports.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request