hyperlink custom text field

Question

Hi all,

I am trying to automate a report from MS Project plan converted into pdf file.

One of the Task level view custom text field needs to have a milestone issue # association. This issue id subsequently points to an external web link.

Each of the issue id has respective static weblink, with only difference being the issue id for the respective issue..

Question is: Can I transport this issue id (manually entered into the task custom text field) into the weblink parameter and open the webpage once clicked thro the pdf schedule format?

Process : User enters Issue id into Task custom field. --> Automation converts this id into a hyperlink, specific to the ID. --> User click on this custom field thro a pdf format of the schedule ---> System opens the hyperlink in a separate window.

Any advise on this feasibility for automation?

Answer 1

We need an extra parameter (Number1 field) to help us with differentiating the formula for Task A, Task B, Task C and so on, since Project allows us to enter only a common formula for all the task lines. It does not work like Excel.

Number1 field's value is 1 for Task A,  2 for Task B and it is 3 for Task C...

I'll use Text1 field as hyperlink field with the formula below:

choose( Number1,

"http://www.companyabcsharepoint.com/" & switch(Instr(Text3,"Value_4"),"Value_4_A",Instr(Text3,"Value_5"), "Value_5_A",True,"-No Value-") & "/project",

"http://www.companyabcsharepoint.com/" &

switch(Instr(Text3,"Value_2"),"Value_2_B",Instr(Text3,"Value_4"), "Value_4_B",True,"-No Value-") & "/project",

"http://www.companyabcsharepoint.com/" &

switch(Instr(Text3,"Value_2"),"Value_2_C", True,"-No Value-") & "/project"

)

Hope it works in your case.

Regards.

Answer 2

Hi MCC,

Here are the scenarios:

1. Task A - Text field 3 - Value: 4, 5
2. Task B - Text field 3 - Value: 2, 4
3. Task C - Text field 3 - Value: 2

Hyperlink field (whichever we can pick from the custom field configuration) should open up specific URL, which will be different for each of the 3 tasks above.

1.

For Task A above, hyperlink should open 2 different web pages (each having a different parameters passed for value 4 and value 5 respectively).

Task A - for value 4 - www.companyabcsharepoint.com/**4**/project

Task A - for value 5 - www.companyabcsharepoint.com**/5**/project

2.

For Task B above, hyperlink should open 2 different web pages (each having a different parameters passed for value 2 and value 4 respectively).

Task B - for value 2 - www.companyabcsharepoint.com/**2**/project

Task B - for value 4 - www.companyabcsharepoint.com**/4**/project

3.

For Task C above, hyperlink should open based on the parameter value of 2 passed into the URL).

Task C - for value 2 - www.companyabcsharepoint.com**/2/**project

 Pls let me know if you need any additional clarification.

Answer 3

I believe the logic works in that case too. If you can provide some examples of the field values, I'll try to build the hyperlink string. --Regards.

Answer 4

Hi MCC,

I agree to your resolution. Unfortunately, we are trying to pass dynamic parameter from another field into the hyperlink so that the link is specific to the parameter passed.

All other strings in the link remains the same.

Rgds,

Answer 5

I've just tried the following and it works...

Hyperlink field contains: C:\x.xls (I suppose you are going to create the reference manually)

Text1 field contains the formula: "file:///" & [Hyperlink]

Then I've generated a pdf file.

When I click on the link that Text1 contains in pdf file, Excel opens x.xls. I hope it works in your case.

Regards.