Hot answers tagged

6

To average multiple columns in an item, you'd use a calculated column such as =AVERAGE([Column1],[Column2],[Column3]). To average a column, edit the view and expand the Totals section. By your column name, if it's a number, you can select average (etc) from the dropdown.


4

What you could to is just create a OOTB custom list, change the Title field to "New Idea" or something relevant and then enable ratings for the list from List Settings > Rating Settings. Enable it to Yes and select Star ratings and voila! Users can now rate the item/idea on a scale of 1-5 stars. If you wanna take it further from there, you could set up a ...


2

One way to achieve this - Assuming data is in the correct format in all cases =LEFT((MID(CountryWF,FIND(":",CountryWF)+1,LEN(CountryWF))), FIND(":",(MID(CountryWF,FIND(":",CountryWF)+1,LEN(CountryWF))))-1)


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

You need to use Client Object Model. Look in this link for basic operations: https://msdn.microsoft.com/en-us/library/office/jj163201.aspx#BasicOps_SPListItemCRUD Form this links, you have sample to create and delete items(like a move) Create: function createListItem(siteUrl) { var clientContext = new SP.ClientContext(siteUrl); var oList = ...


1

You can use the JavaScript Object Model to create and delete items. For reference, see Common Programming Tasks in the JavaScript Object Model, the SP Namespace, and SharePoint 2010 Client Object Model Hierarchy and Identity. Here's an example function to get you started: function moveItem(sourceItemId){ var sourceListTitle = "My Source List"; var ...


1

I don't think there is something OOB for multiple columns. I would suggest to use JavaScript and override PreSaveAction to prevent the save if the combination exists. Something like that : function PreSaveAction(){ //get field 1 value //get field 2 value //perform a query to check if there are items that matches criteria if(noresults) { ...


1

It is not possible to have cascading dropdowns (behavior that you are describing) in OOTB SharePoint forms. There are third party solutions (both farm solution and add-ons) that add this functionality to lists. You can also have a look at SPServices jquery library and add this functionality yourself to the form. This does require some javascript development ...


1

You do not need to pass the credentials. Please look into below mentioned code to get single item from list using REST API. function getListItem(url, listname, id, complete, failure) { // Getting our list items $.ajax({ url: url + "/_api/web/lists/getbytitle('" + listname + "')/items(" + id + ")", method: "GET", headers: { ...


1

If you are developing a mobile app which will communicate with your SharePoint 2013 then you can use the common services that can be accessed using open protocols. If your REST Service API codes are hosted in your SharePoint environment then in that case you do not need any authentication mechanism. But if your code is hosted somewhere else other than ...


1

There is no inbuilt mechanism say OOTB facility to do such task. But still you can do this with little bit of lazy steps. Or also you can go with C# custom solution. For detail information of converting custom list to Document Library you can go with this SharePoint - Convert a list to a library once. Also if you have document attached in your current ...


1

Instead of going with easy approach you should choose best practice. This will help in the long run. Best practice is to create Content Types and add it to the document library. So first create a Document Content Type and add the required fields (site columns).


1

You can upload your image to sharepoint library (Site Assets ideally if it won't be changing too often) then add CEWP (Content Editor Web Part) to your page and inside CEWP add <img src="/sites/yourSite/yourLibrary/yourImage.jpg" /> Then you can also use css to design it, for example iof you need a border: <img ...


1

There are many ways to achieve this: Build an html page and add your css (inline or external even) then place a content editor web part where you like the photo to appear, and reference the html page you built. Create a custom display template and your query can be customized to pull this photo and our add you can build the UI to your requirements. Place ...


1

Using JQuery we can acheive this. Find the selected index or value from 1st People picker and With responsible to that pass the selected value to userName parameter. Note: The Value must be the username. function SetUserFieldValue(fieldName, userName) { var _PeoplePicker = $("div[title='" + fieldName + "']"); var _PeoplePickerTopId = ...



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