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

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 #1984
• fix i18n for zh_CN by @youyiio in #1985
• fix: Postgres column type casting by @wingkwong in #1991
• fix: excel import by @wingkwong in #1931
• fix: single/multi select options at creation by @mertmit in #1986
• fix: persian font by @wingkwong in #2028
• fix: webhook-related issues by @wingkwong in #2025
• fix: formula by @wingkwong in #1979
• fix: google oauth2.0 by @vijayrathore8492 in #2080
• feat: quick import by @wingkwong in #2042
• feat: Airtable import by @pranavxc in #2048
• feat - Next release improvements and bug fixes by @pranavxc in #2120
• feat : UIDT impmporovements by @pranavxc in #2026
• feat/at sync test: migration fixes by @dstala in #2068
• feat/at sync test - simple cleanups by @dstala in #2071
• feat - UUID auto generate and bug fixes by @pranavxc in #2069
• feat: exist api by @wingkwong in #2070
• feat: group by api by @vijayrathore8492 in #2074
• GUI code refactoring by @pranavxc in #2051
• fix/2012 Migration bug fixes by @pranavxc in #2053
• Update zh_TW.json by @SiderealArt in #2057
• Update german.md by @WeT-Klb in #1998
• docs: add youyiio as a contributor for code by @allcontributors in #1990
• docs: improve chinese translation by @Tim-Paik in #2050
• enhancement: formula by @wingkwong in #2090
• 0.91.0 Pre-release by @github-actions in #2124
• 0.90.11 Pre-release by @github-actions in #1972
• Release 0.90.11 by @github-actions in #1973

New Contributors

• @youyiio made their first contribution in #1985
• @Tim-Paik made their first contribution in #2050

Full Changelog: 0.90.11...0.91.0

Join Our Team