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

Currency Enhancement

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

| |
|---|---|---|

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

|
|---|---|

Misc

• 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 $pt.name$ - 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.

| |
|---|---|---|

UI Enhancement

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

|
|---|---|

|
|---|---|

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

https://user-images.githubusercontent.com/61551451/170499118-931e9ae6-e31a-48db-a6f5-f370edebae0c.mov

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 https://github.com/nocodb/nocodb/pull/2125
• fix: add btw and nbtw filters by @vijayrathore8492 in https://github.com/nocodb/nocodb/pull/2129
• feat/fix: currency column by @mertmit in https://github.com/nocodb/nocodb/pull/1687
• fix: issues related to formula by @wingkwong in https://github.com/nocodb/nocodb/pull/2132
• Fix/development setup documentation by @RK311y in https://github.com/nocodb/nocodb/pull/2139
• docs: add RK311y as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/2141
• fix: github action issues by @wingkwong in https://github.com/nocodb/nocodb/pull/2137
• fix: Support Airtable import even mapped to a different port by @pranavxc in https://github.com/nocodb/nocodb/pull/2134
• fix: include all v-app but exclude material-icons by @wingkwong in https://github.com/nocodb/nocodb/pull/2161
• enhancement: formula by @wingkwong in https://github.com/nocodb/nocodb/pull/2160
• ColorPicker component by @mertmit in https://github.com/nocodb/nocodb/pull/2151
• enhancement: column icons by @wingkwong in https://github.com/nocodb/nocodb/pull/2163
• enhancement: create index for foreign key in pg by @pranavxc in https://github.com/nocodb/nocodb/pull/2165
• feat: Use a separate queue and job for progress by @pranavxc in https://github.com/nocodb/nocodb/pull/2170
• Enhancement: UI improvements by @pranavxc in https://github.com/nocodb/nocodb/pull/2164
• Fix/at sync: store link records by @dstala in https://github.com/nocodb/nocodb/pull/2156
• Feat/sync options by @pranavxc in https://github.com/nocodb/nocodb/pull/2175
• 0.91.1 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/2178

New Contributors

• @RK311y made their first contribution in https://github.com/nocodb/nocodb/pull/2139

Full Changelog: https://github.com/nocodb/nocodb/compare/0.91.0...0.91.1

Join Our Team