🚀 NocoDB : Bug Fix Release

Closed issue

• [closed] Access denied for user 'root'@'localhost' #2210
• [closed] package.json of nocodb-seed is not getting updated. #2203
• [Status: Fixed] Shared grid view having a formula column results in an error #2176
• [Status: Resolved][Type: AT Import] Import Airtable to Postgres database : type does not exist #2173
• [Status: Resolved][Type: AT Import] Import Airtable to SQL database : schema imported but not the data #2172
• [Status: Resolved][Type: AT Import] Import AirTable to SQL database : Missing 'rollup_function' property in request body #2171
• [Status: Resolved] Enhancement : Show column icons within fields, sort, filter menus/dropdowns #2162
• [Status: Resolved] Incomplete font changes and string overlaps for Persian language #2154
• [Status: Resolved] When table is slow to load - show a loading status #2150
• [Status: Resolved] Advanced options while importing : select lookup, rollup, formula, data. #2149
• [Status: Resolved] [Feature] Create index for foreign keys created on postgres #2142
• [Status: Resolved] CONCAT formula with URL fails. #2140
• [Type: Bug][Status: Fixed] [formula] precedence to be considered in formula #2128
• [Type: Bug][Status: Fixed][Type: AT Import] [Bug] Airtable import not working in Docker if mapped to a different port #2127
• [Type: Bug][Status: Fixed][Priority: Low][Type: In Development][Scope: UI / UX] column name display text overflow in shared base #2088
• [Status: Resolved][Type: In Development] [Import] SQL query mapping incorrect for multi-select #2058
• [Type: Bug][Status: Fixed] Currency field- validation fails if decimal fractions are used #1647
• [Type: Enhancement][Status: Fixed] [Feature] Currency Column Improvement #1352
• [Type: Enhancement][Status: Fixed] Currency validator crashing when not adding two decimal places #1042
• [Type: Enhancement][Status: Fixed] Currency fields always displayed with $ #572

What's Changed

• Release 0.91.1 by @github-actions in https://github.com/nocodb/nocodb/pull/2179
• fix: metaList missing orderBy by @willnewii in https://github.com/nocodb/nocodb/pull/2169
• enhancement: show scrollbar in fields menu by @pranavxc in https://github.com/nocodb/nocodb/pull/2183
• fix: alter_hooklog_payload_types by @willnewii in https://github.com/nocodb/nocodb/pull/2174
• fix: when_select_empty_importData_failed by @willnewii in https://github.com/nocodb/nocodb/pull/2197
• fix: ignore timezone mysql and rely on project info for checking data… by @pranavxc in https://github.com/nocodb/nocodb/pull/2192
• enhancement: use autocomplete in sort or filter fields by @pranavxc in https://github.com/nocodb/nocodb/pull/2191
• Feat - Attachment upload using url by @pranavxc in https://github.com/nocodb/nocodb/pull/2214
• fix: formula filter by @wingkwong in https://github.com/nocodb/nocodb/pull/2204
• fix: GCS plugin by @wingkwong in https://github.com/nocodb/nocodb/pull/2216
• 0.91.2 Pre Release by @wingkwong in https://github.com/nocodb/nocodb/pull/2217
• Feat - Import optimization in https://github.com/nocodb/nocodb/pull/2218
• fix: skip hook log if condition is not matching in https://github.com/nocodb/nocodb/pull/2220

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

🚀 NocoDB : Bug Fix Release

Closed Issues

• [Type: Bug][Status: Fixed] [UI] Add row options disappears #1151
• [Type: Bug][Status: Resolved] Cannot POST row to table #1146
• [Type: Enhancement] Document i18n process #1145
• [Type: Bug][DB: Postgres][Status: Fixed][Priority: Critical] Postgres : SingleSelect/Multiselect isn't working in 0.84.9 #1132
• [DB: Postgres][Status: Fixed][Priority: Critical] Cannot add Percentage as a column #1129
• [Type: Bug][Status: Fixed][Priority: Critical] Refreshing SQL Views returns blank page #1126
• [Type: Bug][DB: Postgres][Status: Fixed][Priority: Critical] uuid data type not working in searches in postgres #996
• [Type: Bug][Type: Enhancement][Status: Fixed][Priority: Critical] View does not has action type for downloading csv file as table does. However the shared view link does. #991
• [Type: Bug][Status: Fixed] Upload CSV Import Error #880
• [Type: Bug][Status: Fixed][Priority: Critical] Link to another record doesn't always populate possible options #781
• [Type: Bug][Priority: Critical] Rename a table which as a space - it leads to an error #768
• [Type: Bug][Status: Fixed][Priority: Critical] Search not working on bigint fields #589
• [Type: Bug][Status: Resolved] Issue: Setting default value involving symbols or multiline gives errors when setting default value for longtext #539
• [Type: Bug][Status: Fixed][Priority: Critical][Status: Action Needed] Whitespace in tablename while creating m2m relation leads to column not being shown. #479
• [Type: Bug] Cannot Add/Edit record properly when table has composite keys #297
• [Type: Bug] Bug: Unable to drop column of a composite primary key in Postgres #234

What's Changed

• fix: allow different boolean values for checkbox type by @wingkwong in https://github.com/nocodb/nocodb/pull/1148
• fix: cast search column in custom knex for uuid & fix search issue for bigint by @wingkwong in https://github.com/nocodb/nocodb/pull/1156
• fix: missing add row option by @wingkwong in https://github.com/nocodb/nocodb/pull/1164
• Refactor: cypress test suite apiType and dbType variable clean-up by @dstala in https://github.com/nocodb/nocodb/pull/1165
• fix: undefined parent id when calling paginatedM2mNotChildrenList by @wingkwong in https://github.com/nocodb/nocodb/pull/1166
• refactor: consistent api's for api/db type by @dstala in https://github.com/nocodb/nocodb/pull/1167
• fix: add missing delete user logic by @wingkwong in https://github.com/nocodb/nocodb/pull/1168
• test: cypress pg test suite- base files by @dstala in https://github.com/nocodb/nocodb/pull/1169
• chore(deps): Bump pathval from 1.1.0 to 1.1.1 in /packages/nc-migrator-archived by @dependabot in https://github.com/nocodb/nocodb/pull/1155
• chore(deps): Bump handlebars from 4.7.6 to 4.7.7 in /packages/nc-common by @dependabot in https://github.com/nocodb/nocodb/pull/1160
• chore(deps): bump ajv from 6.10.2 to 6.12.6 in /packages/nc-migrator-archived by @dependabot in https://github.com/nocodb/nocodb/pull/1170
• chore(deps): bump follow-redirects from 1.14.7 to 1.14.8 in /packages/noco-i18n by @dependabot in https://github.com/nocodb/nocodb/pull/1171
• chore(deps): bump follow-redirects from 1.14.6 to 1.14.8 in /packages/nc-cli by @dependabot in https://github.com/nocodb/nocodb/pull/1172
• test: cypress pg suite corrections to co-exist with mysql/xcdb suite by @dstala in https://github.com/nocodb/nocodb/pull/1175
• test: CI-CD integration for Cypress PG test suite by @dstala in https://github.com/nocodb/nocodb/pull/1264
• Refactor: i18n changes for roles & share view by @dstala in https://github.com/nocodb/nocodb/pull/1276
• Uniform 400 response format of REST /auth/signin by @LancerComet in https://github.com/nocodb/nocodb/pull/1274
• docs: add LancerComet as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/1277
• fix: enforce validation if table name invalid by @dstala in https://github.com/nocodb/nocodb/pull/1283
• refactor: release workflows by @wingkwong in https://github.com/nocodb/nocodb/pull/1281
• 0.84.11 Pre-Release by @wingkwong in https://github.com/nocodb/nocodb/pull/1292

New Contributors

• @LancerComet made their first contribution in https://github.com/nocodb/nocodb/pull/1274

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.10...0.84.12

🚀 NocoDB : Bug fix release

Closed Issues

• [Type: Bug] Multiple id columns are shown when there is only 1 id column in the table. #806
• [Type: Bug][For: Community][For: Hacktoberfest] Using create time field leads to error in updating table #558
• [Type: Bug] Cannot add Percentage as a column #1129
• [Type: Bug][DB: Postgres][Priority: Critical] Postgres : SingleSelect/Multiselect isn't working in 0.84.9 #1132
• [Type: Bug][Priority: Critical] Refreshing SQL Views returns blank page #1126

What's Changed

• Refactor/i18n general2 by @dstala in https://github.com/nocodb/nocodb/pull/1124
• fix: wrong parent node for SQL Views by @wingkwong in https://github.com/nocodb/nocodb/pull/1127
• fix : percent type in postgres. by @o1lab in https://github.com/nocodb/nocodb/pull/1131
• fix: keep dtxp property on table create/update by @pranavxc in https://github.com/nocodb/nocodb/pull/1136
• fix: SQL View Actions by @wingkwong in https://github.com/nocodb/nocodb/pull/1125
• fix: some csv import issues by @wingkwong in https://github.com/nocodb/nocodb/pull/1137
• 0.84.10 Pre-Release by @wingkwong in https://github.com/nocodb/nocodb/pull/1138
• chore(publish): v0.84.10 by @wingkwong in https://github.com/nocodb/nocodb/pull/1140

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.9...0.84.10

🚀 NocoDB : Bug Fix Release

Closed Issues

• [Priority: Critical] Sync shows schema changes for the changes done via GUI #1049
• [closed] Formulas Not Calculating after latest release #1047
• [closed] Lookup on "Formula field" not available - bug or just normal? #1045
• [Type: Bug][Status: Fixed][Priority: Critical] Webhook to send email notification can't be cancelled #1034
• [Type: Bug][DB: MSSQL][Status: Fixed][Priority: Critical] Update table failed - renaming column and changing field length #1018
• [closed] Incorrect row counts and missing pagination #1013
• [closed] how use REST APIs Upload single file #1008
• [Type: Bug][Status: Fixed][Priority: Critical] Preview has some part of UI parts obscured #993
• [Type: Bug][Status: Fixed][Priority: Critical] Different date view in gridview and galleryview #992
• [Type: Feature] [Feature] Support for readonly views and editable views #835
• [closed] Follow Production setup got an error: Malformed UTF-8 data #829
• [Type: Bug][Status: Fixed][Priority: Critical] Inserting new row with not null fields in grid view doesn't works #828
• [Status: Resolved] End of table name has a space will cause insert error #825
• [Status: Resolved] Not a valid syntax - Error when filtering columns with column names containing "-" #690

What's Changed

• fix: add proper spacing in left navigation drawer by @pranavxc in https://github.com/nocodb/nocodb/pull/994
• l10n(zh_TW): reviewed and translated all by @pan93412 in https://github.com/nocodb/nocodb/pull/999
• docs: add pan93412 as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/1000
• fix: save record on enter/shift-enter key press by @pranavxc in https://github.com/nocodb/nocodb/pull/1003
• Hotfix/cell update by @pranavxc in https://github.com/nocodb/nocodb/pull/1006
• docs: synchronising changes based on English version by @wingkwong in https://github.com/nocodb/nocodb/pull/1001
• fix: different date across views by @wingkwong in https://github.com/nocodb/nocodb/pull/1016
• chore(deps): Bump nanoid from 3.1.29 to 3.2.0 in /packages/noco-i18n by @dependabot in https://github.com/nocodb/nocodb/pull/980
• chore(deps): Bump trim-off-newlines from 1.0.1 to 1.0.3 in /packages/nc-plugin by @dependabot in https://github.com/nocodb/nocodb/pull/973
• chore(deps): Bump trim-off-newlines from 1.0.1 to 1.0.3 in /packages/nc-common by @dependabot in https://github.com/nocodb/nocodb/pull/974
• chore(deps): Bump node-fetch from 2.6.1 to 2.6.7 in /packages/noco-docs by @dependabot in https://github.com/nocodb/nocodb/pull/990
• chore(deps): Bump nanoid from 3.1.23 to 3.2.0 in /packages/noco-blog by @dependabot in https://github.com/nocodb/nocodb/pull/989
• chore(deps): Bump node-fetch from 2.6.1 to 2.6.7 in /packages/noco-blog by @dependabot in https://github.com/nocodb/nocodb/pull/988
• chore(deps): Bump nanoid from 3.1.23 to 3.2.0 in /packages/noco-docs by @dependabot in https://github.com/nocodb/nocodb/pull/982
• chore(deps): Bump trim-off-newlines from 1.0.1 to 1.0.3 by @dependabot in https://github.com/nocodb/nocodb/pull/975
• chore(deps): Bump nanoid from 3.1.30 to 3.1.31 in /packages/nocodb by @dependabot in https://github.com/nocodb/nocodb/pull/981
• chore(deps): Bump node-fetch from 2.6.1 to 2.6.7 in /packages/nc-common by @dependabot in https://github.com/nocodb/nocodb/pull/987
• chore(deps): Bump node-fetch from 2.6.1 to 2.6.7 in /packages/nc-plugin by @dependabot in https://github.com/nocodb/nocodb/pull/986
• fix: Update table failed - renaming column and changing field length issue by @wingkwong in https://github.com/nocodb/nocodb/pull/1022
• refactor: i18n re-org phase-1 by @dstala in https://github.com/nocodb/nocodb/pull/1023
• fix: reset saving flag anyway by @wingkwong in https://github.com/nocodb/nocodb/pull/1024
• Refactor/i18n master sync by @dstala in https://github.com/nocodb/nocodb/pull/1025
• Test/cypress stability by @dstala in https://github.com/nocodb/nocodb/pull/1027
• fix: update hook list after deleting webhook by @wingkwong in https://github.com/nocodb/nocodb/pull/1044
• fix: disable syncDataDebounce for currency field by @wingkwong in https://github.com/nocodb/nocodb/pull/1052
• fix: handle meta sync properly and keep proper column metadata by @pranavxc in https://github.com/nocodb/nocodb/pull/1050
• 0.84.9 Pre-Release by @wingkwong in https://github.com/nocodb/nocodb/pull/1053
• chore(publish): v0.84.9 by @wingkwong in https://github.com/nocodb/nocodb/pull/1054

New Contributors

• @pan93412 made their first contribution in https://github.com/nocodb/nocodb/pull/999

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.8...0.84.9

🚀 NocoDB : Bug Fix Release

Closed Issues

• [bug][P1] [Bug] - Cell is not updating after clearing cell value using delete key #1005
• [bug][Fixed] [BUG] - Cell value is not saving/updating on enter key press #1002
• [bug][Fixed][P1] [Bug] Condition for webhook automation does not take boolean type into consideration #953
• [bug][P1] Boolean comparison operator not working #947
• [bug][P1] ER_TOO_LONG_IDENT on LinkToAnotherRecord on MySQL #913

What's Changed

• Release v0.84.8 by @pranavxc in https://github.com/nocodb/nocodb/pull/1007

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.7...0.84.8

🚀 NocoDB : Release

Closed Issues

• [bug][Fixed][P1] Once signed in & signed out from a browser - invalid credentials also signs in (This has to be the same browser) #985
• [closed] Getting spinning circle not initial page. #964
• [Feature] [Feature] Setting to make auto filter apply default to off #963
• [bug][Fixed] cannot read property "builder" of undefined #960
• [bug][Fixed] [Bug] Failed testing minio endpoint #954
• [bug][Fixed][P1] [Bug] Formula LOG on MSSQL #949
• [Feature][Fixed] [Enhancement] : Add count in the footer of spreadsheet #946
• [bug][Fixed] Cache busting #728
• [bug] Bug: Column name with hyphens breaks everything (GraphQL) #707
• [bug][community][hacktoberfest][Fixed] Avoiding UI issue on upgrade - currently needs a hard refresh. #533
• [bug] Missing filtering logic in M2M #337

What's Changed

• Typo fixed by @bitbytejoy in https://github.com/nocodb/nocodb/pull/948
• fix: remove leading slashes for object keys by @wingkwong in https://github.com/nocodb/nocodb/pull/955
• fix: SES typo by @wingkwong in https://github.com/nocodb/nocodb/pull/962
• enhancement(ui): add checkbox field to app store input by @wingkwong in https://github.com/nocodb/nocodb/pull/959
• feat: add new SES implementation by @wingkwong in https://github.com/nocodb/nocodb/pull/965
• chore(deps): Bump follow-redirects from 1.14.4 to 1.14.7 in /packages/noco-i18n by @dependabot in https://github.com/nocodb/nocodb/pull/952
• chore(deps): Bump shelljs from 0.8.4 to 0.8.5 in /packages/nc-plugin by @dependabot in https://github.com/nocodb/nocodb/pull/951
• chore(deps): Bump shelljs from 0.8.4 to 0.8.5 in /packages/nc-common by @dependabot in https://github.com/nocodb/nocodb/pull/950
• fix: Cannot read properties of undefined (reading 'toLowerCase') in App Store by @wingkwong in https://github.com/nocodb/nocodb/pull/970
• docs: add bitbytejoy as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/979
• docs: refactor several README files by @wingkwong in https://github.com/nocodb/nocodb/pull/983

New Contributors

• @bitbytejoy made their first contribution in https://github.com/nocodb/nocodb/pull/948

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.6...0.84.7

🚀 NocoDB : Release

Major update

• Improved CSV import validation and bugs fixed
• Project import bugs fixed

Closed Issues

• [bug][P1] Project import failure #939
• [closed] RELATIOn HAS ONLY ONE #938
• [bug][Fixed][P1] [Bug] Protected Shared grid view showing password dialog randomly on applying filters #937
• [bug][Fixed] Reset password page title #935
• [bug][Fixed][P1] npx create-nocodb-app infinite output loop #934
• [Fixed][P1] limit is not supported in M2M Query #870
• [bug][needs more info][community][hacktoberfest] generated uuid is not returned on record creation with rest API #641

What's Changed

• fix: page title by @wingkwong in https://github.com/nocodb/nocodb/pull/936
• chore(deps): Bump lodash from 4.17.20 to 4.17.21 in /packages/nc-common by @dependabot in https://github.com/nocodb/nocodb/pull/927

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.3...0.84.6

🚀 NocoDB : Bug Fix Release

Major Updates

• Improved excel import
• Added filter & pagination param support for nested resolver in GQL

Closed Issues

• [bug][Fixed] Import of meta zip file is not exporting all the files. #924
• [closed] Trying to import 'meta.zip' generate a "Missing config file" error #923
• [closed] Vulenrability reports from White Source #912
• [Fixed] 1-click deploy to heroku is broken #911
• [needs more info] Duplicate Rows when adding via REST API #910
• [closed] webhook url settings saved options not loaded on page reload even if it saved #904
• [bug][Fixed] Bug: ' not escaped in MultiSelect option #896
• [Fixed] Cannot import some XLSX #884
• [Feature][Fixed] FILTRE sans Casse #873
• [bug][Fixed] Better rendering of LongText rows in Gallery View. #862
• [bug] When connecting to existing DB, FK relationships work properly. But if I get Recreate Metadata per table, the FK relationships don't show in CRUD table view #858
• [bug][Fixed] Node v16 NPM can't install packages for nc-gui #800
• [Fixed] Docs : Rest API documentation need an update for relation #796
• [bug] Controlling Project Creation by the Users ... #793
• [bug] Recreating metadata on Models resets some column types to LongText #712
• [bug][community][hacktoberfest] date shows in grid is different from value in database. #483
• [bug][community][Fixed] Can not edit SingleSelect/MultiSelect type of Column to Add option to the option list #326

What's Changed

• fix typo to preserve column types by @vijayrathore8492 in https://github.com/nocodb/nocodb/pull/915
• Update NcMetaIOImpl.ts by @willnewii in https://github.com/nocodb/nocodb/pull/917
• docs: add willnewii as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/925

New Contributors

• @willnewii made their first contribution in https://github.com/nocodb/nocodb/pull/917

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.1...0.84.2

🚀 NocoDB : Feature release

• Improved meta sync, which takes care of following DB changes
  • Table/View delete / create
  • Column addition / remove / update
  • Relation addition / delete
  • Existing virtual columns and views are retained as is.

Closed Issues

• [closed] Vulnerability reports from white source #912
• [closed] Noco shows only dbo tables [MSSQL] #899
• [closed] 0.83.8 update from 0.83.6: can't browse from Chromium anymore #898
• [bug] Bug: swagger API doc #897
• [bug] Swagger API's not updated properly. #886
• [Feature] [Feature] Support ODS for spreadsheet import #883
• [bug] Automations "Send Email" doesn't retain input fields #866

What's Changed

• Fix several mistakes on translating by @dubiao in https://github.com/nocodb/nocodb/pull/894
• docs: add dubiao as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/895

New Contributors

• @dubiao made their first contribution in https://github.com/nocodb/nocodb/pull/894

Full Changelog: https://github.com/nocodb/nocodb/compare/0.83.8...0.84.1

🚀 NocoDB : Hot fix release

• Hot fix release : duplication of has many records while creating m2m relation.

• [closed] Stop returning REST response with Has Many, Belongs To, or Many to Many by default, because they can be controlled if query params bt, hm, or mm are set #856

• Added Heroku upgrade with Mac M1 chip by @Korayem in https://github.com/nocodb/nocodb/pull/863

• docs: add Korayem as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/864

New Contributors

• @Korayem made their first contribution in https://github.com/nocodb/nocodb/pull/863

Full Changelog: https://github.com/nocodb/nocodb/compare/0.83.6...0.83.8

NocoDB : Feature release

• Added read-only SQL views support
• Now Table list / View list can be reorder by drag and drop

https://user-images.githubusercontent.com/61551451/145830474-e4c5f6a0-78c8-4aae-9702-c59499ecd552.mov

Closed issues

• [bug] Column values become blank after naming the column that is in sort list #859
• [closed] Install nocodb with mysql error. Shows "services.nocodb.depends_on contains an invalid type" inside docker-compose.yml #857
• [duplicate] MailerSend doesn't work, gives error: Cannot read property 'init' of null #855
• [closed] Can not see data - graphql 404 #845
• [bug] Nested list not working in xcdb project for GQL #844
• [closed] Bug: NC_DB url with ssl certificate file path is not working #840
• [closed] Website redirecting to github #839
• [closed] Mailer send app has an issue #827
• [closed] LinktoAnotherRecord shows a time stamp instead of the selected entry #823
• [Feature] [Feature] Select all records from a table #817
• [bug] how do users change their passwords? #699
• [Feature] Feature : SQL : Support Views #135

What's Changed

• Add page to explain role permissions, user mgmt by @candideu in https://github.com/nocodb/nocodb/pull/789
• Update zh_TW.json by @SiderealArt in https://github.com/nocodb/nocodb/pull/805
• docs: add SiderealArt as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/847
• fix: removal of physical relationships on metadata recreate by @vijayrathore8492 in https://github.com/nocodb/nocodb/pull/843
• docs: add vijayrathore8492 as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/848
• added cd nocodb after git clone by @John-Appleseed in https://github.com/nocodb/nocodb/pull/852
• docs: add John-Appleseed as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/853

New Contributors

• @SiderealArt made their first contribution in https://github.com/nocodb/nocodb/pull/805
• @vijayrathore8492 made their first contribution in https://github.com/nocodb/nocodb/pull/843
• @John-Appleseed made their first contribution in https://github.com/nocodb/nocodb/pull/852

Full Changelog: https://github.com/nocodb/nocodb/compare/0.83.5...0.83.6

🚀 NocoDB : Bug fix release

• [closed] Optimising debounce and remove toast #816
• [bug] Record Sometimes gets duplicated #779

Full Changelog: https://github.com/nocodb/nocodb/compare/0.83.4...0.83.5

🚀 NocoDB : Bug fix release

• [closed] Webhooks are getting triggered only once in certain scenario. #809
• [bug] Column with checkbox type may not be updated for consecutive clicks #734

Full Changelog: https://github.com/nocodb/nocodb/compare/0.83.2...0.83.3

🚀 NocoDB : Bug fix release

• [bug] Tables fails to load #804
• [community] Support for searching the tables #783
• [closed] Unknown Data button on nav bar #739
• [enhancement] Unknown Table List Ordering #737
• [bug] Column with checkbox type may not be updated for consecutive clicks #734
• [Feature] [Feature] Edit table without logging in. #518

Full Changelog: https://github.com/nocodb/nocodb/compare/0.83.0...0.83.2

🚀 NocoDB : Feature release

Features

• You can import an Excel spreadsheet as a NocoDB project with just 1-Click.
• We auto-identify schema and data type for you.
• Then automatically import data.
• Supported file formats: xls, xlsx, xlsm
• Supports importing to new or to an existing NocoDB project.
• Supports importing from your computer or a downloadable URL.

How to use

• Click on New Project
  • Select Create project from excel option,
  • Select file to Upload (OR) drag & drop file
• Or you can also simply drag & drop to NocoDB home screen ;)

https://user-images.githubusercontent.com/5435402/143030857-daa34db5-0ed2-46fa-8696-255ed266f9a3.mov

Deriving Table & Column name

• By default, the individual workbook sheet name will be marked as Table name.
• By default, details present in the first row will be used to create a Column name. If empty, NocoDB adds field <column-number> as column name.
• If two columns have the same name, NocoDB adds a numerical suffix to make the column name's unique
• Default names can be re-configured in the Customize page during project import (OR) using the Rename option after project creation
• Additional column's if needed can be added from the Customize page during project creation (OR) by using Add Table after project creation

Deriving Spreadsheet Data & Data type

NocoDB identifies Column data type on the best effort basis; falls back to SingleLineText if it fails to find suitable mapping datatype.

• By default, the first 500 rows are used to identify column datatype. This number is configurable during project import time using the Advanced menu option
• Empty columns to the left are ignored. Empty columns appearing in between are added to the table as SingleLineText column with default column name
• Empty rows are always ignored

Datatype (Numbers)

• Number: If every column data is a whole number (signed integer)
• Decimal: If some column data contain decimal numbers
• Currency: If every column data contains '$' prefix to the number associated (any other special characters not allowed)
• Percentage: If every column data contains '%' suffix to the number associated (any other special characters not allowed)

Datatype (Date/Time)

• Date: Supported format> YYYY-MM-DD
• Time: Converted to SingleLineText
• Date & Time: Supported format> YYYY-MM-DD HH:MM:SS

Datatype (Selects, Formula)

• Formula: Data type identified based on computed result of the formula.
• Checkbox: If column data represent boolean (true/false) state
• Multi-select: If column data contains comma seperated values. Each value will be treated as a selection token
• Single-select: If all values in the column are same

Datatype (Text)

• Long text: If some column data text length is greater than 255 characters (OR) contains newline character (\n or \r)
• Single line text: Default/fallback datatype

The datatypes identified by NocoDB can be overridden during project creation.
Note that, NocoDB uses SQLITE3 database; and hence you will not be able to change column datatype after the project is created

Misc notes

• Merge cells: pre-merge values in the cell are considered for datatype identification & the same are populated into associated cells/fields
• Rich text formatting in excel is ignored (font size/ color/ bold/ italics, and such)

Closed issues

• [closed] Fails to load on safari #799
• [closed] Table create fails after table rename operation #795
• [bug] Unable to use handlebar syntax in mobile number field of Twilio plugin? #792
• [closed] Is there an undo and redo? #790
• [closed] External IP addresses during installation and use #786
• [closed] The other version #784
• [closed] CSV Import same file name #778
• [closed] Deploy on Plesk Server #776
• [closed] Nocodb always open registration #773
• [enhancement] Auto update data on table opening (when clicking the tab) #767
• [bug] Blank page after filtering; need to click page in pagination to see results #766
• [bug] CSV export of jsonb column does not work #758
• [bug] Incorrect offset in pagination when increased number of shown records #755
• [bug] create-nocodb-app fail when used from a path containing a space #747
• [bug] Component visibility to some specific roles #738
• [community] wrong nav drawer toggle button position after adjusting the nav drawer weight #735
• [bug] Some buttons should be limited to creator / owner role #732
• [bug] Bug: Rename Table does not work #205

Full Changelog: https://github.com/nocodb/nocodb/compare/0.82.0...0.83.0

🚀 NocoDB : Feature release - Embeddable NocoDB

• Embed NocoDB project into any website (that supports iFrames).
  • Embedded base is read-only.
  • Embedded base allows filters/sort/hide operations on available fields.
  • Embedded base supports CSV table-data download.

Screenshots

1. Copy embeddable HTML code

2. Insert it into your web-page

Closed Issues

• [closed] How to connect to NocoDB service from local network? #754
• [closed] information needed (engine vs spreadsheet) #748
• [bug] Bug: Exported csv contains deleted column #744
• [closed] No option to delete a user #733
• [closed] Upgrade to Enterprise Edition? #731
• [closed] Request to add a github action #727
• [Feature] Feature request : Import / Export file formats (CSV, JSON) #179

What's Changed

• Fix : csv deleted column by @pranavxc in https://github.com/nocodb/nocodb/pull/745
• Update ko.json by @jiione in https://github.com/nocodb/nocodb/pull/753
• Docs: update heroku's deployment youtube video id by @ddazal in https://github.com/nocodb/nocodb/pull/760
• docs: add jiione as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/769

New Contributors

• @jiione made their first contribution in https://github.com/nocodb/nocodb/pull/753
• @ddazal made their first contribution in https://github.com/nocodb/nocodb/pull/760

Full Changelog: https://github.com/nocodb/nocodb/compare/0.81.1...0.82.0

🚀 NocoDB : Feature release - CSV Export

• Export your grid view as CSV
  • Customise filters, sort, fields and fields order.
  • CSV export available for shared grid views.
  • Downloads in batches (useful for large tables).
• Upload files from publicly shared Form View as well.

New environment variable

Closed Issues

• [bug] Bug: Id should encode to pass in url path for update and delete API #725
• [closed] Linked records title bug #721
• [closed] Doesn't create relations from Postgresql DB #719
• [bug] October 31 not displayed #711
• [closed] Image upload in public form view is not enabled. #702
• [closed] UI shows that there is a new version whilst there isn't #701
• [bug] Easy to overwrite existing values in a database #692
• [bug] Cannot upload attachment in shared form view #687
• [closed] German translations: request for proofreading #657
• [closed] npx安装打开后,创建表失败 #649
• [needs more info] {"msg":"Unauthorized access : xc-auth does not have admin permission"} #621
• [bug][community][hacktoberfest] On create of new column - column disappears #567

Full Changelog: https://github.com/nocodb/nocodb/compare/0.80.0...0.81.1

🚀 NocoDB : Feature release - Shared Grid View

Features

• Customize table data into different views depending on the team/ audience
  • Show/ hide columns
  • Filter rows
  • Sort/order contents
• Create & Share any number grid views
• Protect shared view access using a password
• Copy/Duplicate existing view as base for a new view, instead of always starting afresh.

What's Changed

• Spanish translation. by @fragalcer in https://github.com/nocodb/nocodb/pull/653
• docs: add fragalcer as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/655
• Add Slovenian translation. by @sesam in https://github.com/nocodb/nocodb/pull/658
• docs: add sesam as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/661
• feat: toggle nav drawer in workspace by @lielfr in https://github.com/nocodb/nocodb/pull/659
• docs: add lielfr as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/662
• 🌐 Update 🇳🇴 Norwegian translations to make more sense by @rubjo in https://github.com/nocodb/nocodb/pull/666
• docs: add rubjo as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/667
• Improved Polish translations by @kinga-marszalkowska in https://github.com/nocodb/nocodb/pull/664
• docs: add kinga-marszalkowska as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/671
• Update de.json by @dahawk in https://github.com/nocodb/nocodb/pull/672
• docs: add dahawk as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/673
• Cypress correction by @pranavxc in https://github.com/nocodb/nocodb/pull/689
• Update Italian translations by @bebora in https://github.com/nocodb/nocodb/pull/693
• docs: add bebora as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/694
• [Documentation] Language Page by @tyonirwansyah in https://github.com/nocodb/nocodb/pull/697
• docs: add tyonirwansyah as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/698

New Contributors

• @fragalcer made their first contribution in https://github.com/nocodb/nocodb/pull/653
• @sesam made their first contribution in https://github.com/nocodb/nocodb/pull/658
• @lielfr made their first contribution in https://github.com/nocodb/nocodb/pull/659
• @rubjo made their first contribution in https://github.com/nocodb/nocodb/pull/666
• @kinga-marszalkowska made their first contribution in https://github.com/nocodb/nocodb/pull/664
• @dahawk made their first contribution in https://github.com/nocodb/nocodb/pull/672
• @bebora made their first contribution in https://github.com/nocodb/nocodb/pull/693
• @tyonirwansyah made their first contribution in https://github.com/nocodb/nocodb/pull/697

Closed issues

• [closed] Added or renamed columns are not visible in grid views #691
• [closed] External database project fails to refresh, stop, restart, delete #686
• [closed] table name with underscore problem #651
• [community][hacktoberfest] Email address used for authentication should be case-insensitive #627
• [enhancement] Feature: Shared View has columns missing from relations. #507

Full Changelog: https://github.com/nocodb/nocodb/compare/0.11.46...0.80.0

🚀 NocoDB : Feature release

Share the form view

• [closed] Meta : view_name in nc_shared_view should be string #647

🚀 NocoDB : Feature release - Form View support

• [bug] Detail view: monaco editor is missing #617
• [closed] New tables created in public schema (Postgres) #615
• [closed] Question. Can I see id(primary key) in the view? #609
• [Feature] [Feature request] Form view - shared view, move to an URL, email #608
• [bug][community][hacktoberfest] Using NODE_ENV variable leads to issues #588
• [enhancement] Improvement: Word wrap for comments in data dialog #581
• [enhancement][community] change order of attachments? #383
• [Feature] Feature : Spreadsheet : Support Form View #142