Qdabra qRules

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Hilary Stoupa — Fri, 03 May 2013 19:31:05 GMT

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. :)

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Deeayrian — Fri, 03 May 2013 19:31:00 GMT

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!

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Deeayrian — Fri, 03 May 2013 19:28:37 GMT

Great suggestions Den12. I'll definitely use them!

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Hilary Stoupa — Fri, 03 May 2013 19:26:12 GMT

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?

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Hilary Stoupa — Fri, 03 May 2013 19:22:45 GMT

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

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Deeayrian — Fri, 03 May 2013 19:18:31 GMT

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!

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Den12 — Fri, 03 May 2013 19:15:15 GMT

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.

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Deeayrian — Fri, 03 May 2013 19:14:59 GMT

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.

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Hilary Stoupa — Fri, 03 May 2013 18:53:17 GMT

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")

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Deeayrian — Fri, 03 May 2013 18:45:50 GMT

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!

Re: Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Hilary Stoupa — Fri, 03 May 2013 14:38:20 GMT

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.

Ability to link to form from Sharepoint List using SubmitToSharePoint List Tool

Deeayrian — Thu, 02 May 2013 20:31:05 GMT

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.