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) { ...


3

You don't have to go the CSR route but some JavaScript is required. You already know the HTML in Calculated Column trick... Let's extend that, the data you are after is in the global ctx object disclaimer; I did not test this exact code, might be typos ="<img src=""/_layouts/images/blank.gif"" onload=""{" &"var TR=this.parentNode.parentNode....


2

Make it a boolean. Tested it out on my end and this is what worked. sitecollection/_vti_bin/ListData.svc/TestList?$filter=IsNum eq true


2

You could try the FIND formula for this one. e.g. Check if "ABC" contains "A" =FIND("A",[Column1]) For more details, check out this link.


1

Consider Requester Name field contais value as Nagarajan Muthukumar Formula for First name: (LEFT([Requester Name],INT(FIND(" ",[Requester Name])-1))) Result in First Name: Nagarajan Formula for Last name: RIGHT([Requester Name],LEN([Requester Name])-INT(FIND(" ",[Requester Name]))) Result in Last Name: Muthukumar If the Name is Nagarajan M Muthukumar (...


1

There is no limitation for Calculated columns. When you save the list as template which contains a calculated column it behaves normally. You will be able to save the list template and recreate a new list using that template. The newly created field also has the Calculated column with same formula. Similarly when you save the site as template and reuse it, ...


1

You can use the following formula: =IF([Product cost] - [Materials cost]>0,[Product cost] - [Materials cost]&"<img src='https://cdn2.iconfinder.com/data/icons/splashyIcons/arrow_large_up.png'>","") (since your icon URL is invalid, I changed it to the URL of an icon on the internet) Don't forget to set the data type of the calculated column ...


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.



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