vLookup Search

Forums vLooup for SharePoint vLookup Search

This topic contains 1 reply, has 2 voices, and was last updated by  Alexander Bautz 5 months ago.

  • Author
  • #23611

    Bob Hornak

    Hi Alex,
    Would it be possible add search ability to vlookup? Something similar to the default search box on a list view would be convenient when you have a large number of child items.

    Thanks again for all you do!

  • #23618

    Alexander Bautz

    You can add it with some Custom JS. This example highlights the matched items.

    Add this to your Custom JS

    function highlightMatches(elm, fin) {
        var sVal = jQuery(elm).val(), container = jQuery("#vLookup_" + fin + "_" + spjs.dffs.data.thisItemID).find(".vLookupTable");
        if (sVal !== "") {
            container.find("tr").each(function (i, tr) {
                if (jQuery(tr).text().match(sVal) !== null) {

    Then add this to the Custom CSS


    Then add this to a HTML section above the vLookup field
    Change “vLookupTasks” to match your vLookup field name:

    <div style="margin-top:3px;">Search for matching items: <input type="text" id="vLookupSearchField" onkeyup="highlightMatches(this,'vLookupTasks')" /></div>

    Let me know how it works out.


You must be logged in to reply to this topic.