Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
WikWik 

Changes Required

Hi ,

I am looking for implementing the below mentioned changes an a custom object named "Equipment":


1) If ship date is 2013 then lock down both fields named  ship date and startup date (throw an error when anyone tries to edit an equipment with Ship Date 2013)
 
2) If ship date is greater than equal to 1st Jan 2014 then only 2 roles should be able to edit the startup date.

Thank You
pconpcon
You could do this with a validation rule, something along the lines of then don't allow the save.
  
AND(
    OR(
        AND(
            ISCHANGED(Ship_Date__c),
            YEAR(Ship_Date__c) - 1 != YEAR(TODAY) - 1
        ),
        AND(
            ISCHANGED(Startup_Date__c),
            YEAR(Startup_date__c) - 1 != YEAR(TODAY) - 1
        )
    ),
    AND(
            $Profile.Name != 'Allowed Profile 1,
            $Profile.Name != 'Allowed Profile 2'
    )
)

I haven't tested this forumla, so it might need a little bit of tweaking.  But this should also work when we switch to 2016 to keep the 2014 records the same.