<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Newbie Questions</title><link>https://www.infopathdev.com:443/forums/39.aspx</link><description>New to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Referencing a relative cell in a repeating table using Current() function</title><link>https://www.infopathdev.com:443/forums/thread/107394.aspx</link><pubDate>Mon, 18 Jul 2016 02:41:59 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107394</guid><dc:creator>edgfox</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107394.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=107394</wfw:commentRss><description>Thanks Hilary. You pushed me in the right direction. I was unaware of the problems with having the link in secondary data. I ended up creating another column which was a Computed Column with a formula concatenating the necessary columns. Seems to be working quite well. 

Appreciate the help on the matter. 

Ed</description></item><item><title>Re: Referencing a relative cell in a repeating table using Current() function</title><link>https://www.infopathdev.com:443/forums/thread/107355.aspx</link><pubDate>Wed, 13 Jul 2016 15:16:05 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107355</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107355.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=107355</wfw:commentRss><description>Oh. Your repeating table is a secondary data source. Your hyperlink is bound to a field in your main data source. You&amp;#39;ll see on the control a message that the control can&amp;#39;t correctly repeat in its current location. Your secondary data connection uses DBXL - are you querying a SQL table or a view? Personally - I would query a SQL view and add the formula for the hyperlink to the view. Then from the &amp;quot;Insert&amp;quot; menu in InfoPath, you can add a hyperlink (not a hyperlink control) to the repeating table, with the DocID for the display, and your new hyperlink field for the link. Does that make sense?</description></item><item><title>Re: Referencing a relative cell in a repeating table using Current() function</title><link>https://www.infopathdev.com:443/forums/thread/107349.aspx</link><pubDate>Tue, 12 Jul 2016 23:14:11 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107349</guid><dc:creator>edgfox</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107349.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=107349</wfw:commentRss><description>Hi Hilary, 

Thanks for the response. I believe I have attached the form. So the &amp;#39;Doc&amp;#39; column needs to be a hyperlink to the actual document on SharePoint. The Document name is made up of &amp;quot;Doc ID&amp;quot;, &amp;quot;Emp ID&amp;quot;, and &amp;quot;Emp Name&amp;quot;. I have created a default value on the hyperlink, however it is not referencing the relative cells in that row. It defaults to the first row or to blank. I hope that is clear... 

Thanks,</description></item><item><title>Re: Referencing a relative cell in a repeating table using Current() function</title><link>https://www.infopathdev.com:443/forums/thread/107336.aspx</link><pubDate>Mon, 11 Jul 2016 23:08:46 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107336</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107336.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=107336</wfw:commentRss><description>You shouldn&amp;#39;t have to use current to concat fields in a repeating group - if the field with the formula is also in the repeating group. Can you attach your form under the Options tab in a reply so I can see what you are doing?</description></item><item><title>Referencing a relative cell in a repeating table using Current() function</title><link>https://www.infopathdev.com:443/forums/thread/107315.aspx</link><pubDate>Thu, 07 Jul 2016 23:10:22 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107315</guid><dc:creator>edgfox</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107315.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=107315</wfw:commentRss><description>Hi, 

I am creating a hyperlink column in a repeating table which is generated by a concatenation of cells in the relative row. From what I can find online, the function required is the &amp;#39;Current()&amp;#39; function, however it is not working. It either continues to return blanks or returns just the first row of the repeating table. Columns A, B and C are all secondary data. 

So columns: 

|            Hyperlink       |   A   |    B    |    C   |
|   concat(A1, B1, C1)  |  A1  |    B1  |    C1  |
|   concat(A2, B2, C2)  |  A2  |    B2  |    C2  |
                 ....                ...        ...      ...
etc.

Any assistance would be appreciated. 

Ed.</description></item></channel></rss>