NocoDB - 0.91.1

🚀 NocoDB : Enhancement Release : Import Airtable to SQL database

What's New

  • 🚀 Import from Airtable to NocoDB Enhancement
  • 🚀 Currency Enhancement
  • 🚀 Formula Enhancement
  • 🚀 Rating Enhancement
  • 🚀 UI Enhancement
  • 🚀 And we're hiring! 🚀

Import from Airtable to NocoDB Enhancement

While importing Airtable to NocoDB, now users can have full flexibility to choose the major column types that they would like to import. Currently, data, rollup columns, lookup columns and attachment columns will be supported. Formula Columns will be supported in the future.

Screenshot 2022-05-27 at 4 39 11 PM

Currency Enhancement

We now support multiple currency locale and currency code (ISO 4217) and some validation logics have been also revised.


image | image | image

Formula Enhancement

Handle NULL value when calling CONCAT

Previously any NULL value in formula with CONCAT would make the entire result empty. Now it's considered as an empty string instead.

Example: F: CONCAT({Title}, {Title1}, {Title2}, "B")


Include icons in formula suggestion list

image | image


  • Show column options in suggestion list when users enter { as what's following must be a column.
  • Fix the incorrect insertAtCursor position when calling appendText. Previously selecting column1 after { would become {{column1} while {column1} is expected.
  • Fix incorrect ID passing to FormulaColumn.update. Previously deleting a column that is referenced by a formula would throw an error and all data will be not shown when calling dataList as something wrong with the cache part as attribute error is not updated due to the wrong ID.
  • Fix incorrect data type - e.g. ADD({numberic_formula}, 10) should be expected.
  • Fix formula precedence
  • Remove unexpected $$ - create a formula and edit it. {$column_name$} is shown rather than {column_name}.

Rating Enhancement

A custom color is now supported in a Rating column. You can select the predefined colors from our swatches or choose your desired one using a color picker in advanced settings. Manually inputting color is also supported with the format HEX, HSL and RGB.

image | image | image

UI Enhancement

We've added transition for menus (filter / sort / fields) with icons within the menu items.

image | image

image | image

A loader is introduced for Grid & Gallery view when the data is being loaded.

Closed Issues

  • [Status: Fixed][Priority: Low][Type: In Development] [shared base] hide webhook button in shared base #2107
  • [Status: Fixed][Type: In Development] gallery view- configured cover image not displayed #2099
  • [Status: Fixed][Type: In Development][Import] [import] with cache enable- sometimes during table data list, error observed referring to an non-existing column #2098
  • [Status: Fixed][Type: In Development][Import] [import] post import, data disappears from table on deleting column #2097
  • [Status: Resolved][Type: In Development][Import] [import] default value configuration throws error #2102
  • [Status: Resolved][Type: In Development][Import] [import] post import, grid view creation failed #2087
  • [Status: Resolved][Type: In Development][Import] [import] column skeleton persists in shared view after delete #2079
  • [Status: Resolved][Type: In Development][Import] [import / root db: sqlite] post import, column delete fails #2078
  • [Status: Resolved] Can't import XLSX - /dashboard/?q=sqlOp_projectCreateByWebWithXCDB 404 #2005
  • [Status: Resolved] implement exist API in v2 #2064
  • [Status: Resolved] Problem with SingleSelect Column #2059
  • [Status: Resolved] [i18n] Language Improve - #2049
  • [Status: Resolved][Status: Fixed] Unable to upload .xlsx file #1851
  • [Status: Resolved][Status: Fixed] Changing the Persian strings' font in NocoDB interface #1610
  • [Status: Fixed][Type: In Development] [UIDT improvements] validation #2038
  • [Status: Fixed][Type: In Development] [UIDT-improvements] Rating field error on inserting record #2036
  • [Type: Bug][Status: Resolved] failed to create columns in tables with whitespaces at the end #2073
  • [Type: Bug][Status: Fixed][Status: Reproducible] Send ID with DELETE webhook? #2024
  • [Type: Bug][Status: Fixed] Nested fields query param does not respect '*' to include all fields #1981
  • [Type: Bug][Status: Fixed][Status: Reproducible] Formula fields throw an error when referencing fields that start with a number #1964
  • [Type: Bug][DB: Postgres][DB: SQLite][DB: MSSQL][Status: Fixed][Status: Reproducible] Single select issues (reported in discord) #1955
  • [Type: Bug][DB: Postgres][Status: Fixed][Status: Reproducible] Can't change the type of the default column "title" #1949

What's Changed

  • Release 0.91.0 by @github-actions in
  • fix: add btw and nbtw filters by @vijayrathore8492 in
  • feat/fix: currency column by @mertmit in
  • fix: issues related to formula by @wingkwong in
  • Fix/development setup documentation by @RK311y in
  • docs: add RK311y as a contributor for code by @allcontributors in
  • fix: github action issues by @wingkwong in
  • fix: Support Airtable import even mapped to a different port by @pranavxc in
  • fix: include all v-app but exclude material-icons by @wingkwong in
  • enhancement: formula by @wingkwong in
  • ColorPicker component by @mertmit in
  • enhancement: column icons by @wingkwong in
  • enhancement: create index for foreign key in pg by @pranavxc in
  • feat: Use a separate queue and job for progress by @pranavxc in
  • Enhancement: UI improvements by @pranavxc in
  • Fix/at sync: store link records by @dstala in
  • Feat/sync options by @pranavxc in
  • 0.91.1 Pre-release by @github-actions in

New Contributors

  • @RK311y made their first contribution in

Full Changelog:

Join Our Team


May 27, 2022, 1:54 p.m.
Register or login to:
  • 🔍View and search all NocoDB releases.
  • 🛠️Create and share lists to track your tools.
  • 🚨Setup notifications for major, security, feature or patch updates.
  • 🚀Much more coming soon!
Continue with GitHub
Continue with Google