I've 3 objects A(GrandParent), B(Parent), C(child).
Now I want to update a field of GrantParent(A) using field of child C, based on some conditions through process builder.
But tricky part is : I want to consider only those child C records which are linked to 'most recent' Parent record, to update GrandParent A.
For e.g, Say A has record A1. And A1 has two associated records, Child B1 and B2 and B2 is latest.
I want to consider Child C records associated with B2(Not B1) to update A1. Similary if later on, B3(new record) comes up ,then only child records associated with B3 should be updating A1.
Is this possible without invoking APEX throughProcess builder ?
I'm not able to find criteria(to select 'most recent' B's record) while creating step of process builder, that uses object C to update A