InfoPath Dev

 Hello

in my info path form I have a repeating table that is connected to a share point list as a secondary data source. in SharePoint list there is a calculated column that actually acts as hyperlink with below tag:

( ="<a  href='http://www.3isco.local/_layouts/15/FormServer.aspx?XmlLocation=/DocRevNPEP2/"&[Doc No]&"-"&Rev&".xml&ClientInstalled=true&DefaultItemOpen=1&Source=http%3A%2F%2Fwww%2E3isco%2Elocal%2FDocRevNPEP2%2FForms%2FAllItems%2Easpx"&"'>"&[Doc No]&"</a>")

 

now according to attached picture in repeating table shows Text instead of hyperlink, how i can show this link as a hyperlink also in infopath.

 

Regards,

Masoud

 

 

 

 

 

I think you could just insert a hyperlink from the "Insert" menu and then pick that field for the value. EDITED - I see that the tag is part of the value, you may have to tidy that up a bit. Perhaps you could add a rule on the secondary data source to do that. Just include some field you don't need in the secondary data source, like "version" and after the data source loads, set "version" to a value like "0" - and have a rule on version to clean up that URL field, using substring-before and substring-after. Let me know if you need a hand and I'll set up a sample.

Thanks Hillary, by using insert a hyperlink from the "Insert" menu and concat function and fields in secondary data source i made hyperlink field. but i am not sure 100% is correct, or no? I like to understand your solution. when we made a field like version it acts as a indicator? but I do not know how i have to say in InfoPath when secondary data source loaded, set version to "0". please a bit explains about the reason another extra field like version is necessary and setting the value and then creating a rule on this field. Regards, Masoud

If the concat function did the trick, no need to use my approach. My use of an extra field in the secondary data source was simply because it looked to me like your SharePoint data was not going to work in this situation. I have to make a lot of guesses when I can't see the form - sometimes I guess wrong.