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: rows, default values and editing rules

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

Grids: rows, default values and editing rules

Summary This lesson is for people who build forms with a Table grid in the Form Builder. It shows how to give new rows a default value, take a Dropdown column's options from an endpoint, set up…

Check yourself

E tirohia ana tō takiuru PaT…

How To

Kei tēnei whārangi
  • Giving new rows a default value
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Taking a Dropdown column's options from an endpoint
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Setting up starting rows
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Locking a starting row: Row level overrides
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Stopping people changing a column: Is editable
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Rows people add when they fill in the form
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Opening the SD behind a form responses UDF: Open SD
  • 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 lesson is for people who build forms with a Table grid in the Form Builder. It shows how to give new rows a default value, take a Dropdown column's options from an endpoint, set up starting rows and lock them, and control what the people filling in the form can add, delete, move or change. It ends with the Open SD button, which opens the SD behind a form responses UDF from the Endpoint Manager.

Giving new rows a default value

Step 1

In the Form Builder, click the edit button (the pencil) at the top right of your Table grid. The Edit form field Table window opens.

Step 2

In the table in the window, click the three dots next to the title of a Dropdown column. The column's panel opens.

Step 3

Type the value into Default value, below the column's options. Spell it exactly as it is in Dropdown Options.

Step 4

Default value is only offered for Dropdown columns. Columns of the other types have no default.

Step 5

Click Save at the bottom of the column's panel to close it.

Step 6

From then on, every new row starts with that value in the column, including the rows people add when they fill in the form.

Step 7

Rows already in the table keep their values. The default only goes into new rows.

Step 8

To keep your changes, click Save and Close Table at the bottom right of the Edit form field Table window.

Taking a Dropdown column's options from an endpoint

Step 1

A Dropdown column can take its options from an endpoint instead of a list you type, so the options follow the endpoint's data as it changes.

Step 2

In the Edit form field Table window, click the three dots next to the column's title. In its panel, choose Dropdown under Type.

Step 3

Under Fetch from, choose Endpoint pulled from a data source.

Step 4

Under Data source endpoint, choose the endpoint. Address of endpoint then fills in by itself, and cannot be typed in.

Step 5

If the endpoints cannot be loaded, the column's panel says Error loading data sources.

Step 6

Changing Fetch from, or choosing another endpoint, empties the column: the values already in it are cleared in every row.

Step 7

Click Save at the bottom of the column's panel, then Save and Close Table at the bottom right of the window.

Step 8

When people fill in the form and click a cell in the column, PaT loads its options from the endpoint. They can type to narrow the list, then pick an option. Each option shows the record's title, or else its name, or else its first field.

Step 9

To find or build an endpoint, see the lesson Endpoint Manager: finding endpoints and building your own UDF.

Setting up starting rows

Step 1

Starting rows are rows you add in the Edit form field Table window. They are in the table when people open the form.

Step 2

Set each column's Type before you add rows. Changing a column's Type later empties the column: its values are cleared in every row.

Step 3

Once the table has a column, click the + (a plus in a circle) at the top of the first column. An empty row is added at the bottom of the table.

Step 4

Click a cell in the new row and type its value. In a Dropdown column, pick the value from the list.

Locking a starting row: Row level overrides

Step 1

In the Edit form field Table window, each row starts with a drag handle (a small stack of lines) and three dots. Click the three dots of the row you want to lock.

Step 2

The row's menu opens. Under Row level overrides, it lists Deletable and Movable, each with a lock, and says Click on locks to switch modes. Editable, with a lock, is listed only when one of the table's columns has no Is editable setting.

Step 3

A red closed lock means the row is locked for that action. A green open lock means it is unlocked. Click a lock to switch it.

Step 4

With Deletable locked, people filling in the form see no bin for that row, so they cannot delete it. A row you add in the Edit form field Table window starts with Deletable locked.

Step 5

With Movable locked, the row has no drag handle when people fill in the form, so they cannot move it. A row you add in the Edit form field Table window starts with Movable unlocked.

Step 6

Editable has no effect on columns made with Add column, because each of them has Is editable set to YES or NO. Only a column with no Is editable setting follows each row's Editable lock, until you set it. The note under its Is editable switch says Not set yet. To stop people changing a column, see the next part.

Step 7

To remove a row, click Delete at the top of its menu, then click OK when PaT asks Are you sure you want to delete this row?

Step 8

Click Save at the bottom of the row's menu to close it. The locks are kept when you click Save and Close Table.

Stopping people changing a column: Is editable

Step 1

In the Edit form field Table window, click the three dots next to the column's title, and find Is editable in its panel.

Step 2

With Is editable on YES, people filling in the form can change the column's cells in every row. With it on NO, they cannot change them in any row.

Step 3

New columns start on YES. Choosing Dropdown as a column's Type switches Is editable to YES, and unlocks Editable on every row.

Step 4

Is editable overrides the row level setting. A column on YES can be changed even in a row whose Editable is locked. The note under the switch says so too: This setting overrides a row's Editable lock.

Step 5

Click Save at the bottom of the column's panel, then Save and Close Table.

Rows people add when they fill in the form

Step 1

Three switches in the Grid section, on the General tab of the Edit form field Table window, decide what people can do with the rows they add: Allow Adding of Rows, Allow Deleting of Rows and Allow Drag And Drop of Rows.

Step 2

A new Table grid starts with all three switched on.

Step 3

With Allow Adding of Rows switched on, people filling in the form see a + at the top of the first column. Clicking it adds an empty row.

Step 4

With Allow Deleting of Rows switched off, people can still add rows, but the rows they add have no bin, so they cannot delete them.

Step 5

With Allow Drag And Drop of Rows switched off, the rows people add have no drag handle, so they cannot be moved.

Step 6

The three switches act on the rows people add. Rows you added in the Edit form field Table window keep their own locks: to stop people deleting or moving one, lock it in its row menu.

Step 7

Click Save and Close Table at the bottom right of the window to keep the switches.

Opening the SD behind a form responses UDF: Open SD

Step 1

Open an SD and click its Advanced tab. In the menu on the left, under PaT BI, click SD Endpoint Manager.

Step 2

Find your UDF built from form responses: its card has a Form Responses badge. Click Edit Endpoint, the button with a rocket, on its card.

Step 3

The Configure Data Source window opens. Click the Endpoint tab, the first of the tabs on the right.

Step 4

Under Technical Information, Connection shows FORM_RESPONSES for a UDF built from form responses.

Step 5

Beside Source Data, click Open SD. The button reads Opening... while PaT gets the link.

Step 6

When PaT has the link, it opens it in a new window. If no new window opens, allow pop-ups for PaT in your browser, then click Open SD again.

Step 7

If PaT cannot tell which SD the UDF belongs to, a message at the top of the tab says Unable to generate link: Missing primary link identifier.

Step 8

Open SD is only shown for UDFs built from form responses. Other endpoints have no Source Data line.

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: flatten and transpose dataO muri Hangaia he pūnaha pūrongo

Kei tēnei whārangi

  • Giving new rows a default value
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Taking a Dropdown column's options from an endpoint
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Setting up starting rows
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Locking a starting row: Row level overrides
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Stopping people changing a column: Is editable
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Rows people add when they fill in the form
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Opening the SD behind a form responses UDF: Open SD
  • 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.