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: conditional formatting

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

Grids: conditional formatting

Summary Conditional formatting changes how the cells of a Table grid look when they meet a rule: it can give them a background colour, show an icon in them, or turn the matched words into a link…

Check yourself

E tirohia ana tō takiuru PaT…

How To

Kei tēnei whārangi
  • Opening the Conditional Formatting tab
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Colouring cells from the Data Preview
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Adding a rule
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Step 10
  • Rule order, switching rules off and saving
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Showing an icon or an image from the image library
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Turning the matched words into a link
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Flattened grids: colouring a cell by a field it does not show
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Step 10
  • Step 11
  • Purpose / Intent of the Module
  • Header One

Summary Conditional formatting changes how the cells of a Table grid look when they meet a rule: it can give them a background colour, show an icon in them, or turn the matched words into a link. This lesson is for the person who builds forms or dashboards in PaT. It covers setting up rules with the Data Preview, icons from the image library, web links, and colouring a flattened grid's cells by a field they do not show.

Opening the Conditional Formatting tab

Step 1

Conditional formatting changes the cells of a Table grid that meet a rule you set: it gives them a background colour, an icon or a link. The person who builds the form or dashboard sets up the rules, and everyone who views the grid sees the result.

Step 2

To show or hide a form element depending on an earlier answer, see the lesson Conditional Formatting instead.

Step 3

In SD Form Builder or SD Dashboard, click the Table grid's Edit button, the green pencil at its top right. The Edit form field window opens.

Step 4

Click the Conditional Formatting tab, the last tab along the top of the window.

Step 5

At the top right of the tab, switch on the toggle so it reads Enabled. While it reads Disabled, the grid uses none of its rules.

Step 6

A bar below the toggle says which rules you are editing: Normal Mode for a standard grid, Transposed Mode when Transpose Data is switched on, or Flattened Mode when Flatten Data is switched on, both on the Advanced tab. A transposed grid uses its own set of rules, not the normal ones.

Colouring cells from the Data Preview

Step 1

When the grid takes its rows from an endpoint (on the General tab, Data Mode is Endpoint pulled from a data source), the tab shows a Data Preview of the grid's first 10 rows.

Step 2

If the Data Preview does not show after you choose the endpoint, click Save and Close, then open the Edit form field window again.

Step 3

To colour every cell that holds a certain value, click one such cell in the preview. A Cell Color panel opens below it, naming the column and the value, for example Status = "Done".

Step 4

A colour picked for an empty cell makes a rule with the condition Is Empty, which colours the empty cells of that column.

Step 5

Under Quick Colors, click a colour. Or type a colour code, such as #fde047, under Custom Color and click Apply.

Step 6

PaT adds a rule at the bottom of Formatting Rules: that column Equals that value, with that background colour. The preview shows the colour straight away.

Step 7

To start a rule for one column, click the column's heading in the preview. A new rule for that column opens under Formatting Rules, ready for its condition and value.

Step 8

The preview follows every change you make to the rules, so you can see what a rule does before you save it.

Step 9

A grid whose rows are typed in (Data Mode is Static - Data entered manually) has no Data Preview. Add its rules with Add Rule instead.

Adding a rule

Step 1

Click Add Rule, under Formatting Rules. A new rule opens, set to colour matching cells Light Green.

Step 2

Under Target Column, choose the column whose cells the rule checks, or leave All Columns to check every cell.

Step 3

Under Condition, choose how to compare: Equals, Not Equals, Contains, Does Not Contain, Starts With, Ends With, Is Empty, Is Not Empty, Greater Than, Less Than, Greater Than or Equal, Less Than or Equal, or Between.

Step 4

Type the value to compare with in Value. Is Empty and Is Not Empty need no value.

Step 5

For Between, type the lowest value in From Value and the highest in To Value. Both ends count as a match.

Step 6

Greater Than, Less Than and Between compare numbers: a cell that does not hold a number never matches them.

Step 7

Text comparisons ignore capitals. To match capitals exactly, switch on Case sensitive.

Step 8

Under Background Color, click a colour (point at one to see its name), or type a colour code in Custom Hex.

Step 9

Until a rule is complete, it has a red border and says what is missing, for example Comparison value is required for this condition type.

Step 10

The top line of each rule sums it up, for example Status Equals "Done", with its place in the list, such as #1. Click the line to close the rule or open it again.

Rule order, switching rules off and saving

Step 1

Rules are checked from the top of the list down. The first matching Background Colour rule gives a cell its colour, and the first matching icon or link rule gives it an icon or link, so one cell can show both.

Step 2

The Data Preview shows only the first matching rule for each cell. Check a cell with both a colour and an icon or link on the grid itself.

Step 3

To change the order, drag a rule by the handle of six dots at the left of its top line.

Step 4

To stop a rule for now without deleting it, switch off Enabled at the bottom of the rule. The rule turns pale and no longer applies.

Step 5

To delete a rule, click the red bin at the bottom right of the rule. It goes at once, without asking.

Step 6

If a rule's column is no longer in the grid, a warning sign shows on the rule's top line. Point at it to read This column is no longer available in the grid.

Step 7

Click Save and Close, at the bottom of the window, to keep your rules. Close, at the top right, leaves the grid as it was.

Showing an icon or an image from the image library

Step 1

Under Format Type, choose what a rule does to a matching cell: Background Colour, Chat Link, Icon, SD Link, Form Link or Web Link (URL).

Step 2

Chat Link, SD Link and Form Link show a chat icon, an SD link or a Form link in place of the cell's text. Pointing at it shows Open chat for, View SD for or View Form for, followed by the cell's value.

Step 3

Before you rely on these links, click one on the finished form or dashboard to check that it opens the chat, SD or form you expect.

Step 4

Choose Icon. Under Icon Settings, click one of the ready-made icons: Chat, Form or SD.

Step 5

To use a picture from the image library instead, click Select Image from Library and type part of its name. Each image shows with its name: click one to use it.

Step 6

Select Image from Library only appears when the image library has images to offer.

Step 7

To use a picture from elsewhere on the web, click Custom URL, then paste the picture's web address into Custom Icon URL.

Step 8

Type the icon's width in Icon Width, for example 24px.

Step 9

On the grid, the icon shows in the middle of the cell, in place of the cell's text. In the Data Preview, it shows small, in a cell with a dashed border.

Turning the matched words into a link

Step 1

Choose Web Link (URL) under Format Type, then type the web address the link should open in Link URL. It must start with http:// or https://.

Step 2

With Equals, Contains, Starts With or Ends With, only the matched words become the link. For example, a rule that Contains manual links just the word manual in See the manual for details.

Step 3

With any other condition, the whole cell value becomes the link.

Step 4

A person viewing the grid clicks the link, and the web address opens in a new browser tab. Every cell the rule matches links to the same address.

Step 5

In the Data Preview, the linked words are underlined in blue.

Flattened grids: colouring a cell by a field it does not show

Step 1

A flattened grid has Flatten Data switched on, on the Advanced tab. Each cell shows one value, from the Cell Value Field of the record at that row and column, and the record's other fields are not shown.

Step 2

To colour cells by one of those other fields, open the Advanced tab and choose the field in Fields Available to Formatting. You can choose more than one.

Step 3

Open the Conditional Formatting tab. A flattened grid has its own rules, so the list starts empty. Until you add one, the grid keeps using its normal rules; once you add one, only the flattened grid's own rules apply.

Step 4

The bar at the top of the tab says Flattened Mode on a flattened grid, and the rules listed are the flattened grid's own.

Step 5

Click Add Rule. In place of Target Column, the rule now has Colour the cell based on.

Step 6

In Colour the cell based on, choose the field to test. The rule then tests that field in the record behind each cell, on every cell of the grid. Leave it on What the cell itself shows to test the value the cell displays.

Step 7

Set the Condition, the Value and the colour as for any rule. With Equals and Not Equals, these fields compare numbers as numbers, so 1.00 matches a field that holds 1.

Step 8

A position where nothing has been recorded reads blank for every field. A rule that uses Is Empty colours those positions, so you can see what has not been recorded yet.

Step 9

For example, on a stocktake grid with aisles as rows and bays as columns, each cell shows a count. Choose Status in Fields Available to Formatting, then add a rule based on Status that Equals Over, coloured Red.

Step 10

If no field is chosen in Fields Available to Formatting, each rule shows Target Column instead, which lists the flattened grid's own columns, such as the column that names the rows and each column heading.

Step 11

Build rules based on Fields Available to Formatting with Add Rule, and check their colours on the grid itself.

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: columns, formats and filtersO muri Grids: flatten and transpose data

Kei tēnei whārangi

  • Opening the Conditional Formatting tab
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Colouring cells from the Data Preview
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Adding a rule
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Step 10
  • Rule order, switching rules off and saving
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Showing an icon or an image from the image library
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Turning the matched words into a link
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Flattened grids: colouring a cell by a field it does not show
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Step 10
  • Step 11
  • 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.