Tag Info

New answers tagged

-1

@Morgan Nice suggestion regarding the control, but the example you've provided has nothing to do with conditional data appearance which is what Mike is actually asking for. Here is an example of CONDITIONAL data appearance. You can also read more of this feature here.


0

There are a lot of things you want to happen in this Workflow. are you using timers? If not try waiting. Reason is that some of your actions might get lost as you do not have control over what happens first. By waiting for every field and logging you can be sure where you encounter the "problem" and then troubleshoot around it.


0

I might be totally missing the point of your question, but it looks like a plain filtered, no-code view filtered by lookup column would solve your problem. When browsing the Task list, create a new view. In view settings scroll down to filter area. Select your lookup column from the dropdown list and entered desired filtering value.


2

You will need to populate a drop-down fetching projects from the Projects list and than on selection redirect to the same page with ProjectId (ID) in the Query String.. Use List View Web Part to get the ProjectId from the Query String (as Query String Parameter) and filter the tasks list. Following blog post should help (It is using External List so ignore ...


0

You may have to do some custom javascript to accomplish this. Getting all the items in the lookup field and adding a text box with autocomplete for only those items. Also, you'd need to validate the text box so users could only submit when a value matches that item. Afterwards populating the lookup field based on the text field.


2

Absolutely, you set the target list to the same list:


0

You should allow multiple values on lookup column: EDIT: This will allow you to enter multiple lookup values in the column:


0

I tested this out and imported a list with ~6000 items in an environment with the default 5000 list view threshold. In another list I created a lookup column to that list. When I try and use the lookup field I get an error thrown as follows: This is a lookup column that displays data from another list that currently exceeds the List View Threshold ...


1

Logically lookup field tries to find data inside another list. Hence the resource throttling setting for list get applies to lookup fields implicitly. I was also unable to find any documentation which states this. http://blogs.msdn.com/b/spses/archive/2013/12/02/sharepoint-2010-2013-list-view-lookup-threshold-uncovered.aspx This once states about the ...


0

I don't mean to belittle everybody else's posts, but couldn't you just save these lists as templates w/ content and reimport them?


0

Unfortunately calculated columns are calculated at the time they are filled in. Not each time the column is viewed. If you are, however, trying to do that calculation at the time the item is created you can use the following: =TEXT([Modified],"mm-dd-yyyy hh:mm:ss") A somewhat older but reliable article regarding time inside the calculated columns can be ...


0

The quick and dirty method is PowerShell and a scheduled task. Assuming your field is a date/time field. You can do any math you want in there as well. Just set it to run daily. $web = Get-SPWeb <Web URL> $list = $web.Lists["<List Name>"] foreach ($item in $list.Items) { $item["Current Date"] = Get-Date -format s; $item.Update(); }


0

other options: add Javascript to the view which updates the listitem using JSOM and But maybe you do not even need to update the Item, and all you want is a "today" calculation in the View, which can also be achieved with either CSR/JSlink code (which is not available in 2010) but can be done using Javascript in a Calculated Column (in both 2010 and ...


1

Two options Create a timer job which runs daily and updates the list items Create a workflow which fires daily and updates the list items Option 1 is straight forward and easy to implement. Option 2 don't require any deployment and you can use SharePoint Designer to achieve this, but building it is tricky.


0

Obviously the OP has an answer (the question is 3 years old), but I wanted to post another answer that might help someone else. I've done this in the past using a DVWP. Within the XSLT of the web part, you can set up a variable using the value of Lookup Column A, then filter your results on that variable using something similar to this: ...


1

You can use a GUID or the display name for the listName parameter in SPServices. Make sure you use the curly brackets in the GUID. var lookupFieldInternalName = "LookupOne"; $().SPServices({ operation: "GetList", listName: "{C1AA0A1F-8177-4D64-AC3F-FDCFB31EFCA5}", completefunc: function(xData, Status) { console.log(xData.responseText); ...


0

A quick google search seems to have found what you require: http://jassimkhan.blogspot.ca/2010/10/implement-cascading-dropdown-in.html This utilizes some custom javascript to handle the dependent drop-down functionality you are after. It also requires you build an additional list to reference values from.


1

I assume that your problem is that the items you create in the lists are referring each other. For example, you create ItemA in ListA and ItemB in ListB. ItemA references ItemB and ItemB references ItemA. I assume further, that you would like to create the items from code and the lookup fields are mandatory. In this case you can simply create ItemB first ...


0

LookUp Field Values are stored in format (ID);#(VALUE) You can use below line of code SPFieldLookup lookUpField = (SPFieldLookup)myList.Fields["DMR No."]; SPList lookupSourceList = myList.ParentWeb.Lists[lookUpField.LookupList]; SPQuery query = new Microsoft.SharePoint.SPQuery(); query.Query = String.Format("{0}", lookupValue); SPListItemCollection ...


-1

To achieve this I recommend you use a 3rd party control that will support custom/conditional data point appearance. Have a look at this example. Hope this helps you! Cheers! Edit: You can see exactly how this feature works if from the example you click on "Run Chart Designer" " then select the chart "Appearance" click on the expression in the "Color ...


0

In the lookup you should select DataSource = Task List Once you select that you will get extra fields at the bottom Select Field from source = Task Comments Return field as string Find the list item : Field = Task ID Value = Workflow variable task id


1

I couldn't find any documentation regarding any explanation regarding this in SharePoint 2013. But practically my observation is that now(in SP2013) irrespective of number of items, every lookup field is rendered as a Drop-down/Select control.


-1

Fixed with editing item limit in datasource list.


0

You can get the type directly from the field. Try something like this: fieldCollection = list.get_fields(); field = fieldCollection.getByTitle("Your field title"); clientContext.load(field); Then, on the success handler you could alert the type with SP.Field.typeAsString: alert(field.get_typeAsString()); (notice: I suppose that the field variable will ...


1

Here is an example to get lookupValue and lookupId var lookup = item.get_item('userCol'); var value= lookup.get_lookupValue(); var id= lookup.get_lookupId();


1

User field will be instance of SP.FieldUserValue. I don't think that inherits from SP.FieldLookupValue in contrast to say CSOM, ref SP.FieldUserValue.prototype.constructor is function and same with SP.FieldUserValue.constructor. So your check would be: var conditional = lookup instanceof SP.FieldUserValue; Another simple hack is to simply check if the ...


0

What i checked and looks like the chart web part does not have any settings to change the color of individual data points or plot data points of a series in different colors. As a workaround check this: ...


0

Make sure you added the columns to all content types associated with the library. After uploading there will be another window which appear where you can select the content type, and then enter the new metadata columns you created


1

I would actually use Access to do this... there is a builtin way to quickly do what you want and it can handle large lists fairly easily. Link the two tables into an Access database, then go to the 'Query Wizard' under create and then select 'Find Unmatched Query Wizard.' Select your Documents in the first dialog box, and then your Projects in the second ...


0

Logically this can be done via Using a powershell script which matches the lookup column values against the target values Export data into Excel. Once you have in Excel you can easily find un matching items.



Top 50 recent answers are included