InfoPath Dev

Hello,

I am using the SubmitToSharePointList tool.  I am wondering if it is possible to submit a link to the list that links back to the form so that if someone is looking at the list of items, they can click on one of the fields and open the original form, which will reside in a library in the same site.  

 Hi - if you know the name the form will be using on submit and the URL of the library (in InfoPath 2010 there are some new functions available for that), absolutely. I would add a field that uses a calculated value to store the URL, and have a hyperlink column in the list that it submits to.

Fantastic!  I created a hidden field in the form called linkToForm and added this formula to it: concat(SharePointListUrl(), "ARPD-", arpdNum, ".xml")   which concats the link of the list to the assigned form name.  Then submitted it to the hyperlink column in the list and it works great! 

I have one more question though.  Is there anyway to have something else show besides the actual link in that column?  For example, when we create hyperlinks, we hide the link behind text to click on so is there any way that you know of that I could have something like "View Form" instead of the whole link displayed?  It just looks better  :o)

 Thanks so much for the fix!  

 Yup - and I was going to mention it, but didn't want to start making stuff too confusing. :)

You want the url, a comma and space, and then the text for the display. Basically, you want to submit:

http://myformurl.xml, View Form

So, you'd add to your concat:

concat(SharePointListUrl(), "ARPD-", arpdNum, ".xml, View Form") 

Currently I don't have the SubmitToSharePointList set up and I was simply testing it by manually pasting the form generated url into the hyperlink field.  when I manually type , View Form at the end, it doesn't work, but I will try it again while actually submitting it with the service and see if it behaves differently.

You can also achieve a similar effect, without hidden fields, if you create a Sharepoint Designer workflow and create the hyperlink in the workflow. You just need a library column to show it, no need for property promotion for updates or when published to more than one location.

The workflow could be activated on-new-item create and even item-change (if you allow filename updates).

Using this approach will also work when you are uploading other documents or forms, not specifically designed with self-describing link.

It could also allow you to dynamically change the preview text of the link depending on the publishing location, approval status, etc.

ah ha..never mind.  I realized that for a hyperlink column, the description field that dispays below it in edit mode will actually override how the hyperlink displays.  So when I typed View Form in the description, that appeared in place of the actual hyperlink, but the hyperlink was still accessible by clicking on View Form.  So when we submit it with the service, it must identify that anything after a comma is the description. 

Thanks so much for your help as always!

 Let me double check my syntax too - I'll let you know if comma followed by display is incorrect. :)

So you know - I was intending for you to have the hyperlink as a column in your list - I wasn't counting on you having a hyperlink control on your form as well. If that is the case, you may need to map a different field that you don't actually display on the form so you can submit the url, a comma, and the display text - does that make sense?

Great suggestions Den12.  I'll definitely use them!

Actually your original assumption is correct Hilary.  I wanted a hyperlink as a column in my list.  Sorry if I confused you, but what you gave me works great!  Thanks!

 And I just verified with a CAML query testing tool I use that submitting to a hyperlink column in a SharePoint list the URL, a comma, and the display name works as anticipated. :)