Fields Autocomplete For SharePoint 2010 Using jQuery SPServices

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.