NocoDB 0.91.0 — Release Notes & Engineering Impact

# 🚀 [NocoDB](https://nocodb.com) : Feature Release : Import Airtable to NocoDB <img width="1192" alt="Screenshot 2022-05-23 at 11 23 23" src="https://user-images.githubusercontent.com/5435402/169799409-c360ece8-7ef0-447a-a93f-aba02f83288a.png"> ## What's New : - 🚀 Import Airtable to NocoDB - 🚀 Import CSVs, Excel to NocoDB - 🚀 New APIs : GroupBy and Exists - 🚀 Column improvements : Ratings - 🚀 Formula enhancements - 🚀 And we're [hiring](http://careers.nocodb.com)! 🚀 # Import Airtable to NocoDB Now within a minute or two import all your Airtable bases to any MySQL, Postgres, SQL server or SQLite databases using NocoDB! https://user-images.githubusercontent.com/61551451/169801882-b36c7b79-a29d-40ad-bbf5-5807b9cf611c.mov See <a href="https://docs.nocodb.com/setup-and-usages/import-airtable-to-sql-database-within-a-minute-for-free" target="_blank">Documentation - Import Airtable to NocoDB</a> for details. ## Import from CSV We support users to import CSV data to an existing project. See <a href="https://docs.nocodb.com/setup-and-usages/table-operations#import-csv-data-into-an-existing-project" target="_blank">Documentation - Import CSV data into an existing project</a> for details.  ## Import from Excel We support users to import Excel data to an existing project. If an Excel file includes multiple sheets, they will be considered as different tables and users can manipulate the meta before the actual import. See <a href="https://docs.nocodb.com/setup-and-usages/table-operations#import-excel-data-into-an-existing-project" target="_blank">Documentation - Import Excel data into an existing project</a> for details.  # New APIs We've introduced two new APIs - exist & groupby. ## Exist Exist API allows users to check if the row with provided primary key(s) exists or not. The result would be either `true` or `false`. For table row, ```bash curl --request GET \ --url 'http://localhost:8080/api/v1/db/data/<org>/<projectName>/<tableName>/<ID>/exist' \ --header 'xc-auth: <REDACTED>' ``` For table view, ```bash curl --request GET \ --url 'http://localhost:8080/api/v1/db/data/<org>/<projectName>/<tableName>/views/<viewName>/<ID>/exist' \ --header 'xc-auth: <REDACTED>' ``` ## GroupBy Given a column name, return the number of records in each group. For table row, ```bash curl --request GET \ --url 'http://localhost:8080/api/v1/db/data/{orgs}/{projectName}/{tableName}/groupby?column_name=<COLUMN_NAME>' \ --header 'xc-auth: <REDACTED>' ``` For table view, ```bash curl --request GET \ --url 'http://localhost:8080/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/groupby?column_name=<COLUMN_NAME>' \ --header 'xc-auth: <REDACTED>' ``` # Rating Rating allows users to rate based on a comparative assessment with maximum rating allowed from 1 to 10. Users may change the rating symbol and color as well.   |  :-------------------------:|:-------------------------:  |  # Formula enhancements - Add information message when double clicking formula cell and add help text by hovering the function name  |  |---|---| - Add circular reference detection. Example: `formula1 -> formula2 -> formula3 -> formula4 ("HELLO")`.  |  |---|---| - Improve formula argument validations  |  |---|---| ## Closed Issues - [**Status: Fixed**][**Type: In Development**] [quick import] form view drag & drop opens up import modal [#2044](https://github.com/nocodb/nocodb/issues/2044) - [**Status: Fixed**][**Type: In Development**] [quick import] shared base view mode - displays add table header [#2043](https://github.com/nocodb/nocodb/issues/2043) - [**closed**] Feature request : Enforced primary key should be selectable non-integer [#2006](https://github.com/nocodb/nocodb/issues/2006) - [**Type: Bug**][**DB: All**] DateTime value not saved [#1978](https://github.com/nocodb/nocodb/issues/1978) - [**Status: More Info Needed**][**Status: Fixed**] Synologoy NAS : the 0.90.10 docker container crash [#1970](https://github.com/nocodb/nocodb/issues/1970) - [**Type: Enhancement**][**Status: Need Internal Discussion**] Query parameter to limit fields in returned relations [Feature] [#1763](https://github.com/nocodb/nocodb/issues/1763) ## What's Changed * fix: Including all fields of nested record by @pranavxc in https://github.com/nocodb/nocodb/pull/1984 * fix i18n for zh_CN by @youyiio in https://github.com/nocodb/nocodb/pull/1985 * fix: Postgres column type casting by @wingkwong in https://github.com/nocodb/nocodb/pull/1991 * fix: excel import by @wingkwong in https://github.com/nocodb/nocodb/pull/1931 * fix: single/multi select options at creation by @mertmit in https://github.com/nocodb/nocodb/pull/1986 * fix: persian font by @wingkwong in https://github.com/nocodb/nocodb/pull/2028 * fix: webhook-related issues by @wingkwong in https://github.com/nocodb/nocodb/pull/2025 * fix: formula by @wingkwong in https://github.com/nocodb/nocodb/pull/1979 * fix: google oauth2.0 by @vijayrathore8492 in https://github.com/nocodb/nocodb/pull/2080 * feat: quick import by @wingkwong in https://github.com/nocodb/nocodb/pull/2042 * feat: Airtable import by @pranavxc in https://github.com/nocodb/nocodb/pull/2048 * feat - Next release improvements and bug fixes by @pranavxc in https://github.com/nocodb/nocodb/pull/2120 * feat : UIDT impmporovements by @pranavxc in https://github.com/nocodb/nocodb/pull/2026 * feat/at sync test: migration fixes by @dstala in https://github.com/nocodb/nocodb/pull/2068 * feat/at sync test - simple cleanups by @dstala in https://github.com/nocodb/nocodb/pull/2071 * feat - UUID auto generate and bug fixes by @pranavxc in https://github.com/nocodb/nocodb/pull/2069 * feat: exist api by @wingkwong in https://github.com/nocodb/nocodb/pull/2070 * feat: group by api by @vijayrathore8492 in https://github.com/nocodb/nocodb/pull/2074 * GUI code refactoring by @pranavxc in https://github.com/nocodb/nocodb/pull/2051 * fix/2012 Migration bug fixes by @pranavxc in https://github.com/nocodb/nocodb/pull/2053 * Update zh_TW.json by @SiderealArt in https://github.com/nocodb/nocodb/pull/2057 * Update german.md by @WeT-Klb in https://github.com/nocodb/nocodb/pull/1998 * docs: add youyiio as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/1990 * docs: improve chinese translation by @Tim-Paik in https://github.com/nocodb/nocodb/pull/2050 * enhancement: formula by @wingkwong in https://github.com/nocodb/nocodb/pull/2090 * 0.91.0 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/2124 * 0.90.11 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/1972 * Release 0.90.11 by @github-actions in https://github.com/nocodb/nocodb/pull/1973 ## New Contributors * @youyiio made their first contribution in https://github.com/nocodb/nocodb/pull/1985 * @Tim-Paik made their first contribution in https://github.com/nocodb/nocodb/pull/2050 **Full Changelog**: https://github.com/nocodb/nocodb/compare/0.90.11...0.91.0 # Join Our Team <p align=""><a href="http://careers.nocodb.com" target="_blank"><img src="https://user-images.githubusercontent.com/61551451/169663818-45643495-e95b-48e2-be13-01d6a77dc2fd.png" width="250"/></a></p>