When you're in the rendering cycle, in your CSR override code, ctx.CurrentItem will have other field values. So for instance you could check ctx.CurrentItem.ProductionStatus (or whatever the internal name of your field is).
I highly recommend setting a breakpoint in your CSR script and exploring what is available on the ctx object during rendering.
That means given answers may not apply for newer SharePoint versions
For long explanation and work arounds see:
June 13th 2017 Microsoft blocked handling HTML markup in SharePoint calculated fields - how to get the same functionality back
This type of ...
Because this plagued me for almost a week and it seems so many people have had questions about it I have decided to share what I learned in this process. After reading almost everything online and asking everyone I knew for help, I finally put all the pieces together to solve the puzzle.
I am new to SharePoint, like a month into it new. I started out ...
Try referencing the following:
Color code item row based on column value in SharePoint Foundation 2013
<Query><Where><Eq><FieldRef Name="WorkflowColumnName" /><Value Type="WorkflowStatus">16</Value></Eq></Where></Query>
Here is the list of the status codes used to maintain the workflow statuses.
Not Started 0
Failed on Start 1
In Progress ...
How many lookup columns do you have on the list view, there cannot be more than 8 on a view by default, unless you have changed this in the central admin.
Remember that the people columns like 'created by' 'modified by' also count as lookups.
The workflow status column is a lookup that links to the Workflow history list.
If you have more than 8 lookups ...
Add $Pageitem.Update() (or .SystemUpdate()) after assigning ModerationInformation.Status:
You need to update the item after changing the metadata as well as after setting the Moderation Status. Your code should look like this:
$Pageitem = $PagesLibrary.GetItemById($deleteditemId.Key)
If you are using SharePoint 2013 Designer Workflow, it is very easy.
Assign a task activity will have an outcome variable
Put a if condition under transition and check for the task outcome.
End workflow if task is rejected.
Also the task should have been configured to wait for completion.
Thank you so much! I found in the comments of the article you sent me that if you select "Number" instead of "Line of single text" you can skip the steps after 4. in the solution for 2010. This worked out great for me, but I could not ...
Check the CHOOSE function index parameter to avoid getting #VALUE! error.
="<DIV style='font-weight:bold; font-size:45px; text-align:center; "&IF(RIGHT(LEFT(CASES;2);1)<=0;"color:white";"color:"&CHOOSE(1;"green";"red";"yellow";"orange";"blue";"grey";"black";"white"))&";'>•</DIV>"
Since you don't have 15 values, you will get an ...
Note: Please mention the version of SharePoint you are using, so that its easy to provide the suggestions/answers
Is this for SharePoint Online? If yes, HTML within a calculated field will not work anymore. Effective Jun 13 2017, this feature is disabled.
Administrators can request an extension through September 10, 2017 at the latest.
For SharePoint 2013 ...
I found a couple of useful answers for KPIs:
Using calculated fields as KPI
Using Today and Me in Calculated Columns
Edits based on comments:
Make sure you calculated column is formatted to return a number, as that's the trick for rendering HTML.
You can try making your calculated field just =(RIGHT(LEFT(CASES,2),1) and see what it returns. When you ...
Currently there is no way to hide availability status for external users.
Please vote for this feature in Microsoft Teams UserVoice:
There is nothing we can do. The document properties do not have a column setting in Word client similar to the one in SharePoint library, yet changing the settings in SharePoint will not affect the properties in Word either.
Another thing you should notice, since there is no choice type in the default document properties, the Status column in SharePoint will ...
Have you enabled minor versioning on the document library?
Minor versions will allow you to have drafts of the document and only editors/approvers can see the draft versions (this setting can be changed).
One option is to modify your list view:
In your list view, you could set a filter that states "Show the items when column 'Status' is equal to 'Open' (and whatever options you have other than 'Closed').
As far as the time passed issue is concerned, the filter could be set to the Created column as well - something along the lines of when Created is ...
There was a very similar article written here that you can get this information using PowerShell.
How to get running workflow instances on listitems in powershell?
$spSite = Get-SPSite "https://portal.myCompany.net/teams/siterequests/" # SiteCollection
$spWeb = $spSite.OpenWeb()
for($i = 0; $i -le $spWeb.Lists....
If you wrap this in a User Custom Action Scriptlink
it can execute on every page
SP.UI.Notify.addNotification return id of the newly created notification (DOM element). It also attaches click handler on child div element, what you can do is unbind click event by replacing child div with copy:
var notifId = SP.UI.Notify.addNotification("Some process is running...", true);
var old_element = document.querySelector("#" + ...
You can keep the current workflow as it is. Create a second workflow that pauses for 2 days and then checks whether the manager has approved or not. If the manager has not approved, then email the director.
Your scenario is quite common and so is this solution. You do not need to worry about having two workflows instead of one.
When a SPD workflow creates a task, it outputs a item GUID representing the list item of the task created.
Using this GUID, you will be able to use the workflow action "Update Item in List" to reference the task list, specify your updated field values in the task list and then, this is the key bit, set the Lookup field to 'GUID' and the 'where' drop down to ...
The simplest way is to use a Calculated Column (set to datatype=Number!!! to output HTML)
=IF(NOT(OR([Task Status]="Not Started",[Task Status]="Completed"))
, "<div style=""position:relative;width:100%;height:1.5em;border:1px solid grey;"">"
Its looks fine. Unfortunately we have no debugger for workflows so use workflow log history to check and also recheck proper arrangement of lines .
`Stage:Approve New Document
Log Workflow Started to the workflow history list
Set Workflow Status to Something // set initial status
Log Workflow Started to the workflow history list // check initial status
There are multiple ways to achieve this
Open the Pages library settings and then choose "Manage files which have no checked in version". This will give you the information
You can create a new view and choose field "Checked Out To". Then group by that field.
Interesting friday evening challenge..
I took a completely weird approach
process every row (when displayed)
store the High, Low , Total and Average value on the body tag
for every row done (they proces async)
calculate the 3 segments (low,medium,high) between the Low Values
calculate Average, match with low,medium,high color
and color the Table (4 ...