Hey everyone,
I've been trying to make two Approval Process Steps for one specific field (pick-list) but the second step never triggers. The logic is this:
When a record is created, the pick-list field has the default value 'waiting for approval'. While 'Status' has the value 'waiting for approval', the first approval process triggers where it asks from the GM to approve or decline the specific record. If rejected, the field 'status' changes (updates the value) to 'Rejected', while if the GM approves it, the field pick-list value updates to 'Approved by GM'.
The problem lies here. If the GM approves the approval process, the pick-list value indeed changes to 'Approved by GM'. I've made a second rule, then, where if the 'Status' field has the value 'Approved by GM', it asks for the second approval process step by a different user ('dealer'). So the logic for the second approval process is that if "Status = Approved by GM" then have the second user either approve or reject it (if approved, the field must become 'Approved by Dealer', if rejected, the field becomes 'Rejected').
The problem is that although the first approval process works fine and it does change the 'Status' field, the second approval rule never gets triggered.
I've tried many workarounds (workflow rules, dummy fields, and tried to write it in Deluge). From what I could find, this is probably happening because when a field gets updated through a function or an approval process, it doesn't get updated as a record (??)
Any help would be so important.
Thank you,