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
Uw aanmelding bij PaT wordt gecontroleerd…
How To
Op deze pagina
- 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
Rate this page
Checking your PaT sign-in…