Tuesday, February 7, 2012

SharePoint AutoComplete Lookup Field with JQuery

I have Created a Custom SharePoint Lookup field that offers new functionalities to default SharePoint lookup field by allowing Auto Complete or Type Ahead search functionality with Contains CAML query.

Below is a few of the features offered by AutoComplete Lookup field over standard SharePoint Lookup field:
  • Auto Complete or Type Ahead lookup search (queries after each typing)
  • OTB SharePoint Lookup Dropdown look and feel for the results
  • Proper validations
  • Searches the lookup keyword with Contains CAML query
  • Configurable for No.of results to be displayed
  • Configurable for No.of characters to start the auto complete search

With few limitations:
  • It cannot be multi-valuated
  • Only one AutoComplete Lookup field is allowed per list
  • The target lookup field is frozen and always the Title field
The AutoComplete Lookup Field Solution (as SharePoint Solution installer) and Source Code are available for download at my CodePlex project SPAutoCompleteLookup.


8 comments:

  1. Can this can be used to lookup up the typed value anywhere in the field instead of always starting at the first character?

    Thanks,

    --

    J. Reinoso

    ReplyDelete
  2. Yes, why not, it searches for any typed value in a field value as CONTAINS condition is used in CAML. Note that CONTAINS looks for a part of the string match and not starting match.

    ReplyDelete
  3. Thank you so much, this is what I was looking for. I have a pretty long source list and this way we are going to be able to lookup really nice.

    Regards,

    --

    J. Reinoso

    ReplyDelete
  4. I'm installing the package into my server, I have WSS 3.0 but no MOSS, the installation stops because of this, is there a way to install it on my system ?

    Thanks,

    --

    J. Reinoso

    ReplyDelete
  5. when i installed it the auto complete lookup column isnt there

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. Hi,
    Can this be deployed as a sandbox solution?

    ReplyDelete
  8. Hi
    When the source column is selected from the dropdown can we link it to actual list item? If user wants to see more detail user will click on the link.

    ReplyDelete