InfoPath URL Formula Functions

Introduction

InfoPath has number of inbuilt functions, which can be used for conditional formatting, setting the value to the fields or embedded as an argument to the other functions.

From the various group of functions, we will see here the details of URL functional group.

The URL functional group has the below mentioned items that can be used in formula,

URL Function	Formula	Description
SharePointListUrl	SharePointListUrl()	Returns the SharePoint List URL where the form is implemented
SharePointServerRootUrl	SharePointServerRootUrl()	Returns the SharePoint Server / web application URL where the form is hosted
SharePointSiteCollectionUrl	SharePointSiteCollectionUrl()	Returns the SharePoint Site Collection URL where the form is hosted
SharePointSiteUrl	SharePointSiteUrl()	Returns the SharePoint sub site URL where the form is hosted

For example,

I have a List Form, which is customized with InfoPath under the following list,

http://sharepointsite/sites/infopathsitecollection/subsite/lists/testlist

We will get the corresponding values for each url functions as shown in below table.

URL Function	Value
SharePointListUrl	http://sharepointsite/sites/infopathsitecollection/subsite/lists/testlist/
SharePointServerRootUrl	http://sharepointsite/
SharePointSiteCollectionUrl	http://sharepointsite/sites/infopathsitecollection/
SharePointSiteUrl	http://sharepointsite/sites/infopathsitecollection/subsite/