function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ravi1234.ax1565ravi1234.ax1565 

Field update on parent records having lookup relation

Hello Group,

 

                 I have Faculty(Name, Status("Available", "Assigned")) and Schedule(Name , Faculty, From Date, To Date) Sobjs

 so, My requirement is when i create a Faculty record with Satus is "Available" and it should change to "Assigned" one day after  ToDate . I have tried to achieve this  but iam not able to reach my requirement....

 

       Please help  me how to achieve this in a detail way

 

     Thanks for giving reply (in advance)

 

 

          Thanks and Regards

 

    

Avidev9Avidev9
Since it is a lookup field it has to be a trigger.
Can you post whatever you tried ?
ravi1234.ax1565ravi1234.ax1565

Thanks for giving reply

 
             in order to achieve my requiremnet i have tried through Time based workflow rules Based on ToDate but i have failed to give workflow action Field update Because of lookup relation. The Status Field is in parent object but iam trying to update this field based on ToDate(in Detail object). 
 
      can u please guide me how to trigger to achieve this

 

         My requirement is the Status field is to be updated from "Available" to "Assigned"  one day after Todate

 

 

      
Thanks and Regards
vmanumachuvmanumachu

You can use Schedule Apex feature for your requirement. Follow the below links to get an idea

 

http://www.chiragmehta.info/chirag/2009/11/13/salesforce-steps-to-schedulereschedule-apex-apex-scheduler/

http://www.chiragmehta.info/chirag/2009/11/12/salesforce-schedule-apex-to-run-at-any-time-interval/
Avidev9Avidev9
Seems like this was answered earlier. Have a look at
http://boards.developerforce.com/t5/General-Development/Initiate-Apex-code-at-a-future-date/m-p/621023#M93970

AND

http://blogforce9.blogspot.in/2013/05/synchronising-apex-triggers-with.html