You need to sign in to do that
Don't have an account?
TheLearner
Trigger to populate the recent value in the fileds
Hi Experts,
My requirment is i have object called Site__C it contains fields called , Public_Site_Clear__c,Private_Site_Clear__c,Site_Clear__c so what we need to do that
When Public Site Clear(Public_Site_Clear__c) and Private Site Clear(Private_Site_Clear__c) dates are both populated, trigger the update (on initial population only) of the Site Clear(Site_Clear__c) field with the latest date. i.e Public Site Clear = 23/10/2015, Private Site Clear = 02/11/2015, therefore Site Clear = 02/11/2015. If the dates are subsequently changed then do nothing.
Could anyone help me pleaase
My requirment is i have object called Site__C it contains fields called , Public_Site_Clear__c,Private_Site_Clear__c,Site_Clear__c so what we need to do that
When Public Site Clear(Public_Site_Clear__c) and Private Site Clear(Private_Site_Clear__c) dates are both populated, trigger the update (on initial population only) of the Site Clear(Site_Clear__c) field with the latest date. i.e Public Site Clear = 23/10/2015, Private Site Clear = 02/11/2015, therefore Site Clear = 02/11/2015. If the dates are subsequently changed then do nothing.
Could anyone help me pleaase
--
Regards,
Swayam
@Salesforceguy
Could you tell me how i need to write workflow as they mentioned ,i need to check Public Site Clear(Public_Site_Clear__c) and Private Site Clear(Private_Site_Clear__c) dates when they are populuated then i need to populate Site Clear(Site_Clear__c) date with latest date
Try these steps to resolve your problem
go to workflow.
Choose the object
In evaluation criteria select "created, and every time it is edited"
Rule criteria >> formula evaluates to true
Use below formula.
ISCHANGED(Private_Site_Clear__c) || ISCHANGED( Public_Site_Clear__c )
go to workflow action select field update
choose field to update "Site_Clear__c"
Use below formula to update the field.
if( Private_Site_Clear__c > Public_Site_Clear__c , Private_Site_Clear__c,Public_Site_Clear__c)
Mark this as resolved if the issue is resolved. Feel free to reach if you still have any further concern.
Regards,
Sanpreet