I am trying to update a field on a master object based on couple of values{criteria needs to be if Status = Approved on the header - thats when it should fire, then check if Y(at line level) is equal to 'Y' and then come back to header and update Z ='z'} .
I don't want this to fire on creation/edition of the record but rather when the particular criteria met(In my case as soon as Status=Approved). I understand I can use WF/PB with the criteria to fire even when the record is Edited but:
that would mean it would fire off everytime and I just want it to fire the only first time when the record status = Approved and not after that.
Somehow change in status is not counted as an Edit so my PB ignores it all together and does not fire. But if I go in and manually edit any field it fires without any issue. How can I make it fire with just the status change on field level via an automated process.
Am I over-complicating this? Do I need to use trigger?