Follow

How can I create a link from one entity record to another entity record?

Creating links in PPO
It is sometimes required to create a link from a specific record in one entity, such as an Issue, to a specific record in another entity, such as a Risk. This can be done in PPO by implementing a calculated field. For more information on calculated fields, see the following FAQ.

In the example of an Issue linked to a specific Risk, the steps to implement would be as follows:

Step 1: Implement a reference field
This will be a number field (because key’s are numeric) implemented on the Issues entity (entity from which the link will be implemented) containing the reference number or key of the Risk to which the Issue pertains. This should be implemented as a manual field (i.e. not calculated) and will also be non-required as not every Issue will relate to a Risk.

FAQ_link_step1.png

The user will manually add the risk reference number or key into this field, should it be applicable.

Step 2: Implement the link field
This step will implement a link field which will take the user to the correct Risk record directly from the Issue. Implement a URL data field, tick the calculated box and enter the PPO field name in the formula box.

FAQ_link_step2.png

The PPO field name can be found in the URL when viewing the data field (as illustrated above) or in the Data Fields List page (as illustrated below).

FAQ_link_step3.png

Step 3: Create sample records
In order for the technical team to implement the calculation in the link field, sample records need to be set up. Also provide the technical team with the expected mapping between entities (i.e. which Issue you expect to link to which Risk).

Step 4: Log a support call
Lastly, log a support call requesting the PPO Support Team to add a calculation in the calculated field (provide the field name) linking it to the Risk record with the corresponding reference number (provide the key of the reference number on both entities).

Once implemented you will be able to click on the link in the Issues entity and be taken to the corresponding Risk.

                                                                                     faq_relatedrisk.png

 

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