SharePoint 2010 Autocomplete Lookup field allows type ahead functionality while looking up values from the lookup list. It uses REST for specifying filters.


The source code and wsp of the project is available here.


Deployment steps:
Adding Solution:
stsadm.exe -o addsolution -filename C:\NY.Autocomplete.LookupField.wsp


Deploy Solution:
stsadm.exe -o deploysolution -name NY.Autocomplete.LookupField.wsp -immediate -allowgacdeployment


Usage:
Consider a list named Company with following fields:
Title: consisting of names of companies
Active: Yes/No
Create a custom list named Employee and add create a column of type Autocomplete Lookup Field in it as shown:


In the REST Filter specify the following filter: and Active eq true
This will make sure that only those companies show up which have Active set to Yes.
Following image shows the results while using the Autocomplete Lookup column

Issuses you may face while using Autocomplete:




7 comments

  1. Jenine W // 24 April 2012 08:30  

    We installed this add-on but when we try to display more than one field, the field never shows in the view, nor on the list settings.

  2. Nadeem Yousuf // 24 April 2012 23:38  

    I don't see this issue. You can add as many fields of this type as you like in the same list.

  3. Mark Morgan // 10 April 2014 06:57  

    Is this supposed to work with Sharepoint Foundation 2013, if so, it doesn't work.

  4. Mark Morgan // 10 April 2014 07:02  

    Tried this on Sharepoint Foundation 2013, at first it didn't work, then it did, I have absolutely no idea why. Oh Joy! Anyway Thank you for providing this, it has saved my bacon :)

  5. Nadeem Yousuf // 10 April 2014 08:43  

    Good to hear that.

  6. Cristian Amadio // 12 September 2014 06:18  

    I also tried it on SP foundation 2013 but it doesn't work... Have you found the reason why it works on your server?

  7. Cristian Amadio // 12 September 2014 06:24  

    Have you a support page for this custom control? on our SP 2013 Foundation the field appears on the form but the auto-complete function does not work...

My SharePoint CodePlex Projects

SharePoint 2010 Autocomplete Lookup Field

Export Version History Of SharePoint 2010 List Items to Microsoft Excel.