I am working on a multi-level approval process in a model-driven app, where a table Report has a status column called Approval Status.
When Approval Status is Save, only the creator of this report can be viewed by the creator (Adam).
When the creator is ready to submit for approval, the creator can then set the status to Submit.
When the Approval Status column is Submit, the user assigned as the checker (Carl) for this report will then be able to view it in his list of reports, whereas others will not. Only the creator (Adam) will still be able to see it in his list, for obviously reasons, which is for him to know the status of the report, although no other actions can be taken on it.
When the checker (Carl) has finished checking the report and sets the Approval Status to Checked, the approver (Eddy) will then be able to see this report in his list. Likewise, the creator (Adam) will also be able to see this report in his list.
Creator (Adam) --> Checker (Carl) --> Approver (Eddy)
Can anyone advise whether this can be done?
The plan is to have up to 5 levels of approvals, hence at each stage of the approval process, only certain users can view certain records, depending on their roles.
