0.91.1

版本发布时间: 2022-05-27 21:54:01

nocodb/nocodb最新发布版本:0.255.2(2024-08-29 21:14:27)

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

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 - <zh-CN> #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