User Approval for a Non Task Custom Table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-26-2020 04:51 AM
Hello,
I am quite new to Flow Designer hence I would need a small help.
I have a Custom table A which references to a Table B. Table B has a user record C.
I would like to Create an Approval flow from A to end up all the approvals to C.
Table A is not extended from Task table.
How would I be able to achieve this? Could it be done using Flow Designer ?
Thanks,
Avik
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-26-2020 06:13 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-26-2020 06:30 AM
Hi
Approvals are stored in the table "sysapproval_approver".
There is a field "source_table", that you need to fill with your custom table to reference the Approval to your custom table. The field "document_id" holds the sysID of the record in your table, where you want to link the Approval to.
If you want to show the approvals as a related List to your table, you need to set up a table relation between the custom table and the approval table.
For testing, you can just go via the "sysapproval_approver.list" List.
Using the "approval_column" field in the "sysapproval_approver" table you can define, to which field in your custom table the decision of the approval record will be populated.
Let me know if that answers your question and mark my answer as correct and helpful.
BR
Dirk