One Source of Truth
Keep each piece of information in one main place, with clear field names everyone understands.
Objective
By the end of this lesson, you can set up one main sheet as the source of truth for your workflow, with clear field names and a status column.
The problem with copies
When the same list lives in three places, the copies drift apart. A volunteer updates their phone in one sheet. The reminder goes out from another. Now the reminder goes to an old number.
A source of truth is the one place everyone agrees holds the correct, current version of the data. Other tools can read from it. People update it there, and only there.
A local example: a youth mentoring program
A West Side mentoring program had three lists of students: a paper sign-in sheet, a Google Sheet the director kept, and a contact list on a coordinator's phone. Parent phone numbers did not match across them.
They picked the Google Sheet as the source of truth. Sign-ins moved to a form that writes to that sheet. The coordinator's phone list was deleted. One list, one owner, one place to fix mistakes.
Because these are minors, they also limited who could open the sheet. More on that in Module 6.
Name fields clearly
Good field names help the next person, and they help you map fields in your tool.
| Weak name | Clear name | Why |
|---|---|---|
| Phone | parent_phone | Says whose phone it is |
| Date | event_date | Not confused with the date it was received |
| Notes2 | allergy_notes | Says what goes there |
| Done? | status | Holds set values: New, In progress, Done |
Pick one style and stick to it. Lowercase with underscores is easy to read and works well in every tool.
Add a status column
A status column shows where each item is in the process. Use a dropdown with fixed values like New, Waiting on customer, Confirmed, Done, and Needs review.
Status lets you:
- See at a glance what is stuck
- Trigger the next step when status changes
- Count results for your after measurement in Module 7
Write a data dictionary
A data dictionary is a short table that lists every field, what it means, and an example. It sounds formal. It is just a cheat sheet for the next person. Put it on a second tab in the sheet.