Follow

Adding & Updating Multiple Records

In PPO, you have the ability to either Copy a single record from the Entity View page or Add, Update, and Copy multiple records.

Sometimes it is more convenient to update multiple records at the same time, for example if you want to update the status of issues, update task progress percentages or re-assign multiple issues. 

On all list pages you can see the additional actions that you can perform by clicking on the Actions menu.

The risks entity has been used in this article as an example, but the principles can be applied to all entities.

In the below example, no project or risk filters have been applied and non of the records have been selected, therefore you only have the option under Actions to select Edit.  Delete & Move are greyed out as well as the View Project action button.

mceclip0.png

When you click on Edit without selecting any records, you will have the ability to add multiple records.

mceclip1.png

In the example below, to edit multiple risks, first select the records you want to edit by clicking on the checkboxes in the first column or clicking on the checkbox at the top of the column to select all records. Next click on the Edit option from the action menu.

mceclip2.png

The Risks Edit page will open.

mceclip3.png

Note that the items shown on the Risks Edit page will be the items that were selected on the previous step. 

By default, the fields on the list page are displayed as columns on the Risks Edit page. You can however change the columns that are shown by clicking on the Show / Hide List Columns button in the top right hand corner of the page.

mceclip4.png

If you deselect all columns, it will revert to the default list columns configured for the instance. 

To edit a record, simply click on the record you want to edit and make the required changes. 

mceclip5.png

To add a new record, click on the Add (+) button at the bottom of the multiple edit page.

mceclip6.png

Note that in the case of projects, you will only see the add and copy buttons if the Project Code field on your instance is calculated. If the Project Code field on your instance is not calculated, you can request for it to be made calculated by logging a ticket with the support desk.

If you click on the Add button and do not currently have all required columns selected, a message will pop-up as below. This is to ensure that all required information is captured when you add a record.

 mceclip1.png

To copy an existing record, first select a specific line and then click on the Copy button at the bottom of the multiple edit page as per the screenshot below:

mceclip7.png

A copied line will be displayed, with the information of the previously selected line. You can then change only the fields that are different.  This is useful for example, where you have to create a record for every month of the year, or you want to assign the same item to multiple users.

Please note that when using the copy functionality, all column values will be copied, not just those shown.

Once all changes have been made, click on the Submit button to return to the Risk List page.

Important: When adding or editing multiple items it is easy to lose track of time.  If you take longer than one hour, your session will have expired and you will be logged out of PPO and you will lose your changes.  Therefore, make sure that you submit your progress frequently.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request
Article is closed for comments.
Start a 30 Day Free TrialClick ClickNo Credit Card and No Obligation
Powered by Zendesk