Contents
How to I set the lookup field value?
How to i set the lookup field value. (The value is already in the other list).? Lookup fields will contain a combination of the row’s id and the value of the column to display, separated by :#, in your case that could be 1:#HumanResources or 12:#Engineering.
When to query a lookup or multivalued field?
When you query a Lookup or multivalued field, there are unique considerations. For more information, see Create or delete a multivalued field and Create or delete a lookup field. The display value of a Lookup field is automatically shown in query datasheet view by default.
How are multi lookup fields used in SharePoint?
As you know SharePoint ships with Lookup Fields and Multi Lookup Fields which allow you to select multiple values. The problem is, that the underlying Field Types are hard coded so once you change the “Allow Multiple Values” setting, the Field Types revert to the standard SharePoint Field Types: so much for inheritance and a Custom Field Type.
How to extend lookup fields with ” add new item “?
Adding the “Add new item” link. Before you start extending your Lookup Fields with “Add new item” links, you have to activate the Imtech Extended Lookup Fields Feature. Depending on your scenario you can activate adding the links either for a particular Site or a whole Site Collection.
So to reference a lookup simply setting the id won’t be enough, instead the above mentioned string needs to be set. Luckily SharePoint provides the class SPFieldLookupValue that does exactly this:
How to add an item to a list?
Below is the javascript required to add an item to a list that contains a lookup field. In my example, my C# code is generating links to javascript functions. I have two lists: one list, TeamList holds teams and their members for our various school houses: