PPaT Wiki
DocumentationPathwayForumBlogContact
Week streakFOUNDATION0 badges
Language: English
  • English
  • Nederlands
  • Français
  • Deutsch
  • Lea faka-Tonga
  • Te reo Māori
  • မြန်မာ (Burmese)
Ask the community

Your PaT Pathway

0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  • Company Structure: adding a new user
  • Company Structure: customer companies
  • Company Structure: departments, job titles and roles
  • Company Structure: modules for a site or a country
  • Company Structure: process categories
  • Connections: linking PaT to Microsoft 365
  • Forms - API Integration
  • How to create a campaign for the PaT Lite training portal
  • How to edit an existing Bulletin Board Post
  • How to set up your SD Map
  • LMS Feedback: learner ratings and comments
  • LMS Metrics - If you can't measure it, you can't manage it
  • Manage users
  • Pacing recertifications and escalations
  • PaT Business Unit Template Overview
  • SD Workflows - Multi Submit
  • SD Workflows - Workflow Settings
  • System Activity: escalations, logins, emails and more
  • System Config: company settings
  • The org chart
  • Add any Image as a Section Header Icon
  • Assigning an SD to a new parent
  • C2E Attachments
  • Chat reminder
  • Chat to email to chat
  • Chat to SD
  • Chat to task to project
  • Comprehension Audits
  • Customer-specific training: how it works
  • Different Form Uses
  • Docked Chats
  • Docking SDs and Updating Images
  • Email to BFF
  • Email to chat to email – non PaT users
  • Embedding live data in an SD (graphs and spreadsheets)
  • Embedding SDs in SDs
  • Evidential audits: completing one
  • Filing and retrieving SDs
  • Form Wall
  • Health and safety templates
  • How PaT Manages Inactive Users
  • How SD chats work with SD Members and External Users
  • How to unlock a module for a staff member
  • Info Icons
  • Inline chats
  • Invite Attendees
  • LMS Architecture
  • Moving Section Headers
  • Multi-Tasks
  • PaT AI
  • Pop-Out Chat Feature
  • Recurring tasks: create and edit
  • Running Meetings with SDs
  • Safe Walks
  • SD Element Categorisation
  • SD Form Responses: finding and exporting form responses
  • SD Owner Functions
  • SD Task wall view
  • Share and record your screen
  • Task Integrity: what it is and why it drops
  • Track Engagement
  • Using SDs as a report or meeting minutes app
  • Video rooms: guests joining and asking to record
  • Activity Notifications
  • Add members and set permissions
  • AI Summary: a quick summary of an SD
  • Capture and Manage Accidents
  • Capture and Manage Hazards
  • Chat to task
  • Chat Wall
  • Company wiki: searching your company's own modules
  • Contextual Communication
  • Convert a Note to a Task
  • Create a new SD
  • Create a Task
  • Critical Chrome Extensions
  • Document Store: shared links, your folders and favourites
  • Fast Notes
  • Getting help: the PaT Helpdesk
  • Global Search
  • Group Chats
  • How to embed Outlook onto your PaT
  • How to resize your browser to best view PaT
  • How to use the PaT Lite training portal
  • Insert links
  • Module Learning - Desktop
  • Module Learning - Mobile
  • My Profile
  • Newbie PaT Intro – Chats and SDs
  • Notes
  • Out Of Office: turning it on, and the calendar on your Task Wall
  • Outlook 2FA Issue
  • PaT Chat Overview
  • PaT Mobile App – Overview
  • PaT service status: the status page, status alerts and status notices
  • PaT Wiki: finding your way around
  • PaT Wiki: searching, the AI answer and rating it
  • Preview, download and share files
  • Publish a Bulletin Board Post
  • Reading an SD in another language
  • Release-note alerts: a Sys Bot chat when PaT's release notes change
  • SD Elements
  • SD Main page useful features
  • SD Overview
  • Section Headers
  • Security measures for multiple users on a device
  • Share Feedback
  • Signing in to PaT and resetting your password
  • Signing in with MFA: the second step
  • Task Management
  • Task Management System
  • Task Wall
  • The connection icon on your PaT desktop
  • Traffic light progress
  • Upload file attachments
  • Video calls on the mobile app
  • AI Playbook: checking for other tickets with the same number
  • Auto Escalation
  • Build a reporting system
  • Calculated fields and calculated columns
  • Charts: options for lines, bars, axes and single values
  • Chat Management - Pro Tips
  • Conditional Formatting
  • Configuring a UDF: columns and calculated columns
  • Configuring a UDF: filters, grouping and endpoint details
  • Customer-specific training: setting it up
  • Data sources: stage filters, dynamic dates and page values
  • Endpoint Manager: finding endpoints and building your own UDF
  • Form builder: field types
  • Form Builder: layout at each screen size
  • Form Builder: tools and shortcuts
  • Form buttons, PDFs and what happens after submit
  • Form fields: defaults, read-only and other settings
  • Form Test Mode
  • Forms - Extract Data (the AI form builder)
  • Grids linked to a reporting SD: history charts and review comments
  • Grids: columns, formats and filters
  • Grids: conditional formatting
  • Grids: flatten and transpose data
  • Grids: rows, default values and editing rules
  • How managers can turn on OOF for their staff
  • How to build modules in the Module publisher
  • How to create module comprehension audits
  • How to create module evidential audits
  • How to create module quizzes
  • How to embed an SD into the LMS
  • How to make form templates live for everyone to use
  • How to upload form elements to an SD
  • How to use the PAR SD
  • Live H&S Reporting
  • Mastering the Business Strategy Template
  • Module Admin: finding and managing modules
  • Module Completion Notification Setup
  • Module Publisher Content Options
  • PaT SD Map Overview
  • PaT SD Map Presentation
  • PaT SD Templates Overview
  • Playbook Admin: the tickets behind each Quality and Cost category
  • Playbook Admin: when your shadow run is ready to review
  • Playbook editor: adding a portal lookup step
  • Playbook editor: adding a step that cancels an order
  • Pure Forms
  • Required fields, validation and containers
  • Rich text, file uploads and speech to text
  • SD Dashboard: building a dashboard
  • SD Forms
  • SD Security Settings
  • SD Template Helper Functions
  • Stacked views, flip cards, tabs and stages
  • Strategy System
  • Throttling
  • Using Chat to SD to go from being a good manager to a great one
  • Using SDs as the LMS Document
  • PaT Lite: Key aspects of PaT you need to understand
  • What is PaT and why it matters
  • PaT Lite: Chat to Task
  • PaT Lite: Introducing Strategy Documents
  • PaT Lite: Core Philosophy - Standards and Tactical Execution
  • PaT Lite: Intelligent tools that think with you
  • PaT Lite: The Future of business is Culture
  • Security
  • Integrations
0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  1. Documentation
  2. Advanced
  3. Grids linked to a reporting SD: history charts and review comments

Grids linked to a reporting SD: history charts and review comments

Summary This lesson is for people who build forms and SD dashboards with Table grids of form responses, and for the people who review those answers. It shows how to link a grid to a reporting SD, so…

Check yourself

Checking your PaT sign-in…

How To

On this page
  • Linking a grid to a reporting SD
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • What a linked grid shows
  • Step 1
  • Step 2
  • Step 3
  • Review comments: the dots in each cell
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • The history pop-up for a cell
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • History charts on a flattened grid
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Setting up the history pop-up for a grid
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Step 10
  • Purpose / Intent of the Module
  • Header One

Summary This lesson is for people who build forms and SD dashboards with Table grids of form responses, and for the people who review those answers. It shows how to link a grid to a reporting SD, so each answer cell shows small dots for its review comments and opens a history pop-up for that answer. It also covers the history chart for a position on a flattened grid, and the settings each grid has for its own pop-up: the mode, the fields, the legend and the caption.

Linking a grid to a reporting SD

Step 1

This part is for the person who builds the form or SD dashboard. You can link a Table grid that shows a form's responses to a reporting SD, so that each answer cell gets review comment dots and a history pop-up. To set up an SD for reporting, see the lesson Build a reporting system.

Step 2

In the SD Form Builder or SD Dashboard, find the Table grid on the Canvas and click its edit button (the pencil), in the row of small buttons at its top right. The Edit form field window opens.

Step 3

On the General tab, set Data Mode to Endpoint pulled from a data source.

Step 4

In Endpoint, choose an endpoint whose data comes from Form Responses. The lesson Endpoint Manager: finding endpoints and building your own UDF shows where each endpoint's data comes from.

Step 5

Click the Advanced tab. Reporting SD? is below the Transpose Data and Flatten Data settings. It shows only when the grid's Endpoint takes its data from Form Responses, not Grid Form Responses.

Step 6

Click Reporting SD? and choose the reporting SD from the list.

Step 7

Click the green Save and Close button at the bottom right of the window. Each answer cell in the grid then shows small dots for its review comments, and its value opens a history pop-up.

Step 8

To unlink the grid later, clear Reporting SD? with the x in its box, on the Advanced tab, then click Save and Close.

What a linked grid shows

Step 1

For the people who look at the grid, such as on a form or an SD dashboard, each answer cell has two parts to click. The value itself opens the cell's history pop-up. The small dots at the cell's bottom right corner are for its review comments.

Step 2

In an ordinary linked grid, each cell is one person's answer to one question. On a grid with Transpose Data on and a column for each person, the questions are the rows.

Step 3

Columns that PaT fills in itself, such as Created_At, Created_By, Modified_At and Modified_By, have no dots and open nothing. Every other answer cell has dots, even when it is empty.

Review comments: the dots in each cell

Step 1

The dots count the review comments on that person's answer. One grey dot means there are no review comments yet. Blue dots mean there are some.

Step 2

The number of blue dots shows roughly how many: one dot for 1 to 5 comments, two dots for 6 to 20, and three dots for more than 20.

Step 3

To see the exact count, point at the dots. The tip says, for example, 3 review comments, click to view. With none yet, it says No review comments, click to add.

Step 4

Click the dots to view the review comments on that answer, or to add one.

Step 5

You can also move to the dots with the Tab key, then press Enter or Space.

Step 6

The dots show the count from when the grid last loaded. If a comment you added is not counted yet, reload the grid.

The history pop-up for a cell

Step 1

Point at a cell's value. The tip says View history for, then the name of the question.

Step 2

Click the value, not the dots. The history pop-up opens. It says Loading graph dashboard until its chart appears.

Step 3

The pop-up's title names the question. On a grid with a column for each person, the person's name follows it.

Step 4

The chart shows the history of the answer you clicked.

Step 5

To close the pop-up, click the X at its top right, press Esc, or click outside it.

Step 6

If the pop-up says Failed to load graph schema, close it and try again. If it keeps happening, contact the PaT Helpdesk: see the lesson Getting help: the PaT Helpdesk.

History charts on a flattened grid

Step 1

On a grid with Flatten Data on, each cell is a position, such as row 3 of aisle A, and shows the Cell Value Field recorded there. When the grid is linked to a reporting SD, click a cell to open the history chart for that position.

Step 2

The pop-up's title starts with Position, then the cell's row and column, for example Position 3 A.

Step 3

Under the title is a caption. Unless the grid has its own, it starts Every count of this position, oldest to newest, and says that a gap means no count was recorded that visit.

Step 4

The column that names the rows has no dots and opens no chart. The dots on the other cells work as on any linked grid.

Setting up the history pop-up for a grid

Step 1

This part is for the person who builds the form or SD dashboard. A grid linked to a reporting SD has history pop-up settings of its own, on the Advanced tab of its Edit form field window, just below Reporting SD?. They change only that grid's pop-up.

Step 2

The settings show only once the grid is linked to a reporting SD: History Pop-up Mode, History Pop-up Legend and History Pop-up Caption, and on a flattened grid History Fields (multi value) too. The rest of the pop-up's chart is the same for every grid.

Step 3

History Pop-up Mode decides what the chart shows. Single value, the default, charts the cell's own value: on a flattened grid, the Cell Value Field.

Step 4

On a flattened grid, to chart several fields at once, set History Pop-up Mode to Multi value. Other grids offer Single value only.

Step 5

In History Fields (multi value), pick the fields to chart. Each one becomes its own series.

Step 6

History Fields (multi value) shows only on a flattened grid, so only a flattened grid can chart several fields.

Step 7

Each series takes its colour from the grid's conditional formatting rule for that field.

Step 8

Switch on History Pop-up Legend to add a legend that names each series. It is off by default.

Step 9

In History Pop-up Caption, type a sentence to show under the pop-up's title, to tell readers what the chart shows. Left empty, a flattened grid shows its default caption, and other grids show none.

Step 10

Click the green Save and Close button. The next history pop-up opened from the grid uses the new settings.

Purpose / Intent of the Module

A brief description of what this module is about

Header One

Ready? Back to the quiz

Rate this page

Checking your PaT sign-in…

PreviousForms - Extract Data (the AI form builder)Next Grids: columns, formats and filters

On this page

  • Linking a grid to a reporting SD
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • What a linked grid shows
  • Step 1
  • Step 2
  • Step 3
  • Review comments: the dots in each cell
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • The history pop-up for a cell
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • History charts on a flattened grid
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Setting up the history pop-up for a grid
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Step 10
  • Purpose / Intent of the Module
  • Header One
PPaT Wiki

Documentation, knowledge base and community support for People and Tasks.

Documentation

  • Getting started
  • Core concepts
  • Integrations
  • API reference Coming soon

Support

  • Knowledge base
  • Release notes
  • Community forum
  • Contact us
  • Service status

Company

  • PaT
  • Blog
  • Terms
  • Privacy

© People and Tasks. All rights reserved.