Tag Info

Hot answers tagged

10

Go to Advanced Settings and Enable the Allow management of content types. Now you will see the content types associated with the list under the Settings section. Click on Item. Select the column. Check the Required radio button.


5

Make sure that the column you include in the where clause is defined as an indexed column in SharePoint. You can check by going to the list you're querying and into List -> Settings -> Indexed Columns. It's not applicable in your CAML query, but if you have more than one 'where', ensuring the first where hits an indexed column can increase efficiency. ...


3

In reality what happens if you create for instance a list named Tasks, is that two extra navigation items are added to quick launch navigation: a header labeled Lists, and a child of it named Tasks. To answer your points Is it possible to set default No using OOTB? If you're in control of the list template used for the list (so it's a custom ...


3

When working with parent/child content types, I do this: The parent has only the fields that will exist in all child content types. Then each child content type only has the fields in it that are needed and are not inherited from the parent. So if your children each have different priority values, then each one would have their own priority field that is ...


2

You will need to add new column "Issue ID" in your list. Then you can use SharePoint designer workflow or event receiver to create this unique string and to update in "Issue ID" column. Steps: Create a column "Issue ID" in your Task List Now go to SharePoint Designer, Create a workflow for task list and set it to run automatically when Item is added Now ...


2

The short of it is you can't with workflow, they operate after the item has been added or changed. You need to use an event receiver to do that if you want to perform some operations before the item is saved. You would want to look at the ItemUpdating event, since you want to do it as part of the edit operation.


2

attempting to answer your questions specifically when adding a new column, you'll want to add it to the parent if you want the parent and subsequent children to have the same column. If your parent is an OOTB SharePoint CT, then only add it to your child. I don't recommend modifying SharePoint content types, you never know what Microsoft might do, plus ...


2

Salesforce has an connected app architecture where you can register an app which will give an access uri and key to the required resources. you can now write a custom solution using the oath via the generated key and then get the access token. now pull the chatter information and store them in to sharepoint via onject model or CSOM


2

You can add an Event Receiver with following event you can set OnQuickLaunch=false so for every list you create the ER will be executed and you can hide list through it public override void ListAdding(SPListEventProperties properties) { properties.List.OnQuickLaunch = false; }


2

You must type a location ( preferably a local location on the server or a shared network location ) and then a filename for your export. For example: C:\backups\backupFileName.cmp


1

If the Issue Status field does not meet your requirement you should not use it and use a custom column instead. If you envision this list being used in multiple places and across site collections I'd suggest using a Managed Metadata field, because once your users start using it they will find they need additional choices.


1

You need to use Column Validation. Open List Settings Click on the field Scroll down and expand Column Validation Use Formula - Replace SiteColumn with your column name =NOT(ISBLANK(SiteColumn)) Enter Error Message. For Ex: Required Field Click OK


1

For SP2010/07, the internal name of Title cannot be modified, yet you can change displayname for Title. use field.DisplayName = "Last Name" Here, the internal name is Title and display name is "Last Name".


1

To get an item value, modify it, then update the item your call will have to change a bit because you will need to load the item, executeQueryAsync to retrieve the item info, use the item info to make a change, call update, then run executeQueryAsync again... (function () { var id = 1; var listName = "YourListName"; var ctx = ...


1

You can use a calculation for this. Create the column reminderdate as a calculated column of the Date and Time type. Then use the following calculation: =DATE(YEAR([dueDate]),MONTH([dueDate])+4,DAY([dueDate])) If you are using another regional language than english, you may have to replace all commas (,) with a (;). Every time the column dueDategets a ...


1

Their no OOTB way to handle these kind of situation. One workaround i am thinking,If both files are identical then upload both files in SharePoint library. After that you can use PowerQuery to Consolidate both files and then create the list on the basis of new file. Consolidate Multiple Excel Files in SharePoint using PowerQuery Another method, create a ...


1

This feature is not available as OOTB. but you can develop custom solutions as below develop office add-on's which can interact with SharePoint and merge from two excel sources in to single list. create two lists and the develop ribbon action with a custom layouts page say "export" in which the list data will be updated to the final target based on list ...


1

Yes you can,check this video Sharepoint Salesforce.com Integration Or use the 3rd party App Chatter for SharePoint – the leading solution for integrating your SharePoint collaboration platform with SalesForce Chatter


1

It really depends on the type of content we’re discussing. If this is a project web where team members only have access, and company guidelines don’t restrict the use of task list in a way that it should be retrievable in reports you could let go and allow users to build their own task statuses. But if you have project webs that are managed in the same way ...


1

Yes, You can do it.But for a two-way synchronization you have to download a free Add-In from Microsoft. With this tool you have to create a list in Excel, publish it to a SharePoint list and synchronize with it. Once you install it, then you should now see under the Design tab a SharePoint section with a button called Publish and allow sync. Please follow ...


1

Using CAML query is the best option for retrieving data. As list grows if the result set has more than 5000 items, then performance will degrade. To handle this situation as SCMC suggested you should add indexes to fields used in the WHERE clause. If you still observe performance issues, the I would suggest using Pagination. So get items in set to X items. ...


1

The hierarchical relationship allows you to reuse the settings (fields) defined in one content type (parent) in other (child) content types. The hierarchy of content types can be extended to an infinite width and depth, but the best practice is to use 3-level parent-child hierarchy. You could read more best practices on how to manage content types and ...


1

You can do it using below code SPList list = currentWeb.Lists.TryGetList("ListName"); if (list != null) { SPContentType itemCT = list.ContentTypes["CTName"]; if (itemCT != null) { list.ContentTypes.Delete(itemCT.Id); list.Update(); } }


1

The best way to open a modal dialog in SharePoint 2013 is to use the built-in JavaScript function called "OpenPopUpPage". This was introduced in SP2010 and is used widely throughout SP2013. To change the page being loaded within the modal dialog, you can then use a simple "window.location.href" function. EXAMPLES: Opening a Modal Dialog <a href="#" ...


1

Go to Advanced Settings and Enable the Allow management of content types. Now you will see the content types associated with the list under the Settings section. Click on Item. Select the column. Check the Required radio button.


1

You may have to do this in Powershell. $site = Get-SPSite -Identity "http://sharepoint/" #change $web= $site.OpenWeb() $spList = $web.GetList("/Lists/CustomList") #change $field = $spList.Fields["Location"] $field.Required=$true $field.Update() $web.Dispose()


1

We might have to manipulate/update the data without changing the Modified or Modified By fields to meet the business needs and also retaining the document/Item status without incrementing the version is also important aspect to be considered. In such cases SystemUpdate() method of SPListItem can be leveraged. This basically updates the content database with ...


1

Use SP.ListItem.attachmentFiles property to get the collection of attachments that are associated with the list item. In order to load list items with attachments it have to be requested explicitly, for example: ctx.load(items,'Include(AttachmentFiles)'); Example The following example shows how to load list items with attachments function ...


1

To begin, go to List Settings > Advanced Settings Select Yes on Allow management of content types Click on one of the existing content types under the Content Type section Next, click on the column you intend to hide, and choose the option Hidden. Click OK Go to the New Item tab and select the Edit form. You will see that, on both the New Item and Edit ...


1

You can get the list of content types associated with a List. And the first one is the default one. $webs = Get-SPSite http://siteurl | Get-SPWeb foreach ($web in $webs) { foreach ($list in $web.lists) { if($list.ContentTypes.Count > 0) { Write-Host "Default Content Type = " + $list.ContentTypes[0].Name } ...



Only top voted, non community-wiki answers of a minimum length are eligible