You have the option of configuring Hoopla to sync Team Membership information for each user who appears in the Hoopla Mapped sheet tab in your Excel Sheet. In a separate sheet tab, you can use that Team Membership information to calculate Team Metric values based on Player values that you already have in Hoopla. Once you have Team Metric values, you can map them back into Hoopla and use them on Leaderboards!
How to Enable Team Membership Syncing
- In Configuration, click on the Excel Online tile and either add a new Excel Online mapping or edit your existing one.
- Under the Hoopla → Excel mappings section, there is a link to "Show team membership syncing". Click the link to reveal the setting.
- Toggle the switch to "ON" if you want to start syncing team membership to your spreadsheet.
- Click OK and Save.
How Team Membership Syncing Works
Each time Hoopla syncs with your Excel Sheet, each user’s Team Membership will update along with any updated Metric values that you’re syncing to the Hoopla Mapped sheet tab. The column called “Team Membership” will always show the list of current Teams that the user belongs to. The Team names are separated by the “|” character so that you can reliably calculate Team Metric values on other sheet tabs within your spreadsheet.