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.
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.
You May Also like the Following SharePoint Online Tutorials: