Data fields are used to capture information in PPO. Different types of data fields allow for the capturing of different types of information, for example; dates, numbers, text, drop-down values, currencies and so on.
You have the ability to set default values for all field types with the exception of the consecutive number field. For more information on setting Default Values, follow this link.
This article covers the below data field types and their related front end validation errors:
- Consecutive Number;
- Currency Field;
- Custom List (Single);
- Custom List (Multiple);
- Date Field;
- Decimal Field;
- E-Mail Address;
- Resource List;
- Entity List;
- Free Text;
- Integer Field;
- Percentage Field;
- Programme List;
- Project List;
- RAG Indicator;
- Text;
- URL;
- Yes/No.
Consecutive Number
The consecutive number field type, assigns a consecutive number to each record that is added. The field cannot be edited by the user as it is generated automatically by PPO.
The consecutive number field shows an additional option when added, i.e. to apply the numbering globally or not.
If the numbering is applied globally, the numbers will be awarded consecutively even if the records don't belong to the same project. In the example below, the Issue ID is numbered sequentially, even though the issues belong to different projects.
If the numbering is not applied globally, the numbers will be awarded consecutively only within the project. Each project will therefore have its own number 1; number 2; number 3 and so on. In the example below, the Benefit Number is a consecutive number field that is not being applied globally, therefore each project is numbered independently.
The consecutive numbering field will only be applicable for newly added fields and will not be done in retrospect for records that already exist before the field was added.
Currency Field
A currency field is designed to show cost.
The currency of an instance can be changed by accessing the Administration Menu and selecting System Configuration. The setting for the currency symbol is under the "Other Settings" category. Once the currency symbol is changed, it will also reflect on all applicable reports and dashboards. If the currency field is left blank, it will also reflect blank on all applicable reports and dashboards.
PPO Administrators have the ability to specify the number of decimals for Currency fields. The maximum decimal places allowed is 11.
If decimals or text values are added to a currency field you will see an Invalid number validation error. In the below example you cannot add a "comma" in the field.
Custom List (Single)
A Custom List (Single) type field allows users to select a value out of a pre-defined list. Custom lists can be set up and maintained by the PPO Administrator. For more details on custom lists and how to maintain them, please access the following knowledge base article.
This field type is used where there is a one-to-one relationship, e.g. statuses for work items where a work item can only be in a single status (New, To Do, Doing, Done) or project phases where a project follows the project process (Initiating, Planning, Executing, Closing).
When the custom list field type is selected, a second field will open asking you to select the custom list that needs to be used.
Two additional fields will also open. These fields ask for a dependency and a parent field for the dependency. Dependencies are relationships that can be set up between two or more custom list type fields. These allow the values in one list to be dependent on what is selected in another list.
For more information on setting up dependencies, please access the following knowledge base article
Custom List (Multiple)
A Custom List (Multiple) type field allows users to select multiple values out of a pre-defined list. Custom lists can be set up and maintained by the PPO Administrator. For more details on custom lists and how to maintain them, please access the following knowledge base article.
This field type is useful in scenarios such as selecting multiple strategic objectives that a project is supporting, capturing multiple skills linked to a resource or multiple business units being impacted by a project.
Date Field
Date fields allow dates to be captured. These fields are typically used to capture start and end dates, follow up dates and created dates. PPO allows you to apply Color Styling to date fields that highlight whether an item is overdue or due in the next 7 days.
By selecting Highlight upcoming overdue dates, the data displays as follows:
The calendar control function shows today in blue and public holidays in red. For more information on loading public holidays, please access the following knowledge base article.
Decimal Field
Decimal data fields are used to capture decimal numbers. PPO Administrators have the ability to specify the number of decimals for Decimal fields. The maximum decimal places allowed is 11.
If text values are added to a decimal field you will see an Invalid number validation error. In the below example you cannot add "$" in the field.
E-Mail Address
An e-mail address field is used to specify e-mail addresses. An example is on the resource entity, where the resource's e-mail address is requested.
This type of data field automatically checks the validity of the e-mail address specified by the user, and if the e-mail address is not valid you will see an Invalid email validation error.
Resource List
This type of field allows you to select a resource from a list. It is typically used to indicate responsibility, in other words, to assign a resource to a specific role or responsibility.
The resource list is automatically compiled from all the resources on the resource entity. If a resource is added, they will automatically appear on the resource list type fields.
The ability to apply a filter to the resource list is available as an additional option when adding a resource list type field.
This allows the administrator to define which resources should be available from the resource list by making use of a shared filter. For more information on setting up shared filters, access the following knowledge base article.
Entity List
A entity list field, appears as a drop-down list field and ensures that the user can only select a particular project related entity from the list.
When the entity list field type is selected, a second field will open asking you to select the referenced entity. This field contains a list of all the project related entities on your instance that this can be applied to. The format in which the field will be displayed, depends on the display format that has been setup on your instance.
Further to the entity list field, a filter can also be applied to only reflect the items you require.
You will also notice a “Allow Global Filter Toggling” checkbox. By enabling this, a global filter toggle will appear next to the field allowing the global filter to be toggled on or off. If this checkbox is not selected, the global filter will always be applied. For more information on this functionality, refer to this FAQ.
Finally, you will also see a "Filter by Selected Project" checkbox. By checking this box, the items that will be shown in the list will be limited to the project that you have selected.
Below is an example of how this is used on an agile instance:
The user simply selects the value from the drop-down list instead of manually entering a value in a field. This can also be applied to other project entities for example linking issues and risks together.
If you are interested in implementing this functionality you can also refer to this FAQ.
Free Text
A Free Text field is a multi-line text box which is typically used for narratives, descriptions, comments and feedback. Examples of standard Free Text fields include “Project Description” on projects and “Issue Description” on issues. The screenshot below shows an example of a Free Text field.
A Free Text field can be set so that it is automatically cleared during subsequent updates by checking the “Auto Clear” check box. The reasons for why you would want to do this are detailed in this FAQ. If you do not require this functionality, you can simply uncheck the box.
Integer Field
Integer fields are used to capture whole numbers. Examples of integer fields are Age and Number of days overdue.
If text is specified in an Integer field instead of a number, you will see an "Invalid whole number" validation error.
Percentage Field
A percentage field is used to capture percentage values and shows it in a graphical representation. These fields have 2 options when configuring them: Red for negative values and green for positive values OR Red for negative values, green for values between 0 and 100 and red for values in excess of 100.
The absolute value is also highlighted by showing it as a “progress bar”, allowing you to identify items requiring attention at a glance. Examples of a percentage field would include Planned Progress Percentage, Actual Progress Percentage and Variance Percentage.
PPO Administrators have the ability to specify the number of decimals for Percentage fields. The maximum decimal places allowed on a data field is 11.
Programme List
A programme list is a catalogue of all the programmes registered in the Programmes entity. The programme list field can be used on the Projects entity in order to assign projects to their respective programmes.
The programme list is automatically compiled from all the programmes on the programmes entity. If a programme is added, it will automatically appear on the programme list.
The ability to apply a filter to the programme list is available as an additional option when adding a programme list type field.
This allows the administrator to define which programmes should be available from the programme list by making use of a shared filter.
For detailed information on how to use the Programmes entity, access the following knowledge base article.
Project List
A project list shows all the projects loaded on PPO. This allows users to link a Task, Risk, Issue or even a project to another project. Examples of project list type fields include the project field on the list pages of all project related entities (such as Tasks, Issues, Risks, Benefits, Lessons and so on) and the parent project field on the Projects entity.
The project list is automatically compiled from all the projects on the projects entity. If a project is added, it will automatically appear on the project list.
The ability to apply a filter to the project list is available as an additional option when adding a project list type field.
This allows the administrator to define which projects should be available from the project list by making use of a shared filter.
RAG Indicator
RAG indicator fields can be used to indicate the health of a project or an item. It allows the user a choice between a Red, Amber or Green indicator. The RAG indicator is typically used on the Health Indicators entity and on the Project Health field.
Text
This allows for the capturing of normal text.
When selecting the field type “Text”, the user will be asked to specify a length for the field. This type of text field can be set to a maximum length of 100 characters.
URL
The URL type data field is used to capture external links or webpages (URLs).
After the URL has been specified, a direct link to the URL will be available from the view page.
If you don't specify a valid link, you will see an "Invalid URL" validation error.
Yes/No
A Yes / No field is also known as a check box. It only has two options: Yes and No.
Follow the links for more information on Data Fields and Data Field Settings.