Drop Down Issue in Lookup Field

Standard

If the look-up field contains more than 20 items it convert to another structure instead of drop-down list. This happens only with IE browser

To get the drop-down back see the following article:
http://sharepointegg.blogspot.com/2010/10/fixing-sharepoint-2010-lookup-drop-down.html

The solution:

I am assuming that you have a reference to the JQuery library in your master page.

<script&gt;
$(document).ready(function () {

// Name of the column (Display Name)
var columnName = “Lookup”;

// Override the Drop Down List
OverrideDropDownList(columnName);

// Main Function
function OverrideDropDownList(columnName) {

// Construct a drop down list object
var lookupDDL = new DropDownList(columnName);

// Do this only in complex mode…
if (lookupDDL.Type == “C”) {

// Hide the text box and drop down arrow
lookupDDL.Obj.css(‘display’, ‘none’);
lookupDDL.Obj.next(“img”).css(‘display’, ‘none’);

// Construct the simple drop down field with change trigger
var tempDDLName = “tempDDLName_” + columnName;
if (lookupDDL.Obj.parent().find(“select[ID='” + tempDDLName + “‘]”).length == 0) {
lookupDDL.Obj.parent().append(“”);

lookupDDL.Obj.parent().find(“select[ID='” + tempDDLName + “‘]”).bind(“change”, function () {
updateOriginalField(columnName, tempDDLName);
});
}

// Get all the options
var splittedChoices = lookupDDL.Obj.attr(‘choices’).split(“|”);

// get selected value
var hiddenVal = $(‘input[name=’ + lookupDDL.Obj.attr(“optHid”) + ‘]’).val()
if (hiddenVal == “0”) {
hiddenVal = lookupDDL.Obj.attr(“value”)
}

// Replacing the drop down object with the simple drop down list
lookupDDL = new DropDownList(tempDDLName);

// Populate the drop down list
for (var i = 0; i < splittedChoices.length; i++) {
var optionVal = splittedChoices[i];
i++;
var optionId = splittedChoices[i];

var selected = (optionId == hiddenVal) ? " selected='selected'" : "";
lookupDDL.Obj.append("” + optionVal + “”);
}
}
}

// method to update the original and hidden field.
function updateOriginalField(child, temp) {
var childSelect = new DropDownList(child);
var tempSelect = new DropDownList(temp);

// Set the text box
childSelect.Obj.attr(“value”, tempSelect.Obj.find(“option:selected”).val());

// Get Hidden ID
var hiddenId = childSelect.Obj.attr(“optHid”);

// Update the hidden variable
$(‘input[name=’ + hiddenId + ‘]’).val(tempSelect.Obj.find(“option:selected”).val());
}

// just to construct a drop down box object. Idea token from SPServces
function DropDownList(colName) {
// Simple – when they are less than 20 items
if ((this.Obj = $(“select[Title='” + colName + “‘]”)).html() != null) {
this.Type = “S”;
// Compound – when they are more than 20 items
} else if ((this.Obj = $(“input[Title='” + colName + “‘]”)).html() != null) {
this.Type = “C”;
// Multi-select: This will find the multi-select column control on English and most other languages sites where the Title looks like ‘Column Name possible values’
} else if ((this.Obj = $(“select[ID$=’SelectCandidate’][Title^='” + colName + ” ‘]”)).html() != null) {
this.Type = “M”;
// Multi-select: This will find the multi-select column control on a Russian site (and perhaps others) where the Title looks like ‘Выбранных значений: Column Name’
} else if ((this.Obj = $(“select[ID$=’SelectCandidate’][Title$=’: ” + colName + “‘]”)).html() != null) {
this.Type = “M”;
} else
this.Type = null;
} // End of function dropdownCtl
});
</script&gt;

Advertisements

2 thoughts on “Drop Down Issue in Lookup Field

    • Yes, you are right in some cases but I think in this point they were right 🙂
      Because with huge amount of data it is easier to write the words instead of search about it in a drop down, something like auto-complete textbox

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s