25

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. How to highlight the rows using CSR Below example demonstrates how to highlight list task rows based on their status ...


9

I just needed to set is empty instead of is equal to. I just didn't know we could do that.


5

For your issue, I recommend to follow the steps as below: Clear SharePoint Designer cache: How to Clear Your SharePoint Designer 2010/2013 Cache Deactivate all "Workflow" features at the Site Collection level. Enable all "Workflow" features at the Site Collection level. PSCONFIG (Not Necessary) (or run the SharePoint 2010 products configuration wizard) ...


3

I found the answer, and apologies to all for "answering my own question". Googling more brought up suggestions about using the "XSL Link" option available in the List View Web Part. The examples I found had hand-coded XSL to stuff in there, but you can copy the XSL right out of the view's .aspx page in SPD. Presume you have a view named "Foo" (use your ...


3

Rather than a timer job which "touches" all the items, consider using jsLink or other client side rendering techniques to calculate the value in real time. Of course, it depends on how you are using the values, which you don't indicate.


3

Unfortunately, this isn't possible since Calculated Columns are not recalculated on viewing, but only on creation and modification. See this article: http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/ You will need to solve this with display logic.


3

Add the following code into script editor web part in list view page. <script type="text/javascript"> (function () { // Create object that have the context information about the field that we want to change it's output render var priorityFiledContext = {}; priorityFiledContext.Templates = {}; priorityFiledContext.Templates.Fields ...


3

You can use VALUE function to convert text to number. VALUE function Converts a text string that represents a number to a number. Syntax: VALUE(text) text is the text enclosed in quotation marks or a column reference containing the text you want to convert. Use below formula(If your Column A field always going to have valid number stored ...


2

Yes it is possible through new feature of SP2013 called JSLink. With JS Link, users can add a reference to their JavaScript Files as a WebPart property, and Control the Rendering of Fields & Items in Views, List Forms (Display,New,Edit) and event in WebParts.Before you use the js file, it is recommended that the JavaScript file should be Uploaded as a ...


2

Microsoft disabled all this in versions 2016 and later, it still works in older SP version and non-Modern Experiences See: June 13th 2017 Microsoft blocked handling HTML markup in SharePoint calculated fields - how to get the same functionality back Original answer: If you don't mind: Always obeying the Microsoft SharePoint 2013 way of doing things ...


2

You can't do that with validations. All you can do is have a formula that returns true or false, as to whether that field is valid or not. You can't affect other fields. If I had to do this, I would put a Script Editor web part on the form and use JavaScript (and Jquery and the SPUtility library from Codeplex) to show/hide the second field in the "onchange" ...


2

There is no OOTB function which is handle your situation. But you can have presaveaction function in sharepoint 2013, so you can check your condition using JavaScript in page and return false to this function if your condition not satisfied. So it will not save your item without mandatory fields.


2

In case it might be helpful for someone: I had a similar problem with a client today in a SP 2013 environment, but in my case turned out that it was a .Net security update that caused it. The solution after this update was to add some types to the web.config file on the SharePoint server: <authorizedType Assembly="System, Version=4.0.0.0, Culture=...


2

You need 3 conditions, something like this if category = cat and location = foo background color change to red if category = cat and location !=(not equal) foo background color change to red if category !=(not equal) cat and location = foo background color change to grey check this one to learn more about conditional formatting. http://blogs.msdn.com/b/...


2

In SharePoint Online, you should be aware of the JavaScript/CSS customization is not allowed for the Modern Experience list and libraries. Meanwhile, it's allowed for Classic Experience. In case, you are using Classic Experience, you can apply conditional formatting via Jquery in Display form based on a specific field value via the below code: <script ...


2

follow the below steps: Create a local workflow variable of type string, say dateAsString. Use command Set workflow variable. In variable select the newly create i.e. dateAsString. In value select fx in the open dialog box select Current Item, FieldName, and Short Date. Now write if statement and check if workflow variable is equals 1/1/0001. This will ...


2

You could add a stop workflow at the end of each set of actions so it won't further evaluate. For example: If A and B then Action 1 then Stop workflow If B or C then Action 1 then Stop workflow If A and C then Action 1 then Stop workflow If it successfully enters any of the condition blocks, it executes Action 1 then stops further evaluating. ...


2

The following should work: =IF(LEN(Column1)>0,IF(LEN(Column2)>0,IF(LEN(Column3)>0,"Approved",""),""),"")


2

As James said, a Validation Formula is intended to prevent the save of an item. Two options for what you are describing: Create a Calculated Column that "corrects" the cost. (Maybe name this column Final Cost.) =IF( [Reason]="Backorder", 0, [Cost] ) The Calculated Column would display either a zero or the value entered in the Cost column. Create a ...


2

Here is the nested validation formula: IF( OR( [Position]="Ground Support Equipment - Ramp Equipment Operator (GSE-REO)", [Position]="Ramp Equipment Operator (REO)", [Position]="Cargo Checker", [Position]="Cargo - Ramp Equipment Operator (Cargo - REO)", [Position]="Fuel Operations Helper", [Position]="Warehouse ...


2

Yes it is possible with infopath but you need to use text field and make the calculations using info-path functions. The build in calculated field will recalculate only when you submit the form. With normal text field you can use info-path function to make the calculation. Right click on the field and click on text box properties. Then next to the Default ...


2

This sounds like it might be a situation where you can use Client Side Rendering. If you are unfamiliar with CSR, I highly recommend reading this article to get an understanding of what you can do with it. Conditional formatting is one thing it's really good at, and I'm sure you'll be able to find many resources (probably a lot on this site) that have ...


2

This article should help you out. Find the column on which you would like to customize and use this article to format it using JSON. You will see the JSON editor within the column's settings. https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting


2

I would double check that "Location" is truly the internal name of the field. Sometimes the display name can change, and to register the CSR override you need to use the internal name. The easiest way to check that is to go to the List Settings page for the list, scroll down to the Columns section and click on the name of the column. on the Edit Column ...


1

I had this problem before and after a lot of searching I learned that you can't modify multiline text fields style. You can use a single line text field instead but it will limit your comments to 255 characters. I made 3 columns: 1.- Status: Choice Type with 3 options, Red, Yellow, Green 2.- Item Comments: Single Text line (this is where the actual ...


1

You can add this code to your NewForm.aspx and EditForm.aspx to check the attachment table rows - this requires an attachment all the time - you can add in the code to only check it whenever a certain choice is selected. I added code to show you how to grab a select value - if you use Jquery you'd need to reference where you'd actually get it from - I ...


1

you can have your logic as follows If condition1 is true then send an email to the first group If condition2 is true then send an email to the second group You need to have simple if condition to send an email when it matches.


1

There is no direct way to apply a condition on a choice column in SharePoint List/Library. Though you can achieve this by using some jQuery hacks in the forms where you want to force the user to select a choice value based on time frame.


1

Handling Dates as Strings is a recipe for a lot of headaches If you are going to work a lot with Dates then use the MomentJS library https://momentjs.com/ moment("05/06/1995", "L", 'en-gb', true); If you go to the MomentJS site, the library will be available and F12 Console commands give:


1

You can't do that out of the box, but it would be rather easy to write a javascript to take the logged in user from the _spPageContextInfo object and use that as a filter. But if you want non-code solution the answer from VenKat is better.


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