Tag Info

New answers tagged

2

You need to change the type of column colour in List#1 to LookUp. When you will select the LookUp column, you can select the List#2 in source and column colour Now your column in List#1 will be connected to List#2's colour column. Please let me know if you want further explanation. Help Link


0

Or You can try this: $w=get-spweb http://site/ $f=$w.fields["field_name"] $f.schemaXml = "schema xml with another list ID" $f.update()


0

Yes. There are two things you have to take care of: The user/group will need atleast read permission to the Look-up List. The number of look-up columns in your list should ideally be less than 8. If there are more than 8, then you will again end up with issues.


1

I fixed it by removing the "multiple values" check! Who knew?


2

you should use the itemupdating afterproperties for this: if(properties.AfterProperties["Service box"] == null) { //Cancel event properties.Cancel = true; properties.ErrorMessage = "value cannot be null"; } EDIT its todo with the current condition of the item. Your using the event itemUpdating what means that it still hasnt ...


0

their is no OOTB way to filter the LookUp. Their are couple of options you can try. Use SharePoint designer with a text column to get this Applying Filters to Lookup Fields with the SharePoint 2013 REST API their is codePlex solution for this


2

As Cameron pointed out, it's because of performance reason. Administrators got permission to query above the default 8 columns, standard user's do not. Microsoft states the following on their site about list performance. See the part Lookup columns and list views in the article. There's some good graphs showing what happens with the SQL performance as ...


0

If i understand properly, you need to sync the two given lists. If there are any changes done on list1 one it should be reflected to list2. I am not sure about any OOB(Out of the box) solution. But you can write a Event Receiver and in custom code you can update the changes in either of the list. So you need to write Event Receivers for both of the lists. ...


0

Check my answer on the other questions in the forum. I am sure you want the same thing: Relational List fields


0

Since you have to reference two lists, your only option that I see is to use a script to handle it (I originally thought you wanted to filter the color column, and not the Cars column. I don't know of an easy work around, besides creating a new field and using workflows to get it done). Here is a sharepoint script that could possibly get it done. I can't ...


0

I used jQuery to remove the links by selecting all anchor tags pointing to the look up list (check the href for each of the look up values and they should all start pointing to some list and have an "ID=" at the end). I then unwrapped it from the tags to just return the text. Here is the code line for my list, but you will of course need to change it to the ...


1

Lookups cannot consume all types of columns, so you need to build a column that the lookup can use. You could add a text column to your initial list and let a workflow copy the text of the ContentType field into that new column when the item is created. Then you can use a lookup to that text column.


0

using Jquery. <script language="javascript" src="/JS/jquery-1.6.2.min.js" type="text/javascript"></script> <script language="javascript" src="/JS/jquery.SPServices-0.7.2.min.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function () { $().SPServices.SPAutocomplete({ ...


0

I've used jQuery UI on several occasions in conjunction with SPServices to fetch the lookup data.


0

I was able to successfully do this manually. The easiest way is to switch to data sheet view, copy the content to Excel. Then sort your list. Delete the rows in the original list and paste the sorted content back from Excel. As your new list items are added on paste, the Item ID is assigned in the order pasted. Viola! Your lookup dropdown is ...



Top 50 recent answers are included