Hot answers tagged

4

OnPostRender: function (ctx) { var rows = ctx.ListData.Row; var sum = 0; for (var i = 0; i < rows.length; i++) { var value = rows[i]["FieldInternalName"]; sum = +sum + +value; } alert(sum); } Can be condensed to: OnPostRender: function (ctx) { ...


2

Finally hunted down the error: I had the column indexed. Once I removed the index, it changed nicely, then I re-added the index.


2

Welcome to the site. What happens when you add site columns to a list or content type is that a copy of that column is taken and added to the list or content type. For this reason, if you were to delete the columns from the list or content type, you would only ever be deleting the copy. Are you using content types in your list? If so, go to your list's ...


2

The best approach to this is to create a timer job or powershell/executable script that runs nightly to query your list items, iterate over them, add 1 to the field, and commit the change using system.update to not affect modified information.


1

You can set up a Yes/No calculated field with the following formula. =IF(OR(MID(Title,7,1)="7",MID(Title,7,1)="6",MID(Title,7,1)="5"),"Yes","No") Just change "Title" to your Tracking Number field.


1

It is not totally clear whether you want to write the value to the list or just display the value. So here is another solution which only displays the value without actually writing it to the list: ExecuteOrDelayUntilScriptLoaded(sum, "inplview.js"); function sum(){ ReRenderListView_old = ReRenderListView ReRenderListView = function(ctx){ ...


1

You can get total of the current view from ctx.ListData.Row. var total = 0; ctx.ListData.Row.forEach(function(item) { total += item["column1"]; }); Then update the column2 using REST API function updateItem(url, oldItem, newItem) { $.ajax({ url: _spPageContextInfo.webAbsoluteUrl + url, type: "PATCH", headers: { ...


1

You will have to call SPAutocomplete separately for each column. $().SPServices.SPAutocomplete({ sourceList: "My list", sourceColumn: "Email", columnName: "user1", ignoreCase: true, numChars: 3, slideDownSpeed: 1000, debug: true }); $().SPServices.SPAutocomplete({ sourceList: "My list", sourceColumn: "Email", ...


1

I would create a new view, filtered by your column equals your particular value. In the Totals section of the view configuration screen, tell it to count on any of the listed fields. Save the view. When you visit the view, it will be filtered and there will be a total at the top of the view that tells you how many items there are.


1

Similar to http://stackoverflow.com/a/38020258/708685, you should be able to. While your column Assigned To has allow multiple values enabled, fill in all of your data as needed. Once done, turn off allow multiple values. SharePoint will pop up a warning about how this data may be lost (so far has never happened to me). Hit okay, then modify the view you ...


1

Danny Engelman has a very good list for tested and tried functions for calculated column. You can view the list here: http://www.viewmaster365.com/365coach/#/Calculated_Column_Functions_List


1

There's a great Dev Center resource that provides a list of Calculated Field Formulas. I've used it to calculate date values, do basic math, and concatenation.


1

This column only shows on OneDrive. Switch your OneDrive and you shall see the column there where you can set who has should access the file or folder and what permission level they should have.



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