Tag Info

New answers tagged

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.


0

If you choose InfoPath as a somewhat more user-friendly way to customize the form (supported until 2020 but deprecated by Microsoft), consider reading the recipes on bizsupportonline, there are lots of them, your specific problem also solved a couple of ways.


1

Personally, I would just use a SP form. Creating the cascading drop down wouldn't be too hard to do. I've used this many times and it is effective. Use SPServices.SPCascadingDropdowns for this. The code piece I generally use is this: <script type="text/javascript"> $(document).ready(function(){ $().SPServices.SPCascadeDropdowns({ ...


0

You can use JavaScript client object model to query the master list based on what is selected in the fields and populate the third field. The code can be written in Content Query Webpart without the need for SharePoint Designer.


0

Yes, you can achieve the cascading lookup functionality for example via the SPServices JavaScript library and the Content Editor Web Part. See an example here: http://spservices.codeplex.com/wikipage?title=%24().SPServices.SPCascadeDropdowns


0

I have had the same problem trying to get a SharePoint 2010 workflow to send a email to a "AssignedTo" "Person or Group" when only that field changed. It was solved it by creating a hidden column to store the previous value of "AssignedTo" and creating workflow variables and assigning them, as type "string", to each People/Group item to be compared. Then ...



Top 50 recent answers are included