🚀 NocoDB : Feature Release : Import Airtable to NocoDB

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! 🚀

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 Documentation - Import Airtable to NocoDB for details.

Import from CSV

We support users to import CSV data to an existing project.

See Documentation - Import CSV data into an existing project 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 Documentation - Import Excel data into an existing project 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,

curl --request GET \
--url 'http://localhost:8080/api/v1/db/data/<org>/<projectName>/<tableName>/<ID>/exist' \
--header 'xc-auth: <REDACTED>'

For table view,

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,

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,

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
• [Status: Fixed][Type: In Development] [quick import] shared base view mode - displays add table header #2043
• [closed] Feature request : Enforced primary key should be selectable non-integer #2006
• [Type: Bug][DB: All] DateTime value not saved #1978
• [Status: More Info Needed][Status: Fixed] Synologoy NAS : the 0.90.10 docker container crash #1970
• [Type: Enhancement][Status: Need Internal Discussion] Query parameter to limit fields in returned relations [Feature] #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