Create hyperlink that uses a value in the shape property?

[tinkertoy]

I have an Organization Chart, that is many pages. The first page being the
main executive staff. In one of the property details of the shape is the
employee's employee ID. I have an interface already built that I can use to
access an employee's photograph. What I need to incorporate into each shape
is a hyperlink that uses the value of the Employee ID field. I know that I
can create more than one hyperlink in each shape, so this is solved. I am
not a expert by no means in Visio, but believe that this can be done in the
ShapeSheet properties, with some code, the hyperlink is good, but need to be
able to pull the value from each shape. I already tried adding a hyperlink
to the shape property field, and posted a question about it, it doesn't work.
I do not want to embed the photo in the OrgChart, with almost 3000
employees, it would be huge!

 

[Al Edlund]

Rona,
where are you trying to hyperlink to ? You mention that the information is
in the shapesheet (a user field, a custom property, ?)
Al

 

[tinkertoy]

We have an asp interface that will use a detail, employee ID, to link/go to
that employee's photograph in another system. The property details of every
shape has an employee ID in it. This was part the orgchart, and a detail,
that a user can view with a ctrl/click in the web version. I know that I can
add more than one hyperlink to each shape, currently a manager from the main
page, click and go to the staff that reports to that manager. Does that
explain it better?

 

[Matt Adereth [MSFT]]

Yes, this is possible through the ShapeSheet.

You can put a formula in the Address cell in the Hyperlinks section of the
ShapeSheet. You can concatenate multiple strings by using the "&" operator.

For example, if you wanted to add a hyperlink that would search the internet
for a string value in a custom property, you could set the Address cell to

="http://search.msn.com/results.aspx?q=" & Prop.Row_1

Similarly, if you had a custom property, say "prop.email" that contains the
person's e-mail address you could create a hyperlink that would e-mail them
by setting the Address cell to

="mailto:" & Prop.email