New answers tagged

0

Is the list created using a template? Try editing your view via list settings so only title/name column remains. This is to narrow down your problem and see whether it's related to a columns, in particular a lookup column. I run into a similar problem after restoring a list using the PNP provisioning framework and the lookup columns where pointing to the ...


0

If you don't already have a lot of data in the list, I would make it 6 columns total Team Name Month work demand planned work demand Actual overtime demand planned overtime demand Actual You will have to enter an item for each month for each team but it will make pivoting with that data much easier when you export it into excel.


0

With regards to automating emails with regards to replies I have used multiple status indicators to help prevent multiple notifications. For instance, have a status1 and a status2. status1 is your master status, status2 is specific to a reply. status1 defaults to "submitted". status2 defaults to "pending". You can then create a workflow where you check ...


0

Go to Hours column textbox property In default view textbox, Click on Fx button Click on Insert Field or Group.. Select secondary data source (Your list) from above dropdown Select Hours field Click on Filter button Set condition like Item(Secondary data source) = Item(Main source Dropdown) Save it Same steps for Price field


1

Give this a shot Open list settings and try setting the default view to AllItems. Or create a new view and set it as the default view.


0

I had a similar requirement but decided to generate the Excel and later Word file using javascript. I don't have any examples for generating the excel file. What I do remember is that the basic plugins I used were transforming HTML into Excel which made Excel think that the file was a webpage (received html extension when saved without changing the file ...


1

If you change the column type to single line you will lose all richness and new lines. There are three things I see that you can do: Change the column type and just lose all the richness and new lines immediately. Add a new single line text column and fill it with the text from the current column, and hide the current column. This will hold your old values ...


0

If list doesn't contain any dynamic column one can use below script to achieve freezing header with vertical and horizontal scrolling. Note: Tested with SharePoint 2010 only //jquery lib <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.2/jquery.min.js"></script> //style sheet <style type="text/css"> .fixedBlock { ...


0

Add CEWP on your page and add below script in it. <script type="text/javascript"> window.onload = function() { document.getElementById("idHomePageNewAnnouncement").getElementsByTagName("span")[1].innerHTML="Add new report"; }; </script> UPDATE Using JS link Put upper code in js file and upload it in ...


0

Add CEWP to your page using below steps. Go to Page where you want to change the text for link. On your page, click Site Actions and then click Edit Page Click on the area where you want to add the Content Editor Web Part The Add Web Parts dialog box will open. Choose the type of content that you would like to add. For us, scroll down to the Media and ...


3

Go to List settings -> under Content Types heading all the content types the list is using are listed Click any content type, this will list all the columns and click the column you will be able to delete the column by using Remove button at the bottom (don't worry it will not delete from the parent content type - it will just delete the column from list ...


0

You can take the following approach: Create a list (let's call it the Master list) with a single Title column (or more if required). Create an event receiver which would handle ListAdded event. Develop your event receiver so that every time a list (or a library) is added to the web site a corresponding item is added to the Master list - for example the ...


1

You cannot create a lookup for a "List name" in SharePoint. Possible alternatives would be creating a choice column which has a list of values, or customizing the new item page (using JS link) to fetch a set of lists inside current web and display them in a drop-down.


1

0x80070005 means access denied...Make sure the account which is running powershell have the right permission on the site collection...also try to run the powershell console as Adminsitrator. Sometimes, when you provision a list instance with Visual Studio, the provisioning could fail if there were errors in the script. Then you got a corrupted list. This ...


0

And then do what? Are you going to call that list items afterwards? Please elaborate your requirement. If you just want the list/library names in a look up field you can create a separate SharePoint list with all List Library names in a column and then call it as a lookup value.


0

A list and a library are two different things. If you attach a document to a list item, it will be stored as an attachment in the list item, not in a document library. You may want to edit your question and explain what you would like to achieve. It seems that there is some misconception of SharePoint concepts, or of the terminology.


3

Yes you can. Just go to modify view page, and add the filters like this: closing date is greater than or equal to [Today] publish date is less than or equal to [Today]


1

It depends upon on your environment ( i.e number of the site collection, Size of data, Complexity of sites). As you know, there is no direct way of migration from SharePoint 2007 to 2013. The only way is to build a temporary SharePoint 2010 farm( btw 2010 also pass End of life) then Backup the content DB from 2007 and restore it 2010 after upgrade here then ...


0

If it were me, I'd try to get help on the PowerShell script and get some test runs in. I wouldn't buckle into purchasing from a 3rd party just yet, when it's entirely possible to fix the PowerShell script. In my experience the script will use sharepoint web services in 2007 to grab the file and be uploaded through the sharepoint management shell snapin. ...


1

None of these answers work. Did anyone bother to test them? After looking elsewhere and working it out myself, here's what works: =TEXT([Start Date],"mm/dd/yy")&" - "&TEXT([End Date],"mm/dd/yy") You can adjust the way the date shows by using the mm/dd/yy part, which is intuitive.


0

Take a peek at how Microsoft does it; there is a new App in the Store https://store.office.com/office-365-project-portfolio-dashboard-WA104380116.aspx?assetid=WA104380116&ui=en-US&rs=en-US&ad=US I have not seen this app... so I am not saying it has any value!!


0

I think here workflow is the best option. Let it trigger in item update and you can check in a if statement inside workflow logic. I feel designer workflow should work.


0

By Default, items in a SharePoint list can't be grouped by a Choice field if it allows multiple selections (checkbox). http://blog-sharepoint.blogspot.in/2009/09/solved-cant-group-by-choice-column-in.html


0

This is possible by adding a custom action that can be to the Style Library. You would need to design your custom form programmatically in this custom action - JavaScript file and associate to this list.


0

You can edit the default new form. Go to list ribbon and click on Form Web Parts. From drop down click on Default New Form. This will open New form in Edit mode. Add your custom webpart on the form and hide the original webpart.


0

Create calculated column in SharePoint list. =CONCATENATE(Code," ",Status) Update secondary data source with adding new calculated column in InfoPath form. Set calculated column as data source in dropdown property in InfoPath form.


0

Assuming that each contact can only be assigned to one project, then one possiblity could be to use different content types based on the project the contact is assigned to. Have a base Contact content type. Then for each project create a Project X contact content type, which inherits from the base Contact content type and adds the fields needed for Project ...


0

Why not have a list of all contacts and then have a lookup column that pertains to the project or projects he/she is on? Then you can filter in or out the contacts that the Project pertains to. The contact would have a lookup column called "Project" that would point back to the Project on hand--and let there be multiple selections.


0

I fixed it by using Content Query Web Part (CQWP) to which I am passing value as query string parameter. CQWP has the option "Contains" rather than exact match which will bring all related results.


0

Mihail's solution works, but if you really want to make it yourself very easy, I would suggest just giving contributors permission to edit their own items and make all others invisible. You can do that by doing the following: Go to the advanced settings of your list, go to item level permissions and select "Read items that were created by user" + "Create ...


0

I am going to propose a solution that assumes that your list has a person field named Employee and that you have a group called Managers. What you need: A list view called My Employee Info that is filtered to display only the items where the Employee is equal to [Me]. A list workflow that sets unique permissions for each item. The workflow should provide ...


1

using (ClientContext context = new ClientContext("http://SharepointURL/")) { try { Web web = context.Web; FileCreationInformation newFile = new FileCreationInformation(); newFile.Content = System.IO.File.ReadAllBytes(@"C:\test.txt"); newFile.Url = "test.txt"; List docs = web.Lists.GetByTitle("CustomList"); ...


1

In SharePoint 2013 was introduced a so called Client Rendering Mode (CSR) which represents a rendering engine for list views, list forms and search results. I would recommend you to consider the following approach for your task. Color code item row based on column value in SharePoint Foundation 2013


1

Have you try to use : HideCustomAction ?? With this, you can hide specific custom (the custom and OOTB CustomAction).


1

Follow these steps: 1. Get your coloring logic in a JS file. An example: SP.SOD.executeFunc("clienttemplates.js", "SPClientTemplates", function() { SPClientTemplates.TemplateManager.RegisterTemplateOverrides({ OnPostRender: function(ctx) { var colors = { 'Pending' : '#40f600', 'Running' : '#f9af00', ...


1

You can try this: add another Custom Action with a Location set to where you want to hide it - for example attach it to list with a specific content type, or to a list based on a custom template (there are many different locations, just Google around): <CustomAction Id="RemoveRibbonButton" Location="CommandUI.Ribbon" ...


2

no its not possible ootb in 2010, your talking about changing the identifier column. its easy todo but would require coding tho! it will get messy quickly! say you have 1 , 2 , 3 , 4 and you removed 2 so you now have 1 , 3 , 4 . you would need to not only change 3 to 2 but anything after it down a notch! you can do this in code using the item deleting ...


1

Re-indexing the ID in List/Library is introduced in SharePoint 2013. There is no OOB solution available in SharePoint 2010 to re-index the ID column. You can index SharePoint 2010 columns with the help of topic mentioned in below link. SharePoint 2010–Indexing columns in a SharePoint List


0

You could use SharePoint item IDs. Your calculated column would look like this: =([ID-1]/3)+1 Example: ID RESULT 1 1 2 1 3 1 4 2 5 2 6 2 7 3 8 3 9 3 10 4 ... ... The problem with this is that it has to be a fresh list to start from ID value 1. (for example if you ...


1

You can make a custom editform.aspx via SharePoint Designer to make the end date "read only". You have to change the ControlMode from "Edit" to "Display". There are also other ways with jQuery, JS or Powershell. How to create a new, display or edit form is shown here: https://afrait.com/blog/custom-new-edit-or-display-form-in-4-steps-en/ You can set the ...


0

Use SharePoint Designer 2010 to either add a temporary CSS class [say customClass] to your Web Part and than use <style> .customClass .ms-viewheadertr { display: none;} </style> Or completely delete the top header table using SharePoint Designer 2010 - Design View. Once you click on any column, click Esc to get the top element.


0

You can create a folder structure in discussion boards. To do this, create a new Site Content Type say called 'Discussion Folder' based on the Folder Content Type with the Parent Content Type as a Discussion (Site Actions -> Site Settings -> Site Content Types) Then, add the new content type (Add from existing site content types) in Discussion Boards List. ...


1

This might be duplicate of the Create a folder structure in a discussion board. Please have a look to this link and let me know whether this helped you.


-1

There is a very simple way to accomplish this right inside the list. Open List Settings Click on the Column (Column1 for this example) you would like to restrict In Column Validation Settings use the formula =[Column1]<>[Column1] Create a User Message such as " User cannot change this column". When user tries to change Column1 they will get error.


1

Turn management of content types back on. You will have a list of columns that includes "Used in." So if Column B is used in Content Type B only, it can be deleted.


3

Here you go: # enter your site URL $spWeb = Get-SPWeb "http://sp2013" $listName = "Your List Title" function GetCheckedItems($spWeb) { $list = $spWeb.Lists[$listName] Write-Host "Scanning List: $($list.RootFolder.ServerRelativeUrl)" foreach ($item in $list.CheckedOutFiles) { if (!$item.Url.EndsWith(".aspx")) { continue } ...


3

Document library require content types that are inherited from Document Content Type. This is required because it needs a File field to store the file data. In case of Custom List, it is just like an Excel File with columns (Meta data) and don't require a mandatory File object (in case of doc lib) Also I don't think its a good design to have both using the ...


1

Create a calculated column to sumarize criteria and then filter with this new column. Perhaps you need to create one or two calculated column. You do need code or sharepoint designer for this solution.


0

Edit your list view web part, in the filter section, select your column on which you want to filter, apply the condition of Greater Than and save the filter. Here is a nice tutorial to do this kind of filtration. http://www.nothingbutsharepoint.com/2011/08/11/understanding-filters-in-sharepoint-list-views-aspx/ Or you can also try the below link. ...


0

You can use the SharePoint designer app to create more than 10 criteria for your filters. You will need to know some CAML to be able to achieve this, but thankfully it is reasonably easy to learn. MSDN CAML for Queires is a good starting point for understanding how to use CAML for filters. I would recommend you build up your initial filter criteria in the ...



Top 50 recent answers are included