Monday, January 19, 2015

Creating dynamic hyperlinks

How to create dynamic hyper links in Oracle Primavera Unifier

Step 1: Create Hyperlink Element

  1. Go to Data Structure Setup > Data Elements
  2. Click New
  3. Set Data Definition Source to Hyperlink Picker
  4. Click OK


Step 2: Create String Element for Hyperlink Label

  1. Go to Data Structure Setup > Data Elements
  2. Click New
  3. Set Data Definition Source to Sys Short Description Text 250
  4. Set Name Hyperlink Label
  5. Click OK

Step 3: Create String Element for Hyperlink address

  1. Go to Data Structure Setup > Data Elements
  2. Click New
  3. Set Data Definition Source to Sys Short Description Text 250
  4. Set Name Hyperlink address
  5. Click OK

Step 4: Create String Element for Hyperlink address base

  1. Go to Data Structure Setup > Data Elements
  2. Click New
  3. Set Data Definition Source to Sys Short Description Text 250
  4. Set Name Hyperlink address base
  5. Click OK

Step 5: Add link to Form 

  1. Go to a Form in uDesigner.  
  2. Select an empty field
  3. Click Custom
  4. Selected created element in step 1, step 2, step 3, step 4
  5. Click save

How hyperlinks work

Hyperlinks are two parts, the first part represents the address, the second part represents the display name of the link.  The two are separated by a space.  So in the database it looks like "http://link.com Link Name"(<hyperlink> <label>). So when you use a formula, you need to create two elements, one to hold the hyperlink address, and another to hold Hyperlink label.  When you add the two in a formula, you just separate them with a space, and you have a hyperlink.  

Step 6: Configure hyperlink address base

  1. Click Properties
  2. Select hyperlink address base
  3. Click Auto-Populate
  4. Set source name to Constant Value

Step 7: Configure hyperlink address 

  1. Click Properties
  2. Select hyperlink address 
  3. Click Formula
  4. Select hyperlink address base
  5. Click Add Parameter
  6. click ()
  7. Add field that has parameter (option)
  8. Click OK

Step 8: Configure hyperlink label

  1. Click Properties
  2. Select hyperlink label
  3. Click Auto-Populate
  4. Set source name to Constant Value
  5. Set value to whatever  you want the link to say.  

Step 9: Configure hyperlink 

  1. Click Properties
  2. Select hyperlink
  3. Click Formula
  4. Change delimiter to Space( ) the one with a space in it
  5. Select Hyperlink Address 
  6. Click Add Parameter
  7. click ( )
  8. Select Hyperlink Label 
  9. Click Add Parameter
  10. Click OK


1 comment:

  1. Thanks very usefull information. Please share more information.

    ReplyDelete