2

I am running SharePoint 2013 and have a column that is supposed to determine whether or not each phase of a project is late. I am using the NOW() fucntion, which, of course, does not update dynamically - only when the item is edited.

=IF(INT(NOW())-INT([Define/Concept End Date])>0,"Late","On Time")

I have seen two solutions: powershell and custom SPD workflow. I do not have access to SPD. As I understand it, I would need admin rights to run the powershell script, which I don't have either.

Is there a way to force all items to update every day using, say, javascript? I know I can embed javascript in the page. I am open to any other solutions that might be out there as well.

Thanks

1
  • As for PowerShell, you can run it from other machines, even client workstations, but then you have to use client APIs (SOAP or REST) rather than Microsoft.SharePoint.PowerShell Oct 15, 2014 at 19:40

4 Answers 4

6
+50

If you only use this for display purposes, why not use a different approach which does not require you to do updates on the list item at all....

  1. Create the site column in a sandboxed solution.
  2. Your column stores the Due date.
  3. Create a javascript file to deploy somewhere to your site, e.g. /Documents/duedate.js

  4. Configure the JSLink property in the site column. Point it to the deployed javascript file, e.g. /Documents/duedate.js

The magic happens in the duedate.js file:

siteCtx.Templates.Fields = {
// MyCustomField is the Name of our field
   'MyCustomField': {
   'View': customView
  }
};
// Register the template to render custom field
SPClientTemplates.TemplateManager.RegisterTemplateOverrides(siteCtx);
// View Page custom rendering
function customView(ctx) {
  if (ctx != null && ctx.CurrentItem != null) {
    var endDate= parseInt(ctx.CurrentItem["Concept End Date"]);
    if (endDate < new Date()) {
         // this code is unverified.
         return "On time";
    } else {
        return "Late";
    }
  }
}
1

Caluclated Columns will be calculated each time they are displayed. You don't have to update items. :-)

The problem is your formula. Why do you try to convert it to INT?

SharePoint has very nice Calculated Field Formulas, see http://msdn.microsoft.com/en-us/library/office/bb862071%28v=office.14%29.aspx

A working example would be:

=IF(NOW()>[Define/Concept End Date],"Late","On Time")
3
  • I thought I had tried that originally and it didn't work... but I will try again. I shall report back in 24 hours whether or not this worked!
    – rphello101
    Oct 10, 2014 at 16:25
  • More than 24 hours... but this did not work. I still have to edit the item before the calculated column calculates.
    – rphello101
    Oct 14, 2014 at 18:26
  • 4
    Fensterbank must have mixed Computed and Calculated columns. Computed indeed update on display, while Calculated are stored in the database and not recalculated until edited. Oct 15, 2014 at 19:36
1

I don't have enough Rep to comment on the other answer but Calculated fields are updated at SAVE time.

Your Javascript idea could work if users viewing the list have permissions to update the items, otherwise it might update, or might not update.

Since you don't have SPD you don't have many other options but you can try designing a reusable workflow in another environment where you CAN use SPD. On the Workflow, call a save once a day after 12am, export it as a sandbox solution and deploy it at the other environment. You will need Site Collection Administrator permissions, but that might be easier for you to procure.

6
  • And an even better use of the JSLink (and actual intended use) is Boland's answer (don't have enough rep to vote up...)
    – Choggo
    Oct 15, 2014 at 1:54
  • I don't have use of SPD in any enviorment nor Site Collection Admin permissions. I work at a Fotune 1000 company - quite large. SharePoint is very locked down. Only a very small group in IT has that kind of access.
    – rphello101
    Oct 15, 2014 at 17:36
  • 1
    I think Boland's answer is the best solution for you problem.
    – Choggo
    Oct 15, 2014 at 18:43
  • Boland's answer is the best, unless some notification must be sent or another view populated based on that calculated column. Oct 15, 2014 at 19:42
  • 1
    Give me some votes up then :)
    – Boland
    Oct 19, 2014 at 8:04
0

This sounds more like a timer job should be made - that way the job can be managed via Central Admin. A workflow might work, but a timer job is more likely the correct way to update a field on a schedule.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.