Hello All,
I would like to know if we can use after/update BR to update substate field on change request form based on the fields on change_task also would like to know the trigger condition and table for the same
I am assuming table will be change_Request and type will be after/update
here's are some conditions-
If there are any pending approvals related - state should be Awaiting Reviewer,
If there are sub tasks which are not close complete - then the state should be Awaiting subtask closure,
If there are approvals and sub tasks pending - Awaiting Sub-task and reviewer closure
If approvals and sub tasks are done - - state should change to Review and Sub-task complete
All suggestions are welcome,
Thank you
