In this post we will discuss about an an easy way to implement an autocomplete column for a SharePoint list using SPService. The SPAutocomplete lets you provide values for a Single line of text column from values in a SharePoint list. The function is highly configurable and can enhance the user experience with forms. To use this function you have 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.
Read some SharePoint tutorials
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 which employees we already have and how these are spelled.
Follow below steps:
Edit the page in the browser and add a Content Editor Web part, modify the web part and show the Source Editor to add below code some code.
sourceList: “Microsoft employees”,
For all available options to set please take a look at the below 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
The result will come like below:
Hope this article will be helpful.