Business Rule to update change/approval/group approval

[Matt B4]

Our sysapproval_approver table has a custom field called Role (u_role) which is populated based on an evaluation of the approver, fields on the change request, and the assignment group of a group approval.

The main issue I'm having is when to set the business rule to run, and on which table. The one I'm having an issue with is running on the sysapproval_group table. When the group approval is inserted, it needs to query the change record and the group approval in order to populate the u_role field on the sysapproval_approver table. I'm unclear on the relationship between the individual and group approval and what order those records get submitted in. My current rule is set to run after insert/update, but the values are not being updated. Any insight is appreciated, and I can provide more information on request. Thank you!

[Matt B4]

Hi Asifnoor,

before insert was the key, thank you very much for your help!