PPaT Wiki
Ngā tuhinga whakamāramaPathwayHuinga kōreroPae rangitakiWhakapā mai
Week streakFOUNDATION0 badges
Reo: Te reo Māori
  • English
  • Nederlands
  • Français
  • Deutsch
  • Lea faka-Tonga
  • Te reo Māori
  • မြန်မာ (Burmese)
Pātai atu ki te hapori

Your PaT Pathway

0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  • Hanganga Kamupene: ngā kōwae mō tētahi pae, whenua rānei
  • Hanganga Kamupene: te tāpiri kaiwhakamahi hou
  • Hanganga o te Kamupene: ngā tari, ngā taitara tūranga me ngā tūranga mahi
  • Me pēhea te waihanga kaupapa mō te tomokanga whakangungu PaT Lite
  • Me pēhea te whakarite i tō Mahere SD
  • Me pēhea te whakatika i tētahi whakairinga kei te Papa Pānui
  • Ngā Hononga: te hono i PaT ki Microsoft 365
  • Ngā Ine LMS – Ki te kore e taea e koe te ine, kāore e taea e koe te whakahaere
  • Ngā Puka - Te Whakaurunga API
  • Ngā Urupare LMS: ngā whakatauranga me ngā kōrero a ngā ākonga
  • Ngohe Pūnaha: ngā pikinga take, ngā takiuru, ngā īmēra me ētahi atu
  • PaT He Tirohanga Whānui ki te Tātauira Wāhanga Pakihi
  • SD Ngā Rerengamahi - Ngā Tautuhinga Rerengamahi
  • SD Ngā Rerengamahi - Tuku Maha
  • Te āta whakarite i ngā arotake anō me ngā whakamōhiotanga piki taumata
  • Te Hanganga o te Kamupene: ngā kamupene kiritaki
  • Te Hanganga o te Kamupene: ngā kāwai tukanga
  • Te tūtohi hanganga whakahaere
  • Whakahaere kaiwhakamahi
  • Whirihoranga Pūnaha: ngā tautuhinga kamupene
  • Aroturuki i te whai wāhi
  • Īmēra ki BFF
  • Kōrerorero ki SD
  • Mai i te īmēra ki te kōrerorero, ā, hoki ki te īmēra – mō ngā tāngata kāore e whakamahi ana i PaT
  • Mai i te kōrerorero ki te īmēra, ā, hoki anō ki te kōrerorero
  • Mai i te kōrerorero ki te mahi, ki te kaupapa
  • Me pēhea PaT e whakahaere ai i ngā kaiwhakamahi hohe-kore
  • Me pēhea te wetewete i tētahi kōwae ako mō tētahi kaimahi
  • Ngā Āhuatanga Kōrerorero Matapihi-ake
  • Ngā Āpitihanga C2E
  • Ngā Arotake Māramatanga
  • Ngā arotake taunaki: te whakaoti i tētahi
  • Ngā Ata Tohu Mōhiohio
  • Ngā Hīkoi Haumaru
  • Ngā Kōrerorero Kua Tāmaua
  • Ngā kōrerorero rōraina
  • Ngā Mahi a te Kaipupuri SD
  • Ngā mahi auau: te waihanga me te whakatika
  • Ngā rūma ataata: te hono mai a ngā manuhiri me te tono kia tuhi
  • Ngā tauira hauora me te haumaru
  • Ngā Tūmahi Maha
  • Ngā whakamahinga rerekē o ngā puka
  • Nuku i ngā Pane Wāhanga
  • PaT AI
  • Pātū Puka
  • SD Ngā Whakautu Puka: te kimi me te kaweake i ngā whakautu puka
  • Tāpirihia he Atahanga hei Ata o te Pane Wāhanga
  • Te āhua o ngā kōrerorero a SD me ngā Mema o SD me ngā Kaiwhakamahi o Waho
  • Te Hanganga o te LMS
  • Te Pono ki ngā Mahi: he aha tēnei, ā, he aha i heke ai
  • Te tāpiri raraunga ora ki tētahi SD (ngā kauwhata me ngā ripakaute)
  • Te tautapa i tētahi SD ki tētahi mātua hou
  • Te whakahaere hui mā ngā SDs
  • Te whakamahi i ngā SDs hei taupānga pūrongo, hei taupānga hoki mō ngā meneti hui
  • Te whakarōpū me te tiki anō i ngā SDs
  • Te Whakatūunga i ngā SDs me te Whakahōu i ngā Atahanga
  • Te whakauru i ngā SDs ki roto i ngā SDs
  • Tiritiria, tuhia hoki tō mata
  • Tirohanga pakitara Tūmahi SD
  • Tonoa ngā Tāngata kia Hono Mai
  • Whakamahara kōrerorero
  • Whakangungu motuhake mā te kiritaki: te āhua o te whakahaere
  • Whakarōpūtanga Huānga o SD
  • Arokite, tikiake, ka tohaina ngā kōnae
  • He raruraru ki te manatoko-ā-taumata-rua o Outlook
  • Hopukina, Whakahaerehia hoki ngā aituā
  • Hurihia te kōrerorero hei tūmahi
  • Hurihia tētahi Tuhipoka hei Tūmahi
  • Kei Waho i te Tari: te whakakā, me te maramataka kei tō Pātū Tūmahi
  • Kōkuhutia ngā hononga
  • Kupu Whakataki mō te PaT mā te Tauhou – Ngā Kōrerorero me ngā SDs
  • Me pēhea te whakamahi i te tomokanga whakangungu PaT Lite
  • Me pēhea te whakarerekē i te rahi o tō pūtirotiro kia pai ai te tirohanga ki PaT
  • Me pēhea te whakauru i a Outlook ki tō PaT
  • Ngā āhuatanga whaihua o te whārangi matua o SD
  • Ngā Ākonga o te Kōwae – Waea Pūkoro
  • Ngā Kōrerorero ā-Rōpū
  • Ngā Kōwae Ako - Papamahi
  • Ngā Pane Wāhanga
  • Ngā Pānui Mahi
  • Ngā pānui mō ngā whakahou: he kōrerorero nā Sys Bot ina rerekē ngā pitopito tuku a PaT
  • Ngā tikanga haumaru mō ngā kaiwhakamahi maha i runga i te pūrere
  • Ngā Toronga Chrome Hirahira
  • Ngā tuhipoka
  • Ngā Tuhipoka Tere
  • Ngā waea ataata i te taupānga pūkoro
  • PaT He tirohanga whānui ki te Kōrerorero
  • PaT te āhua o te ratonga: te whārangi āhua, ngā matohi āhua me ngā pānui āhua
  • PaT Wiki: te rapu ara
  • PaT Wiki: te rapu, te whakautu a te AI me te tuku whakatauranga
  • Pātaka Tuhinga: ngā hononga tiritahi, ō kōpaki me ngā mea tino pai ki a koe
  • Pātū Tūmahi
  • Pūnaha Whakahaere Tūmahi
  • Rapu Whānui
  • SD Ngā Huānga
  • SD Tirohanga whānui
  • Taku Kōtaha
  • Tāpiri mema me te whakarite whakaaetanga
  • Taupānga Pūkoro PaT – Tirohanga Whānui
  • Te ahunga whakamua ā-rama waka
  • Te ata hono i runga i tō papamahi PaT
  • Te Hopu me te Whakahaere i ngā Mōrearea
  • Te pānui i tētahi SD ki tētahi atu reo
  • Te Pātū Kōrerorero
  • Te takiuru ki PaT me te tautuhi anō i tō kupuhipa
  • Te takiuru mā te MFA: te taahiraa tuarua
  • Te tiki āwhina: te Papamahi Āwhina PaT
  • Te Whakahaere Tūmahi
  • Te Whakawhiti Kōrero ā-Pūtaketanga
  • Tiri Urupare
  • Tukuatu ngā āpitihanga kōnae
  • Waihangaia he Tūmahi
  • Waihangatia he SD hou
  • Whakaputa i tētahi Tuku ki te Papa Pānui
  • Whakarāpopototanga AI: he whakarāpopototanga tere o tētahi SD
  • Wiki a te kamupene: te rapu i ngā kōwae ake a tō kamupene
  • Aratau Whakamātau Puka
  • Calculated fields and calculated columns
  • Charts: options for lines, bars, axes and single values
  • Data sources: stage filters, dynamic dates and page values
  • Form Builder: layout at each screen size
  • Form Builder: tools and shortcuts
  • 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
  • Hangaia he pūnaha pūrongo
  • Kaihanga puka: ngā momo āpure
  • Kaiwhakahaere Kōwae: te kimi me te whakahaere kōwae
  • Kaiwhakahaere Playbook: kua rite tō oma ātārangi mō te arotake
  • Kaiwhakahaere Playbook: ngā tīkiti kei muri i ia kāwai Kounga me te Utu
  • Kaiwhakahaere Tohu Whakamutunga: te kimi tohu whakamutunga me te hanga i tāu ake UDF
  • Kaiwhakatika Playbook: te tāpiri i tētahi hipanga rapu i te pae tomokanga
  • Kaiwhakatika pukapuka mahi: te tāpiri i tētahi hipanga hei whakakore i tētahi ota
  • Me pēhea te hanga arotake taunakitanga mō ngā kōwae ako
  • Me pēhea te tāpiri i tētahi SD ki te LMS
  • Me pēhea te tuku i ngā huānga puka ki tētahi SD
  • Me pēhea te waihanga aromatawai mārama mō ngā kōwae ako
  • Me pēhea te waihanga kōwae i te Kaiwhakaputa Kōwae
  • Me pēhea te waihanga patapātai kōwae
  • Me pēhea te whakahohe i ngā tauira puka kia whakamahia e te katoa
  • Me pēhea te whakakā a ngā kaiwhakahaere i te OOF mō ā rātou kaimahi
  • Me pēhea te whakamahi i te PAR SD
  • Ngā āpure e hiahiatia ana, te whakamana me ngā ipu
  • Ngā āpure puka: ngā uara taunoa, te aratau pānui-anake me ētahi atu tautuhinga
  • Ngā Āwhina Tātauira SD
  • Ngā Kōwhiringa Ihirangi mō te Kaiwhakaputa Kōwae
  • Ngā pātene puka, ngā PDF me ngā mea ka tupu i muri i te tukunga
  • Ngā Puka – Tango Raraunga (te kaihanga puka AI)
  • Ngā Puka SD
  • Ngā Puka Tōtika
  • Ngā Tautuhinga Haumarutanga SD
  • PaT SD He tirohanga whānui ki ngā tauira
  • PaT SD Tirohanga whānui ki te Mahere
  • PaT SD Whakaaturanga Mahere
  • Pūnaha Rautaki
  • Pūrongo Hauora me te Haumaru (H&S) Wā Tūturu
  • Rich text, file uploads and speech to text
  • SD Papatohu: te hanga papatohu
  • Stacked views, flip cards, tabs and stages
  • Te Aratohu AI: te tirotiro i ētahi atu tīkiti he ōrite te tau
  • Te Whakahaere Kōrerorero – He Tohutohu Mātauranga
  • Te Whakahaere Matatau i te Tātauira Rautaki Pakihi
  • Te whakamahi i ngā SDs hei Tuhinga LMS
  • Te whakamahi i te Chat to SD kia neke atu i te kaiwhakahaere pai ki te kaiwhakahaere tino pai
  • Te Whakarite Whakamōhiotanga Whakaoti Kōwae
  • Te whakawhāiti i te tere
  • Te whirihora i tētahi UDF: ngā tātari, te whakarōpū me ngā taipitopito pito-mutunga
  • Te whirihora i tētahi UDF: ngā tīwae me ngā tīwae tātai
  • Whakahōputu Herekore
  • Whakakake aunoa
  • Whakangungu mō ia kiritaki ake: te whakarite
  • PaT Lite: Ngā āhuatanga matua o PaT me mārama koe
  • He aha a PaT, ā, he aha te take nui
  • PaT Lite: Kōrerorero hei Tūmahi
  • PaT Lite: He kupu whakataki ki ngā Strategy Documents
  • PaT Lite: Te Whakaaro Matua – Ngā Paerewa me te Whakatinanatanga Rautaki
  • PaT Lite: He taputapu atamai e whakaaro tahi ana me koe
  • PaT Lite: Ko te Ahurea te Anamata o te Pakihi
  • Haumarutanga
  • Ngā whakaurunga
0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  1. Tuhinga āwhina
  2. Arā Atu Anō
  3. Grids linked to a reporting SD: history charts and review comments

Kāore anō tēnei whārangi kia whakamāoritia, nō reira kei te whakaaturia ki te reo Pākehā.

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

E tirohia ana tō takiuru PaT…

How To

Kei tēnei whārangi
  • 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…

O muaForm Builder: tools and shortcutsO muri Grids: columns, formats and filters

Kei tēnei whārangi

  • 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

He tuhinga, he pātengi raraunga mātauranga, he tautoko ā-hapori hoki mō People and Tasks.

Tuhinga

  • Te tīmatanga
  • Ngā ariā matua
  • Ngā tuituitanga
  • Tohutoro API Ākuanei

Tautoko

  • Pātengi raraunga mātauranga
  • Ngā pitopito kōrero tuku
  • Huinga ā-hapori
  • Whakapā mai
  • Tūnga ratonga

Kamupene

  • PaT
  • Tuhinga rangitaki
  • Ngā Ture
  • Tūmataitinga

© People and Tasks. Kua rāhuitia ngā motika katoa.