Approval Workflow

EDITable's live database connection allows for real-time data updates and synchronization. While row and column-level access permissions ensure data integrity, you can go one step further to secure your data by setting up approval workflows.

In a team, users might need management's approval before making any data changes to ensure correctness and accuracy. There can be scenarios like multiple users accidentally changing the same data, entering incorrect values, etc. All these can be managed by setting up an approval workflow process in EDITable and then selecting the approvers.

Steps to set up approval workflow

Enabling Approvals in EDITable
Selecting approvers by specifying the method
Setting up the handling of approvals, if necessary

Once enabled, every change made by users undergoes an approval process before getting saved and synced to the source.

Whenever a change is made,

Approvers receive an email notification about the change request made along with details such as the request ID, name of the table, database, and author who initiated it.

The changes are indicated in the table based on how they have been set to be handled (Persistence modes).

Approvers can review the log in the 'Review' tab and choose which changes to approve or reject.

After approval or rejection, the user who made the change is notified via email.

The approver can also propose changes to the author.

The author can choose to make the suggested changes and send it again for review.

The approved changes are synced to the source.

This section explains all of the above in detail.

1. Enable Approvals

You can turn on the approval workflow by following the steps below:

Navigate to Settings -> Approvals.
Toggle on the Enable Approvals button.

2. Select Approvers

The next step is to select the approvers who will review and approve any changes made to the table.

There are three ways to select approvers.

Manually entering the email IDs of approvers or IDs of AD groups (Active Directory Groups)
Configuring a rule-based system to identify the approvers
Using a lookup table to establish the rules.

Here's a detailed guide to each method:

2.1. Enter the List of Approvers

This is a straight-forward method where you will manually specify individuals who will act as approvers. This method allows you to select specific users in the workspace by typing their names or email addresses who will be responsible for reviewing and approving the changes.

2.2. Add Rules to Identify Approvers

Define approvers for specific columns or records in the table based on set rules and criteria. Enter the rule name, the filter criteria, and the designated approvers for that rule. You can set as many rules as required and assign corresponding approvers for each.

Note that rules are executed in the order they are added and can be reordered.

The detailed steps are as follows:

Select Add rules to identify approvers.
Click Add Rule to add a rule.

In the pop-up, enter a name for the rule, filter criteria and approvers for the criteria and click Add.

You can add multiple filters/criteria within a rule and combine them using AND or OR operators as below:

To delete a filter criteria, use the bin icon.

After clicking Add, you can find the rule added to the list of rules. You can add more rules by selecting Add Rule.

Use the options as highlighted below to edit, re-arrange, or delete a rule.

Default Approver: In the final step, add one or more default approvers who will approve the changes that do not meet the above-configured rules/criteria. Click Save and you are good to go.

2.3. Lookup Rules from a Table

In this method, you can configure the rules and approvers list by looking up data from another table. The options are explained below:

Table: This dropdown menu displays a list of tables in the connection. Select the table from which the approvers list is to be looked up/fetched.
Approvers: Choose the column containing the approvers' email IDs.
Conditions: Map columns from the lookup table to the corresponding columns in the source table to join the tables. You can set multiple conditions (join multiple columns) as needed.

For example, let us assume each brand in the lookup table has a person-in-change with their corresponding Email IDs added in the Email ID column. By mapping the columns 'brand' from both tables, we allow the corresponding approvers' email IDs to be fetched for each brand.

Default Approvers: Specify the default approvers to approve other changes that do not involve the above set conditions.

Click on Preview Rules to view the approvers list for each brand. In the example below, we have the same approver for all brands.

You can use the Sync Rules option to sync the connected lookup table to fetch the latest data. The last sync details and the status can also be seen.

3. Handling Approvals - Persistence Mode

In this section, you can specify your preferences for managing approvals. There are two options available.

3.1. Require Approval Before Saving

In this method, users must get approval before saving any changes to the data. This is the default mode.

After making changes, clicking on Save opens the pop-up below, where you can add the description and priority of the change. Click Submit to send them to the approver.

The table below illustrates the changes made, highlighted in yellow. Hovering over the marked areas displays detailed information about the changes.

3.2. Save with Pending Approval Status

In this option, the changes are saved and synced to the database with a 'pending review' status flag. The rows marked as pending are sent for review. Once approved, the status column will be updated to reflect the approved flag, and the data will also be updated accordingly.

Choose any existing column from the table to reflect the status flag field. We have used the column 'Active' in the example below, where the status is recorded.
Enter the required text to be displayed for each state, such as pending for review, approved record, and rejected record.
Click Save.