Releases

0.84.8 1/26/2022

๐Ÿš€ ๐Ÿš€ 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

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

0.84.7 1/24/2022

๐Ÿš€ ๐Ÿš€ Bug Fix 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

New Contributors

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

0.84.6 1/12/2022

๐Ÿš€ ๐Ÿš€ Bug Fix 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

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

0.84.3 1/8/2022

๐Ÿš€ ๐Ÿš€ 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

New Contributors

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

0.84.1 1/3/2022

Features

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

image

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

New Contributors

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

0.83.8 12/15/2021

What's Changed

New Contributors

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

0.83.6 - SQL View Support 12/13/2021

Features

  • 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

New Contributors

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

๐Ÿš€ ๐Ÿš€ 0.83.5 - Bug fix release 11/27/2021

Closed issues

  • [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

๐Ÿš€ ๐Ÿš€ 0.83.3 - Bug fix release 11/25/2021

Closed issues

  • [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

๐Ÿš€ ๐Ÿš€ 0.83.2 - Bug fix release 11/24/2021

Closed issues

  • [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

๐Ÿš€ ๐Ÿš€ 0.83.0 - Import Spreadsheets 11/23/2021

Screen Shot 2021-11-23 at 13 10 39

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

๐Ÿš€ ๐Ÿš€ 0.82.0 11/16/2021

Highlights : 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

Screenshot 2021-11-15 at 6 52 50 PM _ 2

2. Insert it into your web-page

Screenshot 2021-11-15 at 6 54 10 PM

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

New Contributors

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

๐Ÿš€ ๐Ÿš€ 0.81.1 11/1/2021

Highlights : 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

Variable Mandatory Comments If absent
NC_EXPORT_MAX_TIMEOUT No After NC_EXPORT_MAX_TIMEOUT csv gets downloaded in batches Default value 5000 will be used

vid mov

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

๐Ÿš€ ๐Ÿš€ 0.80.0 10/25/2021

Highlights : 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.

shared_view

What's Changed

New Contributors

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

0.11.46 - Feature release 10/12/2021

๐Ÿš€ Highlights

Share the form view

image

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

0.11.44 10/12/2021

  • [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

0.11.42 - Feature Release 10/4/2021

Highlights

  • Form view

    image

  • Language translations in 12+ languages!

    Screen Shot 2021-10-04 at 18 31 32

  • Locked view for grid

    image

  • [bug] CORS in heroku #579
  • [closed] Feature: Host files by putting in folder like docs, libraries etc #578
  • [closed] removed #571
  • [enhancement] Feature request: Json editor in fullscreen #570
  • [enhancement] Fetch nested tables info #568
  • [closed] invalid database parameters #563
  • [bug] Bug: Editor role is not able to add/delete rows(GUI) #532
  • [needs more info] Update SQL Error for DateTime Field #502

0.11.39 - Bug fix release 9/23/2021

  • [bug] Unable to pick May 31 2021 in date picker #542

0.11.33 - Bug fix release 9/21/2021

  • [bug] Multiple update API calls happen for checkbox #551
  • [bug] Delete swagger documentation for deleted table #543

0.11.32 - Bug fix release 9/17/2021

  • [Feature] Add litestream support to sync ncdb sqlite meta database #540
  • [bug] REST API Bulk delete results in removal of all rows of table #509
  • [bug] Bug: Mysql meta migration fails #447
  • [enhancement] Show the signed-in user in the account-circle menu #169

0.11.31 - Bug fix release 9/16/2021

  • [bug] "Editor" role not allowed to upload files #536
  • [bug] Deleted table still visible in navigation pane #535
  • [bug] No Decimal Place on Some Formula Outputs where Needed #530
  • [bug] Too many fields for a table #519

0.11.30 - Bug fix release 9/15/2021

  • [bug] Bug: Editor role is not able to add/delete rows(GUI) #532
  • [bug] Bug: BelongsTo cell value is empty in GUI for Commenter/Viewer #531
  • [closed] forgot my password,how i find it? #527
  • [closed] How to calculate the sum of column A grouped by column B by calling APIs? #526
  • [closed] Foreign Key does not display in primary table when reference column is changed #525
  • [Feature] SMTP authentication is mandatory #520
  • [Feature] [Feature] JSON helper for Handlebars #516
  • [bug] Find/Get By Id does not return the Rollup result #515

0.11.29 - Bug fix release 8/30/2021

  • [enhancement] Quick next & previous record in the form view #501
  • [closed] postgres - Connection terminated unexpectedly #453
  • [enhancement] Feature: edit external database connection details #439
  • [closed] Handling SingleSelect: set to null value, easier adding of new values #261
  • [Feature] Feature request: i18n support #236
  • [needs more info] Bug: Cannot read property 'cn' of undefined #178
  • [needs more info] Bug: ID column is unknown #177
  • [needs more info] Bug: A column has been specified more than once #174
  • [closed] Commenter / Viewer see controls they cannot use #168

0.11.28 - Feature release : Rollup 8/30/2021

  • [Feature] Feature : Rollup #504
  • [closed] Tables not loading on different roles #503

0.11.26 - UI Bug fix release 8/26/2021

0.11.25 : Bug fix release 8/25/2021

  • [bug] m2m column delete fails #496

0.11.24 : Bug fix release 8/23/2021

  • [bug] date shows in grid is different from value in database. #483
  • [closed] Failed to insert a Many to Many relation column with "linked to other records #478
  • [closed] Facing issue while using Monaco editor present in Nocodb #331
  • [bug] Table UI disappears after Page Refresh #281
  • [closed] Bug: Issues Connecting to MSSQL Server #268
  • [bug] Creating columns then renaming or arranging causes SQLITE_ERROR: no such column #252
  • [bug] docker 0.9.16 - postgres 11 - foreign-key fields must display the name (title) and not the ID #202
  • [bug] docker 0.9.16 - postgres 11 - after "delete field" the view is not accessible any more #201
  • [closed] "Save" needs to be way more visible #167
  • [closed] Bug: A user without internet access faces missing fonts and stylesheets #162
  • [closed] Bug: Password policy is incompatible with Firefox password generator #161
  • [needs more info] Issue with default column names #157
  • [needs more info] Issue: Error when editing by clicking edit button on column header #486

0.11.23 - Feature release (Migration from one env to another) 8/21/2021

  • Feature : SQL : Migrations from one env to another #146
    • Works for external DB project
    • For master database project (to be done)

0.11.22 - Bug fix release 8/18/2021

  • [closed] bug: Missing less than operator in formula #471
  • Type conversion of number value in NC_DB url

0.11.21 - Bug fix release 8/17/2021

NocoDB : The Open Source Airtable alternative

Release notes v 0.11.21

  • [enhancement] Feature: filter and sort using formula column #466
  • [closed] Formula CONCAT() #465
  • [closed] Heroku deployed standard setup - can't delete tables, relation fields failing #329