The first step in this template is scheduling a Gemba walk. Each walk is assigned to a certain station and has a certain objective. For example: you want to check safety at an assembly line.

Once a walk is scheduled, it is open to add observations. An observation is something noticed during a walk that needs improvement. Those observations can be captured through the application or through the from view of the Observations table - which is also used by the application.

A second application is designed to follow-up observations by assigning new actions to it or do follow-up on actions that were previously assigned to an observation. it is of course also possible to do this follow-up through the database.

Database: GEMBA

Employees

Fields

• Name (Text)

• Email (Email)

• Phone (Phone number)

• Picture (File)

• Job role (Text)

• Stations (Link to table)

• Walks (Link to table)

• Walks - Required attendees (Link to table)

• Observation - Reporter (Link to table)

• Observation - Assignee (Link to table)

• Actions (Link to table)

• Password (Password)

• Scheduled walks (Formula)

• Count scheduled walks (Formula)

• Open reported observations (Formula)

• Count open reported observations (Formula)

• Open assigned observations (Formula)

• Count open assigned observations (Formula)

Views

• All employees (grid)

• Employees that are station manager (grid)

• Employees with scheduled walks (grid)

• Employees with open reported observations (grid)

• Employees with open assigned observations (grid)

• Gallery: all employees (gallery)

Pillars

Fields

• Name (Text)

• Description (Long text)

• Symbol (Text)

• Order (Number)

• Walks (Link to table)

• Observations (Link to table)

• Scheduled walks (Formula)

• Count scheduled walks (Formula)

• Open observations (Formula)

• Count open observations (Formula)

Views

• All pillars (grid)

• Pillars with scheduled walks (grid)

• Pillars with open observations (grid)

Stations

Fields

• Name (Text)

• Location (Text)

• QR Code (Formula)

• Manager (Link to table)

• Manager Email (Rollup)

• Walks (Link to table)

• Walk status (Lookup)

• Last walk date (Rollup)

Views

• All stations (grid)

• Stations with scheduled walks (grid)

• Stations without scheduled walks (grid)

• All stations grouped by manager (grid)

Walks

Fields

• Title (Text)

• Date & Time (Date)

• Conducted By (Link to table)

• Required attendees (Link to table)

• Notes (Text)

• Status (Single select)

• Station (Link to table)

• Objective (Link to table)

• Observations (Link to table)

• Status icon (Formula)

• Date & Time (format) (Formula)

Views

• All walks (grid)

• All walks grouped by station (grid)

• All walks grouped by initiator (grid)

• All walks grouped by objective (grid)

• Incomplete walks (grid)

• All walks stacked by status (kanban)

Observations

Fields

• Name (Formula)

• Title (Text)

• Description (Long text)

• Images (File)

• Reporter (Link to table)

• Assignee (Link to table)

• Status (Single select)

• Priority (Single select)

• Walk (Link to table)

• Pillar (Link to table)

• Actions (Link to table)

• Pillar icon (Rollup)

• Status icon (Formula)

• Walk details (Formula)

• Created on (Created on)

Views

• All observations (grid)

• All observations grouped by walk (grid)

• All observations grouped by reporter (grid)

• All observations grouped by assignee (grid)

• All observations grouped by pillar (grid)

• Observations that are not solved yet (grid)

• Observations with high priority that are not solved yet (grid)

• Add new observation (form)

• Observations stacked by status (kanban)

• Observations stacked by status 2 (kanban)

Actions

Fields

• Name (Text)

• Description (Text)

• Due Date (Date)

• Assignee (Link to table)

• Completion Date (Date)

• Status (Single select)

• Observation (Link to table)

• Overdue icon (Formula)

Views

• All actions (grid)

• All actions grouped by assignee (grid)

• All actions grouped by observation (grid)

• Actions that are not completed yet (grid)

• Actions that are in progress (grid)

• Actions that are overdue (grid)

• All actions stacked by their status (kanban)

• Calendar: actions due date (calendar)

Application: GEMBA Walk Registrations

shared

Data sources

Actions (event)

• logout (click)

Login

Data sources

Actions (event)

• open_page (after_login)

Select Walk

Data sources

• All Gemba walks

Walk Details

Data sources

• Walk details

• Observations

Observation Details

Data sources

• Observation details