Create a Hyperlink in a Configured Field

You can create formulas in configured fields to generate hyperlinks. This is useful because hyperlinks can sometimes be lengthy, and a configured field can make hyperlink creation automatic as the user enters text. See Configured Fields Overview.

The following example contains a formula that generates a hyperlink to an external site inside a configured field when the user inputs the activity name "Design Review" in another field in the Activities page:

To create a hyperlink using a formula in a configured field:

1. Navigate to the Activity configuration page
   1. In the object selector, select  Workspace, select View Workspaces List, and then select a workspace name.
   2. From the  Main Menu, select  Summary & Settings.
   3. On the Summary & Settings page, select Defaults & Options, and then select Activity.
2. Select the Configured Fields tab.
3. To create a configured field, use the table to complete the following fields:
   1. Select  Add.
   2. In the Column Label, enter a column label, such as Spec_1.
   3. In the View Column Name column enter Spec 1.
   4. In the Data Type column, select Text.
   5. In the Type column, select Formula.
   6. In the Summary Calculation column, select None.
4. Use the Formula detail window to define a formula specific to your needs. See Primavera Cloud Language Expression Guide for more information about creating custom formulas for configured fields and measures in Oracle Primavera Cloud.
   1. Use the formula editor to create your formula:

      if (object.Activity_activityName =='Design Review') {

      ("www.specdesignexample.com")

      }else {

      (null)

      }

   2. When an activity name on the Activities page matches "Design Review", the application auto-populates the project specification design site link into the configured field "Spec 1" that contains the formula you created.
5. Select the link to open the corresponding URL page in a separate browser tab.

   Note: Hyperlinks are not functional in detail panels or pop-up dialog boxes.

Tips

• When you download a grid page as an Excel compatible file, all customized and visible columns, rows, and contents, including hyperlink functionality, will download as displayed in the grid, with the exception of secure ftps:// sites, which will be in plain text.