function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
LorrMcLorrMc 

Is there anyway I can tick a box on a related record for the earliest created based on criteria?

Hi, 

I have this process which I have used in the past to populate the most recent related record however now I am trying to use it in reverse in the hope I can populate the earliest related record based on start date and that has a tick box of true. 
This looks at a junction object "CPR" that has two contact record types one for "client" and one for "Carer" what I need to do is tick a box on the "CPR" record but only if the tick box "First Scotland Placement" field is true and on the record with the earliest start date but only for the "Carer" record. 

I hope this makes sense and you can please help me as I am no good with triggers and trying to avoid this approch, do I need a flow? 

User-added image

User-added image

User-added image

User-added image

Thank you in advance,

Lorrr