Document Pick List With Hyperlink Returned

[jjenkinsxviii]

We're trying to build a document transmittal form using Infopath 2007 with
MOSS 2007 and WSS 3.0. The form has the standard From/To etc., as well as a
document pick list with a SharePoint library as the data source.

The problem is that I can only select fields ID, Title, Created, and a bunch
of other fields that I do not want. I want to select using the document
"Name", and have a hyperlink to the document returned; the form recipient
could then click the link to open the document.

Document "Name" does not appear to be exposed in the data connection wizard.
Am I doing something wrong here or is there some sort of limitation?

Thanks

John Jenkins

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

You need to add the columns to the default view in the form library from
where you want the data. Only when the Columns are added, they are exposed in
the data connection wizard.

 

[jjenkinsxviii]

Hi Kaylan, I'm not sure I phrased my question properly. We have created an
Infopath form that will act as a document transmittal for documents contained
in another document library. The intent is that someone will fire up the
Infopath transmittal, select multiple documents from this other document
library using a drop-down list in a repeating table, then email the
transmittal which should contain hyperlinks to the selected documents (we
don't want to attach them).

The problem is that we cannot determine how to get the URL of the selected
documents; in the data source I can get plenty of metadata but cannot get the
URL of the document itself. If using a "SharePoint library or list" as the
data source, then selecting any document library, document name and document
path do not appear in the list of fields we can select. I see only ID,
Content Type, Created, etc.

We found a workaround by using an XML datasource based on the document
library; this allowed us to pull the document name, but we still did not have
a linkable URL. If we concatented the document library URL to the document
name we were able to construct a useable hyperlink, but unfortunately this is
an awkward workaround and is unsuitable for documents in folders.

When selecting a document using a drop-down list bound to a document library
data source, is it possible to also get the document's URL?

Thanks