Fields Autocomplete For SharePoint 2010 Using jQuery SPServices

Posted: July 13, 2014 in SharePoint2010

Introduction:

The SPAutocomplete lets you provide values for a single line of text columns from values in a SharePoint list. The function is highly configurable and can enhance the user experience with forms.

To use this function you need to put it on a new item form. On one of the fields of this new item form the SPAutoComplete can be implemented and used.

To make this work, create a new blank webpart page. Open the page in SharePoint Designer and insert a dataview on the page. At the Data Source Library select the list you want to create a new item form for and select Show Data. Select the desired fields to show on the new item form and select “Insert Selected Fields as … New Item Form”.

Imagine:

I have a list called Microsoft employees with a Title column with the name of the employees. In another list I need these names also but I want to suggest the user who adds a new item that employees we already have and how these are spelled.

Let’s proceed:

Edit the page in the browser and add a Content Editor Web part, modify the web part and show the Source Editor to add the following code.

<script language=”javascript” src=”/JS/jquery-1.6.2.min.js”
type=”text/javascript”></script>
<script language=”javascript” src=”/JS/jquery.SPServices-0.7.2.min.js”
type=”text/javascript”></script>
<script type=”text/javascript”>
$(document).ready(function () {
$().SPServices.SPAutocomplete({
sourceList: “Microsoft employees”,
sourceColumn: “Employee”,
columnName: “Employee”,
ignoreCase: true,
numChars: 2,
slideDownSpeed: ‘fast’
});
});</script>

For all available options to set please have a look at the following link, but for the important ones here.

http://spservices.codeplex.com/wikipage?title=%24%28%29.SPServices.SPAutocomplete

  • sourceList: the list to get the suggestions from
  • sourceColumn: the static column name to get the suggestions from
  • columnName: the displayname of the field in the new item form

Fields Autocomplete for SharePoint 2010

Summary:
In this article we provided an easy way to implement an autocomplete column for a SharePoint list using SPService.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s