GI Tracker
The easiest way to keep track of GI-related conditions.
Free symptom tracking template using Google Forms and Google Sheets for GI-related conditions such as Crohn’s Disease.
What is the GI Tracker?
Wingspan Health and DocSchmidt, our medical advisor, created the GI Tracker to help you keep track of your bowel movements. The GI Tracker is simple, customizable, and does not require any apps. It uses Google Sheets combined with Google Forms – it’s an accessible and readable tracker that anyone can use!
Features:
Entries: Takes information from a Google Form and shows all of your entries about your bowel movements. You can install the Google Form on your phone’s home screen or desktop for easy access and input.
Dashboard: Monthly dashboard with graphs (with the ability to filter) and calculations showing your number of bowel movements at different times of the day based on dates, symptoms, and the impact on your day.
Notes: Displays all relevant notes entries (based on filter selection).
Filters: Track your bowel movements with customizable filters.
How to Get the GI Tracker
How to Add the GI Tracker to Your Google Drive:
Make a copy of the GI Tracker Template Google Sheet to your Google Drive account (NOT THE FORM!). A form will be automatically generated in your Google Drive that will be linked to your GI Tracker.
Wish this were an app? You can follow the next few steps to add a shortcut to your phone (Android + iOS). You’ll get an icon on your home screen, just like an app - but the icon will launch the form in a web browser. This step is optional if you’d rather enter your symptoms from the computer or browser directly.
Visual: how to make a copy of the GI Tracker to your Google Drive.
How to Download the GI Tracker on Android:
Download the Google Drive App and then open the app.
Open your GI Tracker Google Form in your browser. It will be the 'editable version' where you can't input data.
Select the 3 dots in the top right corner and select 'Preview' - it will open a new tab with the form where you can input data.
Select the 3 dots in the top right corner again and select 'Add to Home Screen.'
How to Download the GI Tracker on iPhone (iOS):
Check out the following TikTok to visually see how you can get the GI Tracker on your iPhone step-by-step.
Download the Google Drive App and then open the app.
Open the GI Tracker Google Form and copy the link of the form in your Safari app browser. It will be the 'editable version' where you can't input data. (NOTE: Make sure you are signed in on your Google account on Safari. You must be on Safari and not another web browser like Google Chrome.)
Select 3 dots in the top right corner and select 'Preview' - it will open a new tab with the form where you can input data.
Copy the link and paste it into a new tab on Safari.
Select the share button and then select the 'Add to Home Screen' button.
How to Use the GI Tracker
Below is a step-by-step guide to making the most use of the symptom tracker template for Google Forms / Sheets.
Make Entries
Fill out that newly created Google Form (Titled: Copy of GI Tracker Template) wherever you saved the copy in your Google Drive every time you want to make an entry about your bowel movements.
Visual: filling out the Google Form for Entries in the GI Tracker.
Discover Insights
Check out the Dashboard tab in the Google Sheet for data points and graphs about your bowel movements. You can play around with the filters such as dates, symptoms, and the impact on your day to gather insights about your bowel movements through the dropdowns in the tan-colored cells. Then scroll right on the Dashboard sheet to see dynamic graphs and data lists.
Visual: seeing dynamic graphs and data lists in the Dashboard section of the GI Tracker.
Review Notes
Hop over to the Notes sheet after setting the filters in the Dashboard tab where you can review your notes based on those criteria.
Visual: how to access the Notes section in the GI Tracker.
Go to Your GI Doctor’s Appointment Prepared
Check out this video by Wingspan Health’s medical advisor, DocSchmidt (a GI specialist), to get a heads up on what to expect at a GI doctor’s appointment.