# EDITable - v1.6 ## New ### **1. Rule-Based Access Control for updating and deleting rows** You can now define specific rules that grant permission for particular users to update or delete designated rows in the database. This feature improves data security and allows more granular control over data.

### **2. Bulk update rows by importing CSV or Excel files** * You can now update multiple rows at once by importing CSV or Excel files, similar to how you bulk-import new rows. The rows are updated based on matching primary keys from the file. * We have included two options here - '**Update'** with which you can update existing rows and **'Insert and Update'** when you need to insert new ones and modify the existing ones.

### **3. Import and Export Column Configurations** You can now export a saved column configuration to a flat file and import it back into a similar table in the visual. This feature allows you to replicate configurations easily, saving time by avoiding configuring everything from scratch. Please refer to [this section](https://docs.inforiver.com/editable/working-with-editable/manage-columns/import-export-configuration) to know more.

### **4. The 'Summary' option in columns for aggregate column summary** The new 'Summary' option provides a quick overview of column values, including the number of empty values, unique values, filled values, percentage of empty/filled/unique values, date range, earliest date, latest date, and so on. This allows you to quickly identify any data anomalies, such as missing data or unique values, as well as perform simple categorical analyses on large datasets, such as percent of empty rows, percent of unique values, date range, earliest and latest dates, and so on.

## Enhancements ### **1. AD group support in approvers list** You can now add AD groups (Active Directory groups) in the approvers list for Default and Rule-based approvers types.

### **2. Included the 'Submit for Review' option for rule-based approvals** Previously, the '[Submit for Review](https://docs.inforiver.com/editable/approval-workflow/review-changes-workflow-process#submit-for-review)' option was available only when approvers were set manually (Default method). This option has now been extended to rule-based approvals. ### Enhancements in EDITable console ### **3. Create EDITable reports for existing tables—right from the EDITable console** Usually, EDITable lets you [connect to an existing database](https://docs.inforiver.com/editable/getting-data-into-editable/connect-to-data) from a Power BI report, after which you can start editing the table. Now you can create and download EDITable .pbix reports for existing database connections directly from the console by clicking the option below:

Create EDITable reports for existing tables from the console

If the table has already been configured in EDITable, you'll be prompted to confirm whether the existing configurations can be restored. Clicking on **Proceed** restores the configuration from EDITable.

### **4. Table creation in the console: Configure input type, lookup and relations, description and default value** While creating a table from the console, you can configure the input type, lookup and relations for single-select/multi-select input, description, and default value directly from the EDITable console.

Configure input type, lookup and relations from the console

### **5. Option to select a specific sheet from Excel to import data** In the EDITable console, when you want to [import data from an Excel file](https://docs.inforiver.com/editable/getting-data-into-editable/create-a-table#id-2.-import-data) to create a table, you can choose the specific sheet you wish to import. Previously, 'Sheet1' would be automatically selected for import, by default.

### **6. Download multiple tables as a single PBIX report with each table on a page** We have added a 'Download Report' option in the console, allowing you to download multiple tables from a connection into a single PBIX report.