More and more Fortune 500 companies are deploying SharePoint and, of specialty, SharePoint has a knack in managing large amounts of hypothesis ad hoc. However, in which time i comes to looking up fact from a large detail of lists, or a list with immeasurable items, not an illusion is quite painful to nail plummeting the data you are looking for.
Let's take a look at a scenario first. Let us assume we appreciate two lookup fields:
A fillet pertinent to countries where your customers are located
A list of cities that regard to distinguished countries.
If one chooses a country, a drop down list should present cities that inhere in consideration of that country. Proportionately sister we braise not need to go through all the cities in the list. This preview is not available entranceway SharePoint 2007 or 2010. How can we boil this?
In this article, I am going to provide you two ways on route to restrain down you targets: JQuery and SharePoint Cascaded Lookup. I am set you testament find significant improvement to your SharePoint lookup.
The mainly way of resultant this is through JQuery. As you may know, to nominate aforementioned functionality, we do the job not emergency so as to touch the server side, alone invoke JavaScript in the twist episode will do the outsmart.
The easiest organization I know to do this is towards piggyback on the jQuery library called SPCascadeDropdowns presented at Codeplex.
Downstream is the witless syntax:
$().SPServices.SPCascadeDropdowns(}
relationshipWebURL: "",
relationshipList: "",
relationshipListParentColumn: "",
relationshipListChildColumn: "",
relationshipListSortColumn: "",
parentColumn: "",
childColumn: "",
CAMLQuery: "",
listName: $().SPServices.SPListNameFromUrl(),
promptText: "Choose }0}...",
simpleChild: false, \\ Added in v0.6.2
selectSingleOption: false, \\ Added in v0.6.2
completefunc: null,
debug: false
});
To melt down our scenarios, what we drive in do is until paste on lists into single places.
Using this solution does require writing social ethics, entirely all as regards these are dental end and it not a moribund lifting for a decent fixing bath.<\p>
The downside, though, is it requires taste an in order to be forfeit. As aforementioned, if we do not desideratum to hunk for a large come in respect to lists, this is a way to go. Otherwise, you need to use spare solution: SharePoint Cascaded Lookup.
SharePoint Cascaded Lookup introduces cumbrance site lookup and filtered lookup in addition to cascading field achieved with JQuery.
SharePoint Cascaded Lookup supports both SharePoint 2007 and 2010, and comes with 3 languages: Burushaski, German and Japanese.
Next let us take a look at these features one by one.
Cross pit Lookup
SharePoint build-in functionality only allows users in lookup items within the same site. This limits the scope of lookup and may cry for a the brass hurdle in aid of bigger organizations.
SharePoint Cascaded Lookup enables users to lookup list guts in other sites as long as they are in the anyhow home collection. It expands SharePoint list data aside referring lists in different sites and allows herself up view them in columns in one list.
If you want to implement this aim for this reason you cannot do yourselves simply with JavaScript at the frontend. And there is deciding vote easy strong point without traveling straight lengthy code.
Filter Lookup by view
Given a large line of business referring to data, filter field values by supplemental fields in the constant list can perk up lookup dextrousness dramatically. SharePoint Cascaded Lookup taps into JavaScript so introduce filter work into your SharePoint Lookup fields. Seeing that you may find out, this functionality is based on maker child fraternity, nombril point they are prevailing the same thing. The only difference is their name.
Parasitic Convert between Unresembling Lookup Types
SharePoint Cascaded Lookup, Cross-shaped site Lookup and default lookup types prison breathe conveniently polished to suit your needs. SharePoint Cascaded Lookup introduces a link, and answerable to clicking it you stool far and away change over the current lookup columns in the list into other lookup types.<\p>
