Overview of TrackMaster: Membership Tracking Tool for U-M Centers and Institutes

Summary

TrackMaster is a membership tracking tool for University of Michigan and Michigan Medicine centers and institutes. Built by students in the ITS Summer Internship for the Eisenberg Family Depression Center, it allows centers to better support their members, manage their teams' work, and report on metrics that measure center's progress towards their mission.

Uploaded Image (Thumbnail)

 

Details

Introduction

TrackMaster is a people and metric management tool for U-M centers and departments. It provides:

  • centralized access to information on members, prospective members, vendors, center staff, and other stakeholders.
  • ability to record and track service utilization.
  • referrals to services and membership.
  • reports for key center metrics.
  • tools for collaboration between center staff.

TrackMaster, by democratization of information, will enable teams to:

  • increase understanding of stakeholders.
  • manage relationships more effectively.
  • understand usage of current offerings.
  • identify service or resource gaps.

 

Architecture

TrackMaster primarily utilizes SharePoint Online as a web platform. However, TrackMaster brings together information that is scattered on many other systems throughout the University of Michigan.

  • SharePoint Online. The main interface to the application, containing custom lists, edit forms, and collaboration tools.
  • Power Automate. Used for automating many tasks such as determining center membership based on information from MCommunity groups, performing automated data cleaning tasks, sending bulk emails to members, and performing basic administrative tasks.
  • Tableau. Used for reporting and visualizations, connecting SharePoint data with data from specific Oracle databases such as Michigan Research Experts' Publications Data and eResearch grants and awards data (future).
  • Python / PHP / Power Automate Desktop. Due to tight security restrictions working in a healthcare IT environment, certain scripts and tools hosted externally are needed to automate moving data. For example, a Python script or Power Automate Desktop script can be used for exporting U-M MCommunity group members to files that Power Automate cloud can process inside the Michigan Medicine environment. Alternatively, a PHP script can be used to query MCommunity's API and allow PowerAutomate to access the data through a dynamic RSS feed.
  • MCommunity. Used as the source of truth for group and center memberships.
  • Michigan Medicine Groups. Used for access control when deployed to the Michigan Medicine Office 365 environment. Not needed when deployed to the University of Michigan Office 365 environment.
  • Depression Center Knowledge Base. This knowledge base, which runs on TeamDynamix, is used for documentation.
  • GitHub. Version control for all code and automation scripts.

 

Notes

Recognition

A huge thank you to the ITS Summer Internship teams who created TrackMaster for the Eisenberg Family Depression Center! The project teams include:

ITS Summer Internship 2023 Project Cohort:

ITS Summer Internship 2024 Project Cohort:

 

Resources

 

Print Article

Related Articles (16)

Hiring the Right Technical Support for Studies with Mobile Technologies: Key Questions and Strategies
Hiring the right person for any position can be challenging, but this is especially true for research teams involved in mobile health (mHealth) studies. These projects often require a unique skill set to handle data management and technical hurdles that differ significantly from traditional research support roles. In this article, we explore the necessity of hiring the right technical support person for your research team, and what types of questions you should ask.
How to add a new contact to the people list in TrackMaster
This article describes the steps for adding new contacts to the TrackMaster Membership Tracking Tool on SharePoint.
How to add a new user to TrackMaster
This article describes the steps for adding new users to the TrackMaster Membership Tracking Tool.
How to Add the TrackMaster EFDC Calendar to Outlook
This article describes how to sync a calendar from TrackMaster / SharePoint to Outlook.
How to apply filters to the contacts list in TrackMaster
This article describes the steps for applying filters to the contacts list on the TrackMaster Membership Tracking Tool on SharePoint.
How to create duplicates for articles in the Publicity list by uniqnames
This article describes the steps for duplicating article entries in the publicity list (promotions) in the TrackMaster Membership Tracking Tool on SharePoint.
How to export a filtered list to CSV/Excel
This article describes the steps for exporting a filtered list into a csv format, that can be used by Excel/Google Sheets.
How to join related SharePoint lists that use multi-valued fields when using the SharePoint Lists JDBC connector for Tableau
This article discusses an approach to solve the multi-valued field join problem in SharePoint JDBC using Custom SQL with UNION clauses.
How to post and email a staff announcement in TrackMaster
TrackMaster comes with an Announcements section, which is meant for sharing internal newsletters, reminders, staff meeting notes. This ensures these items are always searchable. This article shows how to post an announcement, and optionally email a copy.
How to send emails to multiple people from the people list
Shows how to send an email to multiple people from a filtered people list using a Power Automate flow.
How to Sync MCommunity Group Members to a SharePoint List
This document presents three different sync approaches between MCommunity and SharePoint Lists that work within the security restrictions of Office 365 and Power Automate, including Microsoft's default Data Loss Prevention (DLP) policy which restricts calling 3rd-party APIs directly.
How to use OData query filters in the SharePoint Get Items action for Power Automate
This article explains the Get Items action in detail, and provides several tips and tricks for filtering data from SharePoint to make Power Automate flows faster by reducing the amount of data being retrieved and leveraging SharePoint's index.
Manually Uploading Contact Lists In Batches
This article describes the steps for uploading new contacts in bulk to the TrackMaster Contact List.
Trackmaster Power Automate flows
Overview of PowerAutomate flows used by the TrackMaster Membership Tracking tool.
All code is available in GitHub at: https://github.com/DepressionCenter/TrackMaster
TrackMaster SharePoint Form Customization
Form Customization - Grouping of related columns under a common title
TrackMaster SharePoint List Customization - Changing the default appearance of the list
List Customization - Changing the default appearance of lists in SharePoint.