none
Date Validation in Project Server 2013 SharePoint Project Sites RRS feed

  • Question

  • The requirement is that any date that is entered within the Risk, Issues and Change Request list cannot exceed the Project Start and Project End dates.

    The solutions that have been explored

    1.        Method 1 (SharePoint Field Validation)
      1.        A workflow has been created to bring in the dates to the Item
      2.       The validation field had the formula entered with the condition
      3.        Issue
        1. i.      Field Validation limitation is single field comparison
        2. ii.      The validation is constantly running so Project Start and End cannot  be null so the fields were defaulted to (Current Date for Start and 31/12/2015 for End)
        3. iii.      As the Due Date or Close Date could be null this method threw an error that would stop the workflow
    2.        Method 2 (SharePoint List Validation)
      1.        A workflow has been created to bring in the dates to the Item
      2.       The validation was done at List level with the formula entered with the condition
      3.        Issue
        1. i.      The validation is constantly running so Project Start and End cannot  be null so the fields were defaulted to (Current Date for Start and 31/12/2015 for End)
        2. ii.      As the Due Date or Close Date could be null this method threw an error that would stop the workflow
    3.        Method 3 (SharePoint Feature)
      1.        A workflow has been created to bring in the dates to the Item
      2.       Built in a SharePoint Feature using Dot Net (C#)
      3.        Deployed and Activated the Feature on the Instance
      4.       Issue
        1. i.      The system continuously throws errors in regards to
          1.        Sandbox
            1.        We had to change a Windows Registry for a Value
            2.       Restarted the Sandbox Service
            3.        Restarted the IIS Service
          2.        Objects
            1.        Restarted the Timer Service
    Wednesday, September 2, 2015 3:16 AM