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: columns, formats and filters

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

Grids: columns, formats and filters

Summary This module is for people who build grids in PaT forms and dashboards, and for anyone who reads them. It shows how to give a column your own title and put the original back with Reset, show…

Check yourself

E tirohia ana tō takiuru PaT…

How To

Kei tēnei whārangi
  • Giving a grid column your own title
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Putting the original title back with Reset
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Showing or hiding all columns at once
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Running a grid at full width
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Setting decimal places for a number column
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Limiting a grouped date column to a first and last date
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Sorts and filters that stay in place
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Purpose / Intent of the Module
  • Header One

Summary This module is for people who build grids in PaT forms and dashboards, and for anyone who reads them. It shows how to give a column your own title and put the original back with Reset, show or hide every column at once, and run a grid at full width. It also covers the decimal places and date limits set in a data source, and the sorts and filters a grid keeps while you work.

Giving a grid column your own title

Step 1

The person who builds the form or dashboard does this. On the canvas of the SD Form Builder or SD Dashboard, click the grid's edit button (the pencil) at its top right. The Edit form field window opens on its General tab, with the grid's columns further down.

Step 2

Click the three dots at the right end of a column's header. The column's settings open, with its current title in bold at the top.

Step 3

Under Column Title, type the title you want people to see. The column's header changes as you type.

Step 4

Click Save at the bottom of the column's settings to close them.

Step 5

Click the green Save and Close button at the bottom right of the window to keep the new title.

Step 6

On a grid whose Data Mode is Endpoint pulled from a data source, the columns and their titles come from the endpoint. Once saved, a title you typed yourself is kept every time the grid loads its columns again, such as when it refreshes or when you next open the Edit form field window.

Step 7

Columns you have not renamed keep taking their titles from the endpoint: each time the grid loads its columns, they show the title the endpoint gives them.

Step 8

Save before you refresh. In the Edit form field window, the refresh button just above the columns (pointing at it shows Refresh column data from API endpoint) can load the columns as they were last saved, so a title you have not saved yet can be lost.

Putting the original title back with Reset

Step 1

Once a column has a title you typed, a Reset button with a curved arrow appears beside its Column Title box. Pointing at the button shows Reset to API column name.

Step 2

Click Reset. Until the grid loads again, the box and the column's header show the column's internal name instead of a title.

Step 3

Click the green Save and Close button. The next time the grid loads, in the form or in the Edit form field window, the column shows the endpoint's title again.

Step 4

Reset is meant for grids that take their data from an endpoint. A grid filled in by hand has no endpoint title to go back to, so on those grids type the title again instead of clicking Reset.

Showing or hiding all columns at once

Step 1

In the grid's Edit form field window, the Show All and Hide All buttons sit just above the grid of columns, at its right, on the General tab.

Step 2

Click Hide All. It hides every column except the first, which holds the round + for adding rows. A message confirms how many columns were hidden.

Step 3

Click Show All to show every column again. A message confirms how many columns are shown.

Step 4

To hide or show one column, click the three dots in its header. Under Hide Attributes, click the Column switch so it reads HIDE, or click it again so it reads SHOW.

Step 5

In the Edit form field window, hidden columns stay in view so you can still set them up. Each one shows an eye with a line through it beside its three dots. Pointing at the eye shows Column is hidden from view.

Step 6

People using the finished form or dashboard do not see hidden columns.

Step 7

Click the green Save and Close button. Then open the Edit form field window again and check that each column you hid still shows the eye with a line through it.

Running a grid at full width

Step 1

In the grid's Edit form field window, on the General tab, find Full Width Grid in the Grid section, which is already open, and switch it on. The note under the switch says the grid will expand to use the full available width of its container.

Step 2

With Full Width Grid on, the grid stretches across the whole space it sits in. With it off, the grid is only as wide as its columns added together.

Step 3

Full Width Grid is offered only on grids whose Data Mode is Endpoint pulled from a data source. A grid filled in by hand already spans the full width.

Step 4

On a phone-sized screen, the grid keeps the width of its columns and scrolls sideways, even with Full Width Grid on.

Step 5

Click the green Save and Close button to keep the setting.

Setting decimal places for a number column

Step 1

Decimal places are set by the person who looks after the grid's data source. In the Endpoint Manager, click Edit Endpoint on the card of the UDF the grid uses. The Configure Data Source window opens.

Step 2

Click the Columns tab, then click the header of a number column in the data table. The column's settings open on the right, with Number chosen under Data Type.

Step 3

Under Decimal Places, type how many decimal places to show, from 0 to 10. The setting starts at 2.

Step 4

Decimal Places also appears for calculated columns, where it applies when the result is a number. It matters most for values such as an average, which often have many decimal places.

Step 5

Click Apply to Data at the top of the window to save the change. The data table then shows the column's numbers with that many decimal places.

Step 6

Grids in forms and dashboards built on the endpoint show the column with that many decimal places too: with 0, 4 shows as 4, not 4.00.

Limiting a grouped date column to a first and last date

Step 1

Date limits are also set in Configure Data Source. On the Columns tab, click the header of a date column in the data table to open its settings.

Step 2

Under Group By, switch on Enable GROUP BY. Lower down, three more settings appear for the date column: Date Aggregation (Padding), Min Bound Date and Max Bound Date.

Step 3

Under Min Bound Date, open Min Date Boundary and choose where the dates start. Default - Min in dataset starts at the earliest date in the data.

Step 4

Under Max Bound Date, open Max Date Boundary and choose where the dates end. A column starts with Default - Up to yesterday data, which ends at yesterday. Default - Max in dataset ends at the latest date in the data.

Step 5

To set a boundary from a date of your own, first add a rule on a date column under WHERE Clause in the Query Builder tab. That column is then listed in Min Date Boundary and Max Date Boundary by its title, followed by its internal name in brackets. Choose it to take the boundary from that rule.

Step 6

If no date column has a rule, Min Bound Date and Max Bound Date say No date columns available in WHERE clause filters.

Step 7

The limits set the first and last dates used when the data is grouped by date. Under Date Aggregation (Padding), Gap Filling Strategy sets how missing dates are handled. It starts on None - Standard date grouping.

Step 8

Click Apply to Data to save the changes and see the result.

Sorts and filters that stay in place

Step 1

Anyone reading a grid in a form or dashboard can filter or sort it by a column. Click the three dots in the column's header to open its menu.

Step 2

Under Filter, type a value and choose a Filter Type, such as Contains. Press Enter, or click the green funnel button, to filter the grid.

Step 3

To sort by the column, click Sort A-Z or Sort Z-A under Sort, in the same menu.

Step 4

A small badge then shows in the column's header, green for a filter and purple for a sort. Point at a badge to read what it does, for example Sorted ascending.

Step 5

PaT keeps your filter and sort while the page is open. A grid that takes its data from an endpoint refreshes itself every 2 minutes, or when you click the refresh arrow at its top right. Your filter and sort stay in place when it does. The 2-minute refresh waits while a cell is being edited. After a cell is changed, the grid stops refreshing by itself until it is loaded again, so the refresh does not replace the change.

Step 6

Open the column's menu again to see the filter value and Filter Type you chose, with your sort highlighted.

Step 7

To see every row in its usual order again, open the menu and click Clear Filter, the red funnel button, or Clear Sort.

Step 8

Reloading the page starts the grid again with no filter or sort.

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 muaGrids linked to a reporting SD: history charts and review commentsO muri Grids: conditional formatting

Kei tēnei whārangi

  • Giving a grid column your own title
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Putting the original title back with Reset
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Showing or hiding all columns at once
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Running a grid at full width
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Setting decimal places for a number column
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Limiting a grouped date column to a first and last date
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Sorts and filters that stay in place
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • 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.