Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • Steps to set up approval workflow
  • 1. Enable Approvals
  • 2. Select Approvers
  • 2.1. Enter the List of Approvers
  • 2.2. Add Rules to Identify Approvers
  • 2.3. Lookup Rules from a Table
  • 3. Handling Approvals - Persistence Mode
  • 3.1. Require Approval Before Saving
  • 3.2. Save with Pending Approval Status

Approval Workflow

PreviousRow Access ControlNextReview Changes - Workflow process

Last updated 4 months ago

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

  1. Enabling Approvals in EDITable

  2. Selecting approvers by specifying the method

  3. 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:

  1. Navigate to Settings -> Approvals.

  2. 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:

  1. Select Add rules to identify approvers.

  2. Click Add Rule to add a rule.

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

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

  1. To delete a filter criteria, use the bin icon.

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

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

  1. 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.

  1. 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.

  2. Enter the required text to be displayed for each state, such as pending for review, approved record, and rejected record.

  3. Click Save.

After making the changes to the table, you need to click on Save to send it for review. This saves the data with the status column.

The saved changes are displayed as below, with the status flag: 'Pending':

In the next section, we will discuss the process flow of review and approval in detail.

☑️
☑️
☑️
☑️
☑️
☑️
☑️
Enable approvals
Enter list of approvers
Add rule
Adding criteria
Adding more than one filter criteris
Deleting a filter criteria
Rule added
Edit/delete rules
Default Approvers
Look up table for rules
Preview Rules
Persistence mode
Send for approval
After submitting the changes
Configuring the text for status flags
Save and proceed for approval
Saved changes with the status