Add Hyperlink to table cell content dynamically

[Former Community Member]

Hello,

          I have a xdp form created in Livecycle designer. We populate a table by dynamically merging XML to this xdp form uing livecycle FormServices.

For example:

the XML:

<data>

<person>

     <name> George</name>

     <age>11</age>

</person>

<person>

     <name> John</name>

     <age>30</age>

</person>

</data>

populated in table of pdf:

Name	Age
George	11
John	30

How do I add the hyper link to "George", "John" programmatically, so it can be link to some other URL.

Thanks,

Joanna

[Former Community Member]

How are you going to know where to link to? Is that held in the XML somewhere?

Paul

[pampet]

I am looking to do this exact same thing.  My URL is stored in the XML file that I am grabbing the other data from, but it is not connected to any field in the form.  How do I assign the URL as a hyperlink from text in one of my fields (in her example, the name in the first cell of each row)?

[Former Community Member]

Yes... The URL will be constructed using information in XML.

I tried to wrapped <a href="http://somelink.com">Gorge</a> , but it did not work.

[pampet]

So my table is like this:

Product	Price
Apples	1.29
Oranges	2.49
Grapes	1.99

and my XML is like this:

<

Product ProductType="Apples">

<URL>www.apples.com</URL>

<Price>1.29</Price>

</Product>

<

Product ProductType="Oranges">

<URL>www.oranges.com</URL>

<Price>2.49</Price>

</Product>

<

Product ProductType="Grapes">

<URL>www.grapes.com</URL>

<Price>1.99</Price>

</Product>

What I want to do is populate the table from the XML file, and make the URL element be linked from the product name (Apples for instance) at runtime  when I fill the table.  Any ideas?

[Former Community Member]

One more clarification ...is Apples supposed to link to Appes.com or are you simply striping Apples fro the link to populate the name?

Paul

[pampet]

The links I put in the XML example would link up with their "ProductType" name.  So in the example, Apples would link to www.apples.com.  But that link could be anything, I just was using that as a (poor) example.  Apples might link to www.google.com or www.cnn.com.  The words are just the same because I was being unoriginal.

[Former Community Member]

Sorry for the delay I have been having machine problems .....now back to normal.

I created a sample for you. I included the sample file and the xml I used. I bound the URl to the tooltip property then used that in an instruction on the enter event of th efield to actually perform the link. If you use the tooltip property then we can use another bindable property to accomplish the same thing. Have a look and let meknow what you think. Just preview the file and put this XML fiel in the Form Properties/Preview and it will merge the data and template together for you.

Paul

[pampet]

Well, I'd love to tell you what I think but that file has been in the "QUEUED" status all day.  I'll let you know once I can get to it.  Thanks for the effort either way!

[pampet]

That does exactly what I wanted it to do -  in a way I would have never thought to do it!  The only thing I don't like is that it doesn't seem to recognize it as a URL (the cursor doesn't change at all to indicate you're on a hyperlink object).  Once I figured out how to turn on the dynamic properties (Tools > Options > Data Binding) it was really easy to set up.

Thanks!