PPaT Wiki
DocumentationPathwayForumBlogContact
Week streakFOUNDATION0 badges
Language: English
  • English
  • Nederlands
  • Français
  • Deutsch
  • Lea faka-Tonga
  • Te reo Māori
  • မြန်မာ (Burmese)
Ask the community

Your PaT Pathway

0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  • Company Structure: adding a new user
  • Company Structure: customer companies
  • Company Structure: departments, job titles and roles
  • Company Structure: modules for a site or a country
  • Company Structure: process categories
  • Connections: linking PaT to Microsoft 365
  • Forms - API Integration
  • How to create a campaign for the PaT Lite training portal
  • How to edit an existing Bulletin Board Post
  • How to set up your SD Map
  • LMS Feedback: learner ratings and comments
  • LMS Metrics - If you can't measure it, you can't manage it
  • Manage users
  • Pacing recertifications and escalations
  • PaT Business Unit Template Overview
  • SD Workflows - Multi Submit
  • SD Workflows - Workflow Settings
  • System Activity: escalations, logins, emails and more
  • System Config: company settings
  • The org chart
  • Add any Image as a Section Header Icon
  • Assigning an SD to a new parent
  • C2E Attachments
  • Chat reminder
  • Chat to email to chat
  • Chat to SD
  • Chat to task to project
  • Comprehension Audits
  • Customer-specific training: how it works
  • Different Form Uses
  • Docked Chats
  • Docking SDs and Updating Images
  • Email to BFF
  • Email to chat to email – non PaT users
  • Embedding live data in an SD (graphs and spreadsheets)
  • Embedding SDs in SDs
  • Evidential audits: completing one
  • Filing and retrieving SDs
  • Form Wall
  • Health and safety templates
  • How PaT Manages Inactive Users
  • How SD chats work with SD Members and External Users
  • How to unlock a module for a staff member
  • Info Icons
  • Inline chats
  • Invite Attendees
  • LMS Architecture
  • Moving Section Headers
  • Multi-Tasks
  • PaT AI
  • Pop-Out Chat Feature
  • Recurring tasks: create and edit
  • Running Meetings with SDs
  • Safe Walks
  • SD Element Categorisation
  • SD Form Responses: finding and exporting form responses
  • SD Owner Functions
  • SD Task wall view
  • Share and record your screen
  • Task Integrity: what it is and why it drops
  • Track Engagement
  • Using SDs as a report or meeting minutes app
  • Video rooms: guests joining and asking to record
  • Activity Notifications
  • Add members and set permissions
  • AI Summary: a quick summary of an SD
  • Capture and Manage Accidents
  • Capture and Manage Hazards
  • Chat to task
  • Chat Wall
  • Company wiki: searching your company's own modules
  • Contextual Communication
  • Convert a Note to a Task
  • Create a new SD
  • Create a Task
  • Critical Chrome Extensions
  • Document Store: shared links, your folders and favourites
  • Fast Notes
  • Getting help: the PaT Helpdesk
  • Global Search
  • Group Chats
  • How to embed Outlook onto your PaT
  • How to resize your browser to best view PaT
  • How to use the PaT Lite training portal
  • Insert links
  • Module Learning - Desktop
  • Module Learning - Mobile
  • My Profile
  • Newbie PaT Intro – Chats and SDs
  • Notes
  • Out Of Office: turning it on, and the calendar on your Task Wall
  • Outlook 2FA Issue
  • PaT Chat Overview
  • PaT Mobile App – Overview
  • PaT service status: the status page, status alerts and status notices
  • PaT Wiki: finding your way around
  • PaT Wiki: searching, the AI answer and rating it
  • Preview, download and share files
  • Publish a Bulletin Board Post
  • Reading an SD in another language
  • Release-note alerts: a Sys Bot chat when PaT's release notes change
  • SD Elements
  • SD Main page useful features
  • SD Overview
  • Section Headers
  • Security measures for multiple users on a device
  • Share Feedback
  • Signing in to PaT and resetting your password
  • Signing in with MFA: the second step
  • Task Management
  • Task Management System
  • Task Wall
  • The connection icon on your PaT desktop
  • Traffic light progress
  • Upload file attachments
  • Video calls on the mobile app
  • AI Playbook: checking for other tickets with the same number
  • Auto Escalation
  • Build a reporting system
  • Calculated fields and calculated columns
  • Charts: options for lines, bars, axes and single values
  • Chat Management - Pro Tips
  • Conditional Formatting
  • Configuring a UDF: columns and calculated columns
  • Configuring a UDF: filters, grouping and endpoint details
  • Customer-specific training: setting it up
  • Data sources: stage filters, dynamic dates and page values
  • Endpoint Manager: finding endpoints and building your own UDF
  • Form builder: field types
  • Form Builder: layout at each screen size
  • Form Builder: tools and shortcuts
  • Form buttons, PDFs and what happens after submit
  • Form fields: defaults, read-only and other settings
  • Form Test Mode
  • Forms - Extract Data (the AI form builder)
  • 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
  • How managers can turn on OOF for their staff
  • How to build modules in the Module publisher
  • How to create module comprehension audits
  • How to create module evidential audits
  • How to create module quizzes
  • How to embed an SD into the LMS
  • How to make form templates live for everyone to use
  • How to upload form elements to an SD
  • How to use the PAR SD
  • Live H&S Reporting
  • Mastering the Business Strategy Template
  • Module Admin: finding and managing modules
  • Module Completion Notification Setup
  • Module Publisher Content Options
  • PaT SD Map Overview
  • PaT SD Map Presentation
  • PaT SD Templates Overview
  • Playbook Admin: the tickets behind each Quality and Cost category
  • Playbook Admin: when your shadow run is ready to review
  • Playbook editor: adding a portal lookup step
  • Playbook editor: adding a step that cancels an order
  • Pure Forms
  • Required fields, validation and containers
  • Rich text, file uploads and speech to text
  • SD Dashboard: building a dashboard
  • SD Forms
  • SD Security Settings
  • SD Template Helper Functions
  • Stacked views, flip cards, tabs and stages
  • Strategy System
  • Throttling
  • Using Chat to SD to go from being a good manager to a great one
  • Using SDs as the LMS Document
  • PaT Lite: Key aspects of PaT you need to understand
  • What is PaT and why it matters
  • PaT Lite: Chat to Task
  • PaT Lite: Introducing Strategy Documents
  • PaT Lite: Core Philosophy - Standards and Tactical Execution
  • PaT Lite: Intelligent tools that think with you
  • PaT Lite: The Future of business is Culture
  • Security
  • Integrations
0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  1. Documentation
  2. Advanced
  3. Grids: rows, default values and editing rules

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

Checking your PaT sign-in…

How To

On this page
  • 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…

PreviousGrids: flatten and transpose dataNext How managers can turn on OOF for their staff

On this page

  • 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

Documentation, knowledge base and community support for People and Tasks.

Documentation

  • Getting started
  • Core concepts
  • Integrations
  • API reference Coming soon

Support

  • Knowledge base
  • Release notes
  • Community forum
  • Contact us
  • Service status

Company

  • PaT
  • Blog
  • Terms
  • Privacy

© People and Tasks. All rights reserved.