Skip to main content

Welcome to a Grasp lesson

Create a free account to keep studying and create your own study path.

Lesson 28

Building a Changelog System

Recommended resources

Hello! Welcome back to our final module, "Advanced System Documentation & Handover."

In our last two lessons, we focused on creating robust documentation for your client systems. We started with the System Owner's Manual (SOM) to document the system's "happy path," and then designed troubleshooting decision trees to handle the inevitable "unhappy paths." However, a system is not a static artifact; it evolves. Documentation that isn't updated is documentation that will eventually be ignored.

This lesson bridges that gap. Our focus is on the learning outcome: to build a change log system to track system evolution and communicate updates to stakeholders.

A change log is more than just a list of edits. For a consultant, it's a critical tool for governance, communication, and demonstrating ongoing value. It provides a transparent, historical record of a system's journey, which is invaluable for both you and your client.

1. The Strategy: Why and What to Log

Before we design the database, let's establish the strategic purpose of a change log. It's not just for developers tracking software bugs; in a business system context, it serves several key functions:

  • Communication: It keeps stakeholders (from leadership to end-users) informed about what's new, what's fixed, and what's changed in a way that is relevant to them.
  • Historical Record: It provides a single source of truth for the system's history. This is crucial for debugging, understanding why certain decisions were made, and planning future improvements.
  • Governance: It establishes a formal process for implementing changes, moving you from making ad-hoc adjustments to managing a structured system evolution.

So, what makes a good change log? While our context is Notion systems, we can borrow proven principles from the world of IT and software release management.

Best 10 Release Tracking Templates for IT Managers

The article 'Best 10 Release Tracking Templates for IT Managers' from Notion's template gallery offers a high-level strategic overview of what an effective tracking system should and should not include. We can adapt these principles directly to our Notion change log.

Please read the two short sections: 'What Should Release Tracking Templates Include?' and 'What Should Release Tracking Templates Avoid?'. Focus on the core concepts, which we will translate into our Notion context.

Let's translate the key ideas from that article into a strategic framework for our Notion change log:

  • Version Control: This is about giving changes a unique identifier. It could be a sequential version number (v1.1, v1.2), a date-based ID (2024-Q3-01), or a simple unique name. The goal is to have an unambiguous reference for each change.
  • Release Schedule (or Change Timeline): For our purposes, this means tracking who made the change and when it went live.
  • Stakeholder Information: This involves identifying who is affected by the change and ensuring they are notified.
  • Risk Management (or Rationale & Impact): This is the most critical part. A change log entry must explain why a change was made, what benefits it brings, and what potential impact it might have on users or other parts of the system.

When planning a significant change, it's helpful to use a structured framework to think through the rationale and impact. The "Change Management Plan Canvas" provides an excellent set of prompts for this.

Notion Change Management Plan Canvas Template
This canvas is a strategic tool for thinking through a change. Before creating a log entry for a major update, you can use these questions ('What is changing?', 'Why is this change happening?') to formulate the detailed rationale that will go into your change log.

2. The Architecture: Building the Change Log in Notion

Now let's design the actual system in Notion. A scalable change log is built around a dedicated database. Its structure should be simple enough to be easily maintained but detailed enough to be useful.

Here is an example of what a clean, effective change log can look like in Notion.

Notion Changelog Database Example
This image shows a simple yet powerful change log database. Note the clear, scannable entries and the use of properties like 'version', 'tags', and 'Date' to structure the information.

Based on this example and the strategic principles we've discussed, here is a recommended database architecture for your change log system.

The Change Log Database

Create a new database with the following properties:

Property Name Property Type Purpose
Change Title A short, descriptive name for the change (e.g., "Optimized Project Dashboard Loading").
Version/ID Text or Number A unique identifier for the change (e.g., v2.1.3 or 2024-09-15).
Date Implemented Date The date the change went live for users.
Type Select The category of change. Options: New Feature, Improvement, Bug Fix, Structural Change, Performance Optimization.
Status Status The current state of the change. Stages: Planned -> In Progress -> Live.
Changed By Person The team member responsible for implementing the change.
Affected System Relation A relation to your master 'Systems' or 'Modules' database. This lets you link a change to the 'CRM', 'PM System', etc.
Impact for Users Select A simple assessment of the change's impact. Options: High (new workflow), Medium (UI change), Low (backend fix).
Notified? Checkbox A simple way to track if communication has been sent out for this change.

The Page Content: A Template for Clarity

The properties provide the metadata, but the real value lies within the page for each entry. You should create a database template for your change log to ensure every entry is consistent and comprehensive.

Change Log Entry Template:



📝 Summary

A brief, one-sentence description of what was changed.


🎯 Rationale

Explain why this change was necessary. What problem does it solve? What opportunity does it create? Reference any relevant troubleshooting tickets or client requests.


📈 Impact & User Actions

Describe how this change will affect users. Are there new features to use? Will things look different? Is there any action they need to take (e.g., update a bookmark, learn a new property)?


Test your understanding!

You have just optimized the "Project Progress" rollup in a client's Project Management system to fix a major performance issue. The fix involved adding a new checkbox property called "Task Complete?" to the Tasks database, which the rollup now uses instead of a complex formula.

How would you create an entry for this in your new Change Log database? Describe the key properties you would set and outline the content for the page body using the template.

Show answer

Here is how a well-documented entry would look:

  • Properties:

    • Change: Optimized Project Progress Rollup
    • Version/ID: v1.3.1 (example)
    • Date Implemented: Today's Date
    • Type: Performance Optimization
    • Status: Live
    • Affected System: Link to the Project Management System page.
    • Impact for Users: Medium
  • Page Content (based on the template):

    📝 Summary

    The "Project Progress" rollup in the Projects database has been reconfigured to improve performance and fix slow loading times on the main dashboard.

    🎯 Rationale

    The previous rollup relied on a complex formula that caused significant loading delays, especially on projects with over 50 tasks. This optimization was implemented to resolve this performance bottleneck and improve the user experience.

    📈 Impact & User Actions

    The "Project Progress" bar will now update much faster. To support this, a new checkbox property named "Task Complete?" has been added to the Tasks database. This checkbox is now the source of truth for task completion. Please ensure you and your team use this new checkbox to mark tasks as done.


3. The Process: Communicating Changes to Stakeholders

A change log is only effective if the information reaches the right people. Your Notion system should be designed to facilitate this communication.

Use your change log database to create different views tailored to specific audiences:

  • All Changes View: A master log, typically a table, showing all information. This is for you and the System Owner.
  • Leadership Summary View: A board or timeline view grouped by Type or Impact. Filter to show only New Feature and Structural Change types. This gives executives a high-level overview of progress.
  • "What's New?" End-User View: A gallery or list view showing only Live changes, with a user-friendly title and a simple summary. This view should be embedded directly on the main team dashboard or wiki homepage.

By creating these views, you transform a simple log into a dynamic communication platform, ensuring that all stakeholders are informed in a way that is relevant and respectful of their time.


Conclusion

You have now designed a complete change log system. This isn't just another database; it's a cornerstone of professional system management. It provides transparency, creates a historical asset, and establishes a clear process for system evolution. It's a deliverable that signals to your clients that you are not just building a tool, but managing a living business system.

Key Takeaways:

  • Strategy First: A change log is a tool for communication and governance, not just a technical list. Define what to track and why.
  • Architecture Matters: Use a dedicated, well-structured Notion database with properties that allow for easy filtering and reporting.
  • Templates Enforce Consistency: Use a database template to ensure every change is documented with a clear summary, rationale, and impact analysis.
  • Communicate Through Views: Create tailored views of your change log for different stakeholders to make the information accessible and relevant.

In our next and final lesson, we will focus on the ultimate goal of a system handover: client empowerment. You will learn how to create Train-the-Trainer guides to empower client-side champions to onboard and support their own teams, ensuring the systems you build thrive long after your direct involvement ends.