Fields Autocomplete For SharePoint 2010 Using jQuery SPServices

Posted: August 15, 2014 in SharePoint2010


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”.


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

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

  • 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


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


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s