Releases

0.107.5: Bug Fix Release 5/27/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: Form view not rendering available options #5740
  • [closed] ๐Ÿ› Bug: Uncaught ReferenceError: SwaggerUIBundle is not defined #5739

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.107.4...0.107.5

0.107.4: Bug Fix Release 5/24/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Super Admin No longer created during initialization #5722
  • [๐Ÿ› Type: Bug] Storage upload unauthorized using xc-token authentication header(it works with xc-auth) #5713
  • [closed] ๐Ÿ”ฆ Feature: Select number of row to display in each page #5708
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Metadata not in sync and breaking most of the features #5701
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: model list cache ignores base_id #5568

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.107.3...0.107.4

0.107.3: Bug Fix Release 5/22/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: LinkToAnotherRecord dosen't work in Shared View Forms #5694
  • [โœจ Type: Enhancement] ๐Ÿ”ฆ Enhancement: Formula functions prefer to be case-insensitive #5640

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.107.2...0.107.3

0.107.2: Bug Fix Release 5/22/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: SwaggerUI not working with latest release #5125

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.107.1...0.107.2

0.107.1: Bug Fix Release 5/20/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: after updated (docker) to 0.107.0 I get multiple errors #5679
  • [closed] ๐Ÿ› Bug: not reading environment variables #5673

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.107.0...0.107.1

0.107.0 5/19/2023

๐Ÿš€ NocoDB Feature Release : Copy Projects / Tables ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

Copy Projects / Tables

We are stoked to introduce much asked features of Project Copy and Table Copy features - your ticket to seamless productivity!

๐Ÿ’กEver find yourself thinking, "I wish I could just duplicate this entire project or table"? Well, now you can! Imagine the possibilities! With just a SINGLE CLICK, you can clone your carefully crafted projects or tables, effectively bypassing the monotonous chore of recreating similar tasks or items. It's like having a digital twin at your disposal - just more efficient and less sci-fi!

๐Ÿ“ˆ But it doesn't stop there! Enjoy complete control over what you copy, including all views or data and more. Each element of your projects or tables is duplicated in exquisite detail. No more missing links, no more errors in transcription. Your workflows will be cleaner, your collaborations smoother, and your efficiency off the charts!

๐Ÿš€ With NocoDB's Project Copy and Table Copy features, you're not just duplicating data; you're replicating productivity. Carry forward all those lessons learned, those meticulously crafted structures, and those collaborative notes, enabling you to hit the ground running with new projects!

https://github.com/nocodb/nocodb/assets/5435402/9d6e3902-b477-4417-a532-859dd5cf901b

https://github.com/nocodb/nocodb/assets/5435402/c9824c8e-0a9f-459d-99ca-468158c90252

PS : This feature is available when project is on root-db and not on external DB.

Coming soon!

GeoData + Map View ( Sneak peak )

The new feature launch includes beta access for GeoData column and Map View. With this, users can easily input and view location data associated with their records, making it easier to analyse and interpret data based on geography. The Map View feature allows users to visualise their data on an interactive map. Users can filter their data by location, zoom in and out. Overall, the GeoData column and Map View feature provides powerful tool that adds a new dimension to data analysis, providing users with an intuitive and visually engaging way to explore and interpret their data.

Screenshot 2023-03-29 at 3 30 53 PM Screenshot 2023-03-29 at 3 30 00 PM

Mobile mode (Sneak peak )

A toggle button is now available in beta access, which enabled will

  • helps simplify UI layout for mobile view.
  • enable's QR scan option to retrieve a stored record.

Screenshot 2023-04-06 at 11 15 35 AM Screenshot 2023-04-06 at 11 16 47 AM

Note that, Sneak peak features are work in progress & needs to be explicitly enabled using easter egg menu. Please get in touch with us for more details.

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€


๐Ÿ› Closed Issues

  • [closed] ๐Ÿ”ฆ Feature: Is the backend source code of the nocodb project open source now? How can I obtain the backend source code #5668
  • [Status: Reproducible] ๐Ÿ› Bug: DATEADD with negative offset #5644
  • [๐Ÿ› Type: Bug][Status: Reproducible] ๐Ÿ› Bug: Nested group filter error while creation #5639
  • [๐Ÿ› Type: Bug][Status: Reproducible] ๐Ÿ› Bug: Help text missing in shared form view #5633
  • [Status: Reproducible] ๐Ÿ› Bug: Filter dropdown for select fields disabled #5632
  • [๐Ÿ”Ž Status: More Info Needed] Issue: Shared base UX & permissions #5630
  • [closed] ๐Ÿ› Bug: no connection to a Postgresql DB in a docker #5616
  • [closed] ๐Ÿ› Bug: Currency datatype, cell with value 0 displayed as empty cell #5607
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Google Cloud Storage Plugin Private Key exceeds character limit #5606
  • [closed] [Feature] Version Control on Rows #5589
  • [closed] ๐Ÿ› Bug: Gallery shared view doesn't show LTAR #5561
  • [closed] ๐Ÿ› Bug: nocodb-nest: error during init if database is not created already #5549
  • [closed] ๐Ÿ› Bug: Messy interface after the upgrade to v0.106.1 #5548
  • [closed] ๐Ÿ› Bug: Email plugin is not found after upgrade #5543
  • [closed] About licence of plugin #5542
  • [closed] ๐Ÿ› Bug: import csv data : you mixed columns and rows #5529
  • [closed] delete this please #5521
  • [closed] ๐Ÿ› Bug: npm run watch:run command failed to execute #5520
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Exporting the table as CSV does not export the ID for link records #5514
  • [closed] ๐Ÿ”ฆ Feature: Allow customizing webhook body #5511
  • [closed] ๐Ÿ› Bug: API filtering a date field as "is not null" gets a 500 #5507
  • [closed] ๐Ÿ› Bug: .jpg and .jpeg can't be attached / iphone can't attach image or file #5499
  • [Status: Reproducible] ๐Ÿ› Bug: Date filters flawed work in DateTime columns #5483
  • [โœจ Type: Enhancement] enhancement: add scrollbar in column list #5482
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Primary column shows red border #5424
  • [closed] ๐Ÿ› Bug: Previous page data for empty cells #5372
  • [closed] ๐Ÿ› Bug: Edit Host Address in Database Connections fails #5313
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Failed to fetch dynamically error #5266
  • [closed] ๐Ÿ”ฆ Feature: Confirmation on delete record #5263
  • [closed] ๐Ÿ”ฆ Feature: Optimize formulas in SQL queries #5160
  • [closed] Bug: Migration failure #5034
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] [Feature] Apps Script Code Snippet #2477
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Docs : Give examples for API request/response #2437

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.106.1...0.107.0

0.107.0-beta.1 5/11/2023

๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: Currency datatype, cell with value 0 displayed as empty cell #5607
  • [closed] [Feature] Version Control on Rows #5589
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Exporting the table as CSV does not export the ID for link records #5514
  • [โœจ Type: Enhancement] enhancement: add scrollbar in column list #5482

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.107.0-beta.0...0.107.0-beta.1

0.107.0-beta.0 5/4/2023

๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: Gallery shared view doesn't show LTAR #5561
  • [closed] ๐Ÿ› Bug: nocodb-nest: error during init if database is not created already #5549
  • [closed] ๐Ÿ› Bug: Messy interface after the upgrade to v0.106.1 #5548
  • [closed] ๐Ÿ› Bug: Email plugin is not found after upgrade #5543
  • [closed] ๐Ÿ› Bug: import csv data : you mixed columns and rows #5529
  • [closed] delete this please #5521
  • [closed] ๐Ÿ› Bug: npm run watch:run command failed to execute #5520
  • [closed] ๐Ÿ”ฆ Feature: Allow customizing webhook body #5511
  • [closed] ๐Ÿ› Bug: API filtering a date field as "is not null" gets a 500 #5507
  • [closed] ๐Ÿ› Bug: .jpg and .jpeg can't be attached / iphone can't attach image or file #5499
  • [Status: Reproducible] ๐Ÿ› Bug: Date filters flawed work in DateTime columns #5483
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Primary column shows red border #5424
  • [closed] ๐Ÿ› Bug: Previous page data for empty cells #5372
  • [closed] ๐Ÿ› Bug: Edit Host Address in Database Connections fails #5313
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Failed to fetch dynamically error #5266
  • [closed] ๐Ÿ”ฆ Feature: Confirmation on delete record #5263
  • [closed] ๐Ÿ”ฆ Feature: Optimize formulas in SQL queries #5160
  • [closed] Bug: Migration failure #5034
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Docs : Give examples for API request/response #2437

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.106.1...0.107.0-beta.0

0.106.1: Bug Fix Release 4/18/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: LinkToAnotherRecord dosen't work in Shared View Forms #5488
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Drag drop image broken in expanded record & form view #5486
  • [Status: Reproducible] ๐Ÿ› Bug: Text selected alongside cells #5484
  • [closed] ๐Ÿ› Bug: Formula error #5478
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Table name expected to be unique across data sources #5477
  • [closed] ๐Ÿ› Bug: can't find swagger.json anymore #5474
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: OR() formula broken as of 0.106.0 #5471
  • [closed] ๐Ÿ› Bug: form-view mode Attachment failed to upload #5470
  • [closed] Link in REST APIs documentation redirects to a 404 page #5468
  • [๐Ÿ› Type: Bug][๐Ÿน DB : SQLite] Error when using PATCH http://localhost:8080/api/v1/db/data/bulk/{orgs}/{projectName}/{tableName}: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? #5467
  • [closed] ๐Ÿ”ฆ Feature: We have questions about commercial licensing, can you contact us? #5464
  • [๐Ÿ› Type: Bug][๐Ÿ˜ DB : Postgres] ๐Ÿ› Bug: Formula Statement SEARCH not working #5460
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: API User Signout 404 Not Found' for url 'xxxxxxxx/api/v1/auth/user/signout #5459
  • [closed] ๐Ÿ› Bug: API Where clause not working with 106 #5456
  • [closed] ๐Ÿ”ฆ Feature: Fill PDF form #5453
  • [closed] ๐Ÿ› Bug: Link feature is not working #5451
  • [๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Bug: non-pk system column as display value #5450
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: incorrect results of concat formula #5449
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Checkbox ColumnType cannot be updated MSSQL #5440
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Uploading files via forms #5434
  • [closed] ๐Ÿ› Bug: vultr s3 bucket #5401
  • [closed] ๐Ÿ› Bug: various small annoyances #5377
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: VULNERABILITY: Sign Out doesn't work #5361
  • [closed] ๐Ÿ› Bug: Slow Performance #5136
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Send what changed in webhook data when update action is triggered #3869
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš˜ Scope : Automation] [Feature] CSV import Webhook trigger #1582

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.106.0...0.106.1

0.106.0 4/11/2023

๐Ÿš€ NocoDB Feature Release : Undo/Redo, Webhooks revamped & UX Performance improved ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

v0 101 0  What's new (2)

Date / DateTime Filters

  • Introduce is after, is before, is on or after and is on or before, isWithin for date and datetime.
  • Introduce sub-operations: today, tomorrow, yesterday, oneWeekAgo, oneWeekFromNow, oneMonthAgo, oneMonthFromNow, daysAgo, daysFromNow, exactDate. For isWithin, we have the following sub-operations instead: pastWeek, pastMonth, pastYear, nextWeek, nextMonth, nextYear, nextNumberOfDays, pastNumberOfDays
  • Existing is like and is not like filters will be removed.
  • Existing is empty, is not empty, is null, is not null will be migrated to blank and not blank.

Undo

Scope Actions
Row Create, Update, Delete
LTAR Link, Unlink
Fields Show/hide, Reorder
Sort Add, Update, Delete
Filters Add, Update, Delete (Excluding Filter Groups)
Row Height Update
Column width Update
View Rename
Table Rename

Screen Recording 2023-03-29 at 2 55 21 PM mov

Revamp

Webhook v2

  • New Webhooks will be considered as v2. The existing webhooks (v1) will remain unchanged.
  • Webhook response for update & delete triggers now carry record information before & after event
  • Webhook triggers are now available for bulk events as well
  • Webhook Call Log with option to enable/disable them using environment variables. (Also available in v1 webhooks)

Others

  • UI Icons
  • Adopted Controller and Service Pattern
  • API Validations
  • API Docs
  • Performance Tuning

โ—Breaking changes

Metadata API Responses

The following Listing API responses will be wrapped by list and pageInfo is available in some APIs currently.

{
  "list": [{...}, {...}],
  "pageInfo": {...}
}
  • /api/v1/db/meta/projects/:projectId/api-tokens
  • /api/v1/db/meta/audits/comments
  • /api/v1/db/meta/views/:viewId/filters
  • /api/v1/db/meta/filters/:filterParentId/children
  • /api/v1/db/meta/hooks/:hookId/filters
  • /api/v1/db/meta/views/:viewId/sorts/
  • /api/v1/db/meta/tables/:tableId/views
  • /api/v1/db/meta/tables/:tableId/share
  • /api/v1/db/meta/views/:viewId/columns/
  • /api/v1/users

Hook Sample Payload API Change

From

/api/v1/db/meta/tables/:tableId/hooks/samplePayload/:operation/

to

/api/v1/db/meta/tables/:tableId/hooks/samplePayload/:operation/:version

Coming soon!

GeoData + Map View ( Sneak peak )

The new feature launch includes beta access for GeoData column and Map View. With this, users can easily input and view location data associated with their records, making it easier to analyse and interpret data based on geography. The Map View feature allows users to visualise their data on an interactive map. Users can filter their data by location, zoom in and out. Overall, the GeoData column and Map View feature provides powerful tool that adds a new dimension to data analysis, providing users with an intuitive and visually engaging way to explore and interpret their data.

Screenshot 2023-03-29 at 3 30 53 PM Screenshot 2023-03-29 at 3 30 00 PM

Mobile mode (Sneak peak )

A toggle button is now available in beta access, which enabled will

  • helps simplify UI layout for mobile view.
  • enable's QR scan option to retrieve a stored record.

Screenshot 2023-04-06 at 11 15 35 AM Screenshot 2023-04-06 at 11 16 47 AM

Note that, Sneak peak features are work in progress & needs to be explicitly enabled using easter egg menu. Please get in touch with us for more details.

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€


๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: Formula linked column references #5420
  • [closed] ๐Ÿ› Bug: NocoDB is not syncing to Postgres #5418
  • [closed] ๐Ÿ› Bug: Adding postgres data-source without CREATE ON DATABASE permission #5398
  • [closed] Group rows like in Airtable #5387
  • [closed] ๐Ÿ› Bug: minor UI corrections #5381
  • [closed] ๐Ÿ› Bug: [dev] rollup icon not displayed #5380
  • [closed] let's go oracle #5376
  • [closed] drag and drop a table in another database [Feature] #5362
  • [closed] ๐Ÿ› Bug: VULNERABILITY: Sign Out doesn't work #5361
  • [closed] ๐Ÿ”ฆ Feature: Add icon reset option #5356
  • [closed] ๐Ÿ› Bug: Failure to download doc attachment #5344
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: BullMQ: DEPRECATION WARNING! Your redis options maxRetriesPerRequest must be null. On the next versions having this settings will throw an exception #5335
  • [closed] ๐Ÿ› Bug: Unable to download attachment #5326
  • [closed] ๐Ÿ› Bug: run Noco-win-x64.exe got error: 'Z_DATA_ERROR' #5318
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Cannot use backslash \ in formula #5315
  • [closed] ๐Ÿ› Bug: filtering a view on a date field causes 500 error #5308
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: row number not syncing between pages #5304
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: non-image attachments cannot be opened after upload #5302
  • [closed] UI enhancements #5260
  • [๐Ÿฌ DB : MySQL] ๐Ÿ› Bug: Mysql Decimal Field length 10 is not enough #5259
  • [closed] undo #5258
  • [๐Ÿ› Type: Bug][๐Ÿ˜ DB : Postgres] ๐Ÿ› Bug:Use of ? in column name throws error #5255
  • [closed] ๐Ÿ› Bug: Advanced column options are not displayed #5245
  • [closed] ๐Ÿ› Bug: Filter on rollup error's out in PG #5232
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Error thrown when editing a form #5231
  • [closed] ๐Ÿ› Bug: Swagger schema not matching API call result #5224
  • [closed] ๐Ÿ› Bug: Using a โ€˜?โ€™ does not work with concat #5220
  • [closed] ๐Ÿ› Bug: project setting "Show NULL and EMPTY in Filter" has no effect #5219
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: "is blank" filter not yielding any results on LinkToAnotherRecord column #5218
  • [closed] ๐Ÿ› Bug: Docker build missing dependency #5216
  • [Status: Reproducible] ๐Ÿ› Bug: Replace in formula issues #5209
  • [closed] ๐Ÿ› Bug: In external form view, column definitions can be altered #5205
  • [closed] Map View Follow-up items #5203
  • [closed] Column type autonumber #5201
  • [closed] ๐Ÿ”ฆ Feature: Activity.Copyview, copy the costom width of the column #5198
  • [closed] ๐Ÿ› Bug: Activity.ListSharedView double click Table headers #5197
  • [closed] Custom user role #5192
  • [closed] ๐Ÿ› Bug: Cannot change Single and MultiSelect value from the Child list #5191
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Content of columns with LongText is not visible with Microsoft Edge Dev #5190
  • [closed] Date Filter doesn't include date operations #5186
  • [Status: Reproducible] ๐Ÿ› Bug: SpecificDBType select is missing #5182
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: UI not updating in Development Setup #5180
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: SingleSelect focus is a bit broken in Firefox #5179
  • [closed] [Feature] page transition #5177
  • [Status: Reproducible] ๐Ÿ› Bug: Cell exits edit mode when clicking inside the same cell #5170
  • [closed] ๐Ÿ› Bug: clicking save button multiple times on "new column" or "edit column" will fire multiple queries #5158
  • [โœจ Type: Enhancement] ๐Ÿ”ฆ Enhancement: add shortcut to navigate to next & previous records in Expanded row #5124
  • [closed] ๐Ÿ› Bug: Frozen grid view details even after closing all tabs #5121
  • [closed] ๐Ÿ”ฆ Feature: Prefilled forms #5107
  • [closed] ๐Ÿ› Bug: Wrong baseId is used in QuickImport, when a secondary database is only active. So the Table is created in the hidden DB. #5103
  • [closed] ๐Ÿ› Bug: Losing Super Admin role after upgrading from 0.101.2 to 0.104.3 #5101
  • [closed] ๐Ÿ› Bug: No autosave when moving to "Next Row" in expanded record view #5049
  • [closed] Feature: In shared Grid view it's not possible to edit or add data #5028
  • [closed] ๐Ÿ”ฆ Feature: Add rows using .xlsx #5021
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Abiliy to select date field through date picker in filter #4655
  • [โœจ Type: Enhancement] Enhancement: Provide access to common data like project ID in Webhook JSON response #4594
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: The Editor need the function of โ€Upload EXCELโ€œ,import .xlsx file #4271
  • [๐Ÿ”ฆ Type: Feature] [Feature] Add users field to tables #3787
  • [๐Ÿ”ฆ Type: Feature] [Feature] Webhooks only for specific columns #3693
  • [๐Ÿ”ฆ Type: Feature] [Feature] Expanded record view : provide option to display hidden fields #3513
  • [๐Ÿ”ฆ Type: Feature][๐ŸŒฎ Scope : Table] [Feature] Empty table contents #2997
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš˜ Scope : Automation] [Feature] Access old field values in webhooks #2902
  • [๐Ÿ”ญ Scope : Project] [Feature] unique columns #2778
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Allow editing of a Lookup column #2574
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Link Multiple Records to Another Record at the same time (multi-select record linking) #2564
  • [๐Ÿ‘‹ For : Community or Good First Issue] Inflection: none is still capitalising words in some places #2406
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Some Column types are missing when modifying columns #2285
  • [๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Feature: [web hook] update to LTAR doesn't trigger 'on-update' webhook #2104
  • [๐Ÿ”ฆ Type: Feature] Feature : Ability to toggle audit logs #2035
  • [๐Ÿ”ฆ Type: Feature] [Feature] Offer random UUID generation as alternative for the mandatory column ID #2008
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][โ˜Ž Scope : API] Describe API params and body with an example #1767
  • [๐Ÿ—๏ธ Type: In Development] Describe API path, query params etc in docs #1690
  • [๐Ÿ”ฆ Type: Feature][๐ŸŽฐ Scope : Hosting] [Feature] Helm chart #1544
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] Use rollup in formula #1331
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] URL parameter multi field/value filter #1039
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] : Has one #943
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Feature : user type field #500
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿ‘ฎ Scope : Auth] Feature: edit password, firstname and lastname using GUI #417
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][โ˜Ž Scope : API] Token ACL by API #254

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.105.3...0.106.0

0.106.0-beta.1 4/6/2023

๐Ÿš€ NocoDB Feature Release : Undo/Redo, Webhooks revamped & UX Performance improved ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

v0 101 0  What's new (2)

Date / DateTime Filters

  • Introduce is after, is before, is on or after and is on or before, isWithin for date and datetime.
  • Introduce sub-operations: today, tomorrow, yesterday, oneWeekAgo, oneWeekFromNow, oneMonthAgo, oneMonthFromNow, daysAgo, daysFromNow, exactDate. For isWithin, we have the following sub-operations instead: pastWeek, pastMonth, pastYear, nextWeek, nextMonth, nextYear, nextNumberOfDays, pastNumberOfDays
  • Existing is like and is not like filters will be removed.
  • Existing is empty, is not empty, is null, is not null will be migrated to blank and not blank.

Undo

Scope Actions
Row Create, Update, Delete
LTAR Link, Unlink
Fields Show/hide, Reorder
Sort Add, Update, Delete
Filters Add, Update, Delete (Excluding Filter Groups)
Row Height Update
Column width Update
View Rename
Table Rename

Screen Recording 2023-03-29 at 2 55 21 PM mov

Revamp

Webhook v2

  • New Webhooks will be considered as v2. The existing webhooks (v1) will remain unchanged.
  • Webhook response for update & delete triggers now carry record information before & after event
  • Webhook triggers are now available for bulk events as well
  • Webhook Call Log with option to enable/disable them using environment variables. (Also available in v1 webhooks)

Others

  • UI Icons
  • Adopted Controller and Service Pattern
  • API Validations
  • API Docs
  • Performance Tuning

โ—Breaking changes

Metadata API Responses

The following Listing API responses will be wrapped by list and pageInfo is available in some APIs currently.

{
  "list": [{...}, {...}],
  "pageInfo": {...}
}
  • /api/v1/db/meta/projects/:projectId/api-tokens
  • /api/v1/db/meta/audits/comments
  • /api/v1/db/meta/views/:viewId/filters
  • /api/v1/db/meta/filters/:filterParentId/children
  • /api/v1/db/meta/hooks/:hookId/filters
  • /api/v1/db/meta/views/:viewId/sorts/
  • /api/v1/db/meta/tables/:tableId/views
  • /api/v1/db/meta/tables/:tableId/share
  • /api/v1/db/meta/views/:viewId/columns/
  • /api/v1/users

Hook Sample Payload API Change

From

/api/v1/db/meta/tables/:tableId/hooks/samplePayload/:operation/

to

/api/v1/db/meta/tables/:tableId/hooks/samplePayload/:operation/:version

Coming soon!

GeoData + Map View ( Sneak peak )

The new feature launch includes beta access for GeoData column and Map View. With this, users can easily input and view location data associated with their records, making it easier to analyse and interpret data based on geography. The Map View feature allows users to visualise their data on an interactive map. Users can filter their data by location, zoom in and out. Overall, the GeoData column and Map View feature provides powerful tool that adds a new dimension to data analysis, providing users with an intuitive and visually engaging way to explore and interpret their data.

Screenshot 2023-03-29 at 3 30 53 PM Screenshot 2023-03-29 at 3 30 00 PM

Mobile mode (Sneak peak )

A toggle button is now available in beta access, which enabled will

  • helps simplify UI layout for mobile view.
  • enable's QR scan option to retrieve a stored record.

Screenshot 2023-04-06 at 11 15 35 AM Screenshot 2023-04-06 at 11 16 47 AM

Note that, Sneak peak features are work in progress & needs to be explicitly enabled using easter egg menu. Please get in touch with us for more details.

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€


๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: Formula linked column references #5420
  • [closed] ๐Ÿ› Bug: NocoDB is not syncing to Postgres #5418
  • [closed] ๐Ÿ› Bug: Adding postgres data-source without CREATE ON DATABASE permission #5398
  • [closed] Group rows like in Airtable #5387

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.106.0-beta.0...0.106.0-beta.1

0.106.0-beta.0 3/31/2023

๐Ÿš€ NocoDB Feature Release ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

Date / DateTime Filters

  • Introduce is after, is before, is on or after and is on or before, isWithin for date and datetime.
  • Introduce sub-operations: today, tomorrow, yesterday, oneWeekAgo, oneWeekFromNow, oneMonthAgo, oneMonthFromNow, daysAgo, daysFromNow, exactDate. For isWithin, we have the following sub-operations instead: pastWeek, pastMonth, pastYear, nextWeek, nextMonth, nextYear, nextNumberOfDays, pastNumberOfDays
  • Existing is like and is not like filters will be removed.
  • Existing is empty, is not empty, is null, is not null will be migrated to blank and not blank.

Undo

Scope Actions
Row Create, Update, Delete
LTAR Link, Unlink
Fields Show/hide, Reorder
Sort Add, Update, Delete
Filters Add, Update, Delete (Excluding Filter Groups)
Row Height Update
Column width Update
View Rename
Table Rename

Revamp

  • UI Icons
  • Adopted Controller and Service pattern
  • API Validations
  • API Docs

โ—Breaking changes

Metadata API Responses

The following Listing API responses will be formatted as

{
  "list": [{...}, {...}],
  "pageInfo": {...}
}
  • /api/v1/db/meta/projects/:projectId/api-tokens
  • /api/v1/db/meta/audits/comments
  • /api/v1/db/meta/views/:viewId/filters
  • /api/v1/db/meta/filters/:filterParentId/children
  • /api/v1/db/meta/hooks/:hookId/filters
  • /api/v1/db/meta/views/:viewId/sorts/
  • /api/v1/db/meta/tables/:tableId/views
  • /api/v1/db/meta/tables/:tableId/share
  • /api/v1/db/meta/views/:viewId/columns/
  • /api/v1/users

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€


๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: minor UI corrections #5381
  • [closed] ๐Ÿ› Bug: [dev] rollup icon not displayed #5380
  • [closed] let's go oracle #5376
  • [closed] drag and drop a table in another database [Feature] #5362
  • [closed] ๐Ÿ› Bug: VULNERABILITY: Sign Out doesn't work #5361
  • [closed] ๐Ÿ”ฆ Feature: Add icon reset option #5356
  • [closed] ๐Ÿ› Bug: Failure to download doc attachment #5344
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: BullMQ: DEPRECATION WARNING! Your redis options maxRetriesPerRequest must be null. On the next versions having this settings will throw an exception #5335
  • [closed] ๐Ÿ› Bug: Unable to download attachment #5326
  • [closed] ๐Ÿ› Bug: run Noco-win-x64.exe got error: 'Z_DATA_ERROR' #5318
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Cannot use backslash \ in formula #5315
  • [closed] ๐Ÿ› Bug: filtering a view on a date field causes 500 error #5308
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: row number not syncing between pages #5304
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: non-image attachments cannot be opened after upload #5302
  • [closed] UI enhancements #5260
  • [๐Ÿฌ DB : MySQL] ๐Ÿ› Bug: Mysql Decimal Field length 10 is not enough #5259
  • [closed] undo #5258
  • [๐Ÿ› Type: Bug][๐Ÿ˜ DB : Postgres] ๐Ÿ› Bug:Use of ? in column name throws error #5255
  • [closed] ๐Ÿ› Bug: Advanced column options are not displayed #5245
  • [closed] ๐Ÿ› Bug: Filter on rollup error's out in PG #5232
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Error thrown when editing a form #5231
  • [closed] ๐Ÿ› Bug: Swagger schema not matching API call result #5224
  • [closed] ๐Ÿ› Bug: Using a โ€˜?โ€™ does not work with concat #5220
  • [closed] ๐Ÿ› Bug: project setting "Show NULL and EMPTY in Filter" has no effect #5219
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: "is blank" filter not yielding any results on LinkToAnotherRecord column #5218
  • [closed] ๐Ÿ› Bug: Docker build missing dependency #5216
  • [Status: Reproducible] ๐Ÿ› Bug: Replace in formula issues #5209
  • [closed] ๐Ÿ› Bug: In external form view, column definitions can be altered #5205
  • [closed] Map View Follow-up items #5203
  • [closed] Column type autonumber #5201
  • [closed] ๐Ÿ”ฆ Feature: Activity.Copyview, copy the costom width of the column #5198
  • [closed] ๐Ÿ› Bug: Activity.ListSharedView double click Table headers #5197
  • [closed] Custom user role #5192
  • [closed] ๐Ÿ› Bug: Cannot change Single and MultiSelect value from the Child list #5191
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Content of columns with LongText is not visible with Microsoft Edge Dev #5190
  • [closed] Date Filter doesn't include date operations #5186
  • [Status: Reproducible] ๐Ÿ› Bug: SpecificDBType select is missing #5182
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: UI not updating in Development Setup #5180
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: SingleSelect focus is a bit broken in Firefox #5179
  • [closed] [Feature] page transition #5177
  • [Status: Reproducible] ๐Ÿ› Bug: Cell exits edit mode when clicking inside the same cell #5170
  • [closed] ๐Ÿ› Bug: clicking save button multiple times on "new column" or "edit column" will fire multiple queries #5158
  • [โœจ Type: Enhancement] ๐Ÿ”ฆ Enhancement: add shortcut to navigate to next & previous records in Expanded row #5124
  • [closed] ๐Ÿ› Bug: Frozen grid view details even after closing all tabs #5121
  • [closed] ๐Ÿ”ฆ Feature: Prefilled forms #5107
  • [closed] ๐Ÿ› Bug: Wrong baseId is used in QuickImport, when a secondary database is only active. So the Table is created in the hidden DB. #5103
  • [closed] ๐Ÿ› Bug: Losing Super Admin role after upgrading from 0.101.2 to 0.104.3 #5101
  • [closed] ๐Ÿ› Bug: No autosave when moving to "Next Row" in expanded record view #5049
  • [closed] Feature: In shared Grid view it's not possible to edit or add data #5028
  • [closed] ๐Ÿ”ฆ Feature: Add rows using .xlsx #5021
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Abiliy to select date field through date picker in filter #4655
  • [โœจ Type: Enhancement] Enhancement: Provide access to common data like project ID in Webhook JSON response #4594
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: The Editor need the function of โ€Upload EXCELโ€œ,import .xlsx file #4271
  • [๐Ÿ”ฆ Type: Feature] [Feature] Add users field to tables #3787
  • [๐Ÿ”ฆ Type: Feature] [Feature] Webhooks only for specific columns #3693
  • [๐Ÿ”ฆ Type: Feature] [Feature] Expanded record view : provide option to display hidden fields #3513
  • [๐Ÿ”ฆ Type: Feature][๐ŸŒฎ Scope : Table] [Feature] Empty table contents #2997
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš˜ Scope : Automation] [Feature] Access old field values in webhooks #2902
  • [๐Ÿ”ญ Scope : Project] [Feature] unique columns #2778
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Allow editing of a Lookup column #2574
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Link Multiple Records to Another Record at the same time (multi-select record linking) #2564
  • [๐Ÿ‘‹ For : Community or Good First Issue] Inflection: none is still capitalising words in some places #2406
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Some Column types are missing when modifying columns #2285
  • [๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Feature: [web hook] update to LTAR doesn't trigger 'on-update' webhook #2104
  • [๐Ÿ”ฆ Type: Feature] Feature : Ability to toggle audit logs #2035
  • [๐Ÿ”ฆ Type: Feature] [Feature] Offer random UUID generation as alternative for the mandatory column ID #2008
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][โ˜Ž Scope : API] Describe API params and body with an example #1767
  • [๐Ÿ—๏ธ Type: In Development] Describe API path, query params etc in docs #1690
  • [๐Ÿ”ฆ Type: Feature][๐ŸŽฐ Scope : Hosting] [Feature] Helm chart #1544
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] Use rollup in formula #1331
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] URL parameter multi field/value filter #1039
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] : Has one #943
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Feature : user type field #500
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿ‘ฎ Scope : Auth] Feature: edit password, firstname and lastname using GUI #417
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][โ˜Ž Scope : API] Token ACL by API #254

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.105.3...0.106.0-beta.0

0.105.3: Bug Fix Release 2/21/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [closed] ๐Ÿ”ฆ Feature: using LinkToAnotherRecord for linking a row to a user from the teams & management #5169
  • [closed] Migration failed : 0100002 to 0104004 #5147
  • [closed] ๐Ÿ› Bug: sticky column field can be dragged & realigned in sql views #5122
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Make stable bound to the audit log #4643
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: LinkToAnotherRecord with a filter set of records #4541
  • [closed] ๐Ÿ”ฆ Feature: parent_id primary key #4319
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Filter's visibility for different users #4228
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Import - Single Select automatic parsing error #4217
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: project lists order manually #4132
  • [๐Ÿ”ฆ Type: Feature] Sticky column to the side #4110
  • [closed] ๐Ÿ› Bug: Import excel / airtable easily accessible #4013
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Option to delete all rows when there are multiple pages #3870

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.105.2...0.105.3

0.105.2: Bug Fix Release 2/17/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: Accessing root url showing old dummy page #5142

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.105.1...0.105.2

0.105.0 2/16/2023

๐Ÿš€ NocoDB Feature Release : Formula Column can be Display-Value column ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

Display-value-column

Display-Value column can be formula and sticky :

  • One of the most requested feature was to make the Display-Value column as formula and sticky.
  • Formula column as sticky would mean : you can combine regular columns of a table and lookups to easily and uniquely recognisable value for that row. Specially helpful when you are browsing a LinkToAnotherRecord
  • A sticky display-value would mean : you can horizontally scroll the spreadsheet without losing the context of the display-value.

PS : Primary-Value columns are now called Display-Value columns

Filters are now business users friendly

  • We've introduced two new filter types is blank and is not blank, which filter outs the blank cells (null or empty values).
  • By default, is null, is not null, is empty and is not empty will be hidden. However, you can enable back by checking Show NULL and EMPTY in Filter in Project Setting.

Besides, some filter types will be removed or migrated. Please refer below summary for reference.

โ—Breaking changes

  • Text-based columns:
    • Unnecessary filters removed : >, <, >=, <=
  • Numeric-based / SingleSelect columns:
    • Unnecessary filters removed : like
    • migrate null, and empty to blank
  • Checkbox columns:
    • Unnecessary filters removed : equal
    • migrate empty and null to notchecked
  • MultiSelect columns:
    • Unnecessary filters removed : like
    • migrate equal, null, empty
  • Attachment columns:
    • Unnecessary filters removed : >, <, >=, <=, equal
    • migrate empty, null to blank
  • LTAR columns:
    • Unnecessary filters removed : >, <, >=, <=
    • migrate empty, null to blank
  • Lookup columns:
    • migrate empty, null to blank
  • Duration columns:
    • Unnecessary filters removed : like
    • migrate empty, null to blank

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€


๐Ÿ› Closed Issues

// Generated by Github Actions

  • [closed] ๐Ÿ› Bug: Cells show incorrect values in UI; cells do not refresh properly. #5098
  • [closed] ๐Ÿ”ฆ Feature: Github Actions Cache Removal after PR merge #5082
  • [closed] ๐Ÿ› Bug: Duplicate Column : cells get highlighted in RED #5070
  • [closed] ๐Ÿ”ฆ Feature: Enable edit menu for lookup & rollup columns #5064
  • [closed] ๐Ÿ› Bug: incorrect values in grid view #5059
  • [closed] ๐Ÿ› Bug: filter table display the wrong results until reload whole webpage #5053
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Lookup to attachment column is not correctly rendered. #5052
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Some features not working on hosted without internet connection #5036
  • [closed] ๐Ÿ› Bug: Failed Upgrade 0.100.2 to 0.104.1 #5032
  • [closed] ๐Ÿ› Bug: Avoid sync calls within backend #5026
  • [closed] ๐Ÿ› Bug: old data remains in spreadsheet #5020
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Can't import .csv or json from main import window : "Cannot read properties of undefined (reading 'is_meta')" #5019
  • [closed] Make the primary column sticky : Video #5007
  • [Status: Reproducible] ๐Ÿ› Bug: Unable to add multiple new empty records using consecutive ALT + R #5006
  • [Status: Reproducible] ๐Ÿ› Bug: blank cell is filled with data from the same cell from a previous page #5005
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Illegal arguments (string, object) on sign in #4997
  • [closed] ๐Ÿ› Bug: Performance degradation when upgrading to 0.104.2 #4992
  • [closed] ๐Ÿ› Bug: Make share a button instead of icon #4986
  • [closed] ๐Ÿ› Bug: Rollup on self-links (LTAR within table) displays incorrect results #4980
  • [closed] ๐Ÿ› Bug: save row on linking a record #4978
  • [๐Ÿ”Ž Status: More Info Needed] Upload attachment and set it in a new row #4935
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Can't delete columns #4858
  • [๐Ÿ”Ž Status: More Info Needed] Bug : MSSQL - Field Date is Defaulting to Varchar instead of Date #4826
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Canยดt update higher than 0.100.2 #4819
  • [closed] ๐Ÿ› Bug: Error 403 when the editor uploads the image #4805
  • [closed] ๐Ÿ› Bug: Can't sync metadata after deleting a column or row #4790
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Multiple incomplete records added while adding new row #4789
  • [closed] ๐Ÿ› Bug: API for nested fields other than primary field #4757
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Export table to CSV not working in 0.100.2 #4659
  • [๐Ÿ› Type: Bug][๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: migration file "nc_013_sync_source" failed | when trying to upgrade nocodb version from 0.90.11 to 0.100.2 (docker) #4651
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Foreign Key name too long #4615
  • [โœจ Type: Enhancement] Enhancements: Keyboard & UX follow up's #4573
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: drop table table-name - SQLITE_ERROR: no such table: table-name #4535
  • [๐Ÿ‘ฉโ€๐Ÿ”ฌ Status: In-Analysis] ๐Ÿ› Bug: nc-help module does not have a main #4323
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Refresh token leads to logging out #3792
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Project info not copied to clipboard - where to find needed info? #3598
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ‘“ Scope : View] Make the primary column sticky #3583
  • [๐Ÿ”ฆ Type: Feature][๐ŸŸฃ Priority: Low][๐Ÿ‘“ Scope : View] [Feature] Delete record option in Gallery view #2101
  • [๐Ÿ”Ž Status: More Info Needed][๐Ÿฅ… DB : MSSQL] Users not displayed #1351
  • [๐Ÿ”ฆ Type: Feature][๐ŸŽ Scope : Row] Feature : Duplicate/clone row #435

0.104.3: Bug Fix Release 2/2/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • [closed] ๐Ÿ› Bug: No picture showed if there is only a single picture attachment in Gallery View #4991
  • [๐Ÿ”ด Priority : Critical] ๐Ÿ› Bug: Re-ordering of images creates invalid input syntax for type json error #4985
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: nc-icon display issues #4974
  • [๐Ÿ”ด Priority : Critical] ๐Ÿ› Bug: Valid attachment JSON is replaced with escaped JSON when saving in Kanban view #4971
  • [closed] ๐Ÿ› Bug: new attachments not showing in Gallery #4958
  • [closed] ๐Ÿ› Bug: Firefox issue with fixed row heigh #4952
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Failed Upgrade 0.100.2 to 0.104.1 #4948
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Upgrade fails from 0.98.4 to 0.101.2 #4946
  • [closed] ๐Ÿ› Bug: form view field validation error message, use alias name instead of original field name #4919
  • [๐Ÿ› Type: Bug][Status: Reproducible] ๐Ÿ› Bug: Search on Kanban View not Working #4895
  • [Status: Reproducible] ๐Ÿ› Bug: Cannot add formula based on Lookup columns #4864
  • [โœจ Type: Enhancement] ๐Ÿ”ฆ Feature: UX improvement: Remove copy invite token button for registered users #4617

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.104.2...0.104.3

0.104.2: Bug Fix Release 1/27/2023

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿ› Closed Issues

  • ๐Ÿ› Bug: Failed Upgrade 0.100.2 to 0.104.1 #4948

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.104.1...0.104.2

0.104.1: Feature Release 1/27/2023

๐Ÿš€ NocoDB Feature Release : ERD Fullscreen, Fixed Row height, Multi-file download ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

4

ERD Fullscreen :

  • Visualising ERD views for table and schema was a feature that our users have been really loving. And now they can go fullscreen and have a bird eyes view of tables and the relationship.

Fixed Row Height

  • Irrespective of the columns and their content - we help you visualise the rows in fixed heights. Why should it be any different in a spreadsheet ? :)

Multi-file download

  • You can now download all files related to a cell with one click.

Row browsing

  • With in-place next-and-previous button in expanded row view - you can easily go to next and previous rows with one-click without having to close and reopen the expanded form.

๐Ÿ• Now, its demo time

Configurable Icons

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€


๐Ÿ› Closed Issues

  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Division in formula display 'Invalid Formula' #4929
  • [๐Ÿš€ Status: Ready for Next Release][Status: Reproducible] ๐Ÿ› Bug: AND() and OR() formulas broken nesting and output in ver 0.102.2 #4920
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Not able to use arrow keys and space key in filter value field #4916
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Checkbox sort in PG locates NULL & false differently #4881
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Local attachments become 404 after setting up a storage plugin #4880
  • [closed] ๐Ÿ› Bug: Immediate Authorization Failure Using Postgres Docker Compose #4878
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Remove or set optional toLowerCase() on Single/Multi Section Type #4874
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Decimal Auto Type Section on Excel Import #4873
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Unable to remove data-source if a lookup column was created #4871
  • [closed] ๐Ÿ› Bug: Unable to set myself as superadmin to access plugin list #4867
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: role creator can delete projects created by owner (or other users) #4863
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Skip displaying AppStore under project-menu #4852
  • [closed] ๐Ÿ› Bug: App Store not working: "pluginList - org-level-creator : Not allowed" #4845
  • [closed] Nocodedb #4839
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Executable release action publishes directly in github action #4837
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Shared form issue #4830
  • [closed] ๐Ÿ› Bug: socket.io does not use subfolder URL #4818
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: DATETIME_DIFF Function's result incorrect in SQLite #4816
  • [closed] ๐Ÿ› Bug: Deleting user from main admin panel needs text change. #4815
  • [๐Ÿ› Type: Bug][๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Kanban goes blank permanently after editing row #4691
  • [closed] ๐Ÿ› Bug: Updating user permissions #4684
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: "Share View" of Kanban is showing up blank #4670
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Publicly shared Gallery Views don't show the cover image #4664
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Modals/Popup about Table dependencies has some flaws #4662
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿฆญ DB : MariaDB] ๐Ÿ› Bug: Default value automatically sets as NULL for SingleSelect #4625
  • [closed] ๐Ÿ› Bug: Kanban View- Grouping Field not automatically coming to kanban view. Also no way to do it manually #4624
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: make ERD diagram full screen and exportable #4616
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Use of space-bar in Shared grid view throws error #4580
  • [closed] Documentation: explain funding/pricing/sustainability model #4522
  • [๐Ÿ”Ž Status: More Info Needed][๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Change Kanban Stack Order #4487
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Filtering on single select empty cells are ignored #4462
  • [๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Latest logo favicon used in API Docs #4396
  • [๐Ÿ‘‹ For : Community or Good First Issue] ๐Ÿ› Bug: Docker terminal not accessible #4372
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: View based Api key forever #4368
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Shared form: Border missing for LTAR column type #4293
  • [closed] ๐Ÿ”ฆ Feature: link to another record custom column #4282
  • [closed] Playwright improvments #4277
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Easily browse from one record to the next (previous record, next record) #4255
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Bug: Attachment URLs are stored with base_url prefixed #4185
  • [๐Ÿ—๏ธ Type: In Development] [PR# 3847] Error observed with migrated DB during project table navigation #4002
  • [closed] Environments for each PR made #3990
  • [closed] ๐Ÿ› Bug: Shared Views do not honour project theme #3974
  • [Scope : Test [E2E]] [Cypress][CI-CD] Grid view not rendered #3903
  • [Scope : Test [E2E]] [Cypress] Add tests for Single-select & Multi-select data type #3858
  • [closed] [Feature] Count items on a many-to-many column #3800
  • [closed] DevOps issues #3527
  • [closed] nocodb org readme #3415
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: vue3 : While creating lookup - show LinkToAnotherRecord instead of ChildTable #3403
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘“ Scope : View] vue3 : Use right side drawer for SharedView list and add new row #3332
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ญ Scope : Project] [Feature] Include google fonts / Prevent fonts to be loaded from google #3059
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ‘ฎ Scope : Auth] Feature request - Change admin email & manually approve users #2973
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿฐ Scope : Column] [Feature] Limit attachments #2905
  • [๐Ÿ‘‹ For : Community or Good First Issue] Old table structure after upgrading from 0.84.16 to 0.92.3 #2601
  • [๐Ÿ› Type: Bug][๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Form fields are loaded incompletely when the view is being shared #2514
  • [๐Ÿ‘‹ For : Community or Good First Issue] Sort option not displaying columns properly or fully #2481
  • [๐Ÿ”Ž Status: More Info Needed] Field Check Boxes Unresponsive on Android #2480
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿฐ Scope : Column] [Feature] Visual distinction between NULL and empty string #2409
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿฐ Scope : Column] [Feature] Cell Display Options #2287
  • [๐Ÿ•Š๏ธ Type: Migration] Migration from 0084002 to 0090000 failed #2155
  • [๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Bug: [web-hook] error in data payload #2103
  • [๐Ÿ› Type: Bug] Canยดt create form view #2031
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Filtering by checkbox columns is inconsistent #2014
  • [๐Ÿ”Ž Status: More Info Needed] Canยดt create gallery view or form view #1971
  • [๐Ÿ”ฆ Type: Feature] Paid upgrades/modules #1887
  • [closed] Delete table button shouldn't be adjacent to add row #1826
  • [๐ŸŸฃ Priority: Low][๐Ÿ—๏ธ Type: In Development] m2m table listed in meta-sync tab #1708
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] Add comments to cell / record #1538
  • [๐Ÿ”Ž Status: More Info Needed] Tables are not created on Postgres #1323
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] Multiselect manual ordering #1141
  • [๐Ÿ”ฆ Type: Feature][โ˜Ž Scope : API] [Feature] Limit API Token Permissions #941
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ‘“ Scope : View] [Feature] Gantt view #854
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Embed NocoDB in browser for offline usage #849
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿ‘“ Scope : View] Feature : Set fixed row height #831
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘‹ For : Community or Good First Issue][๐ŸŽƒ For : Hacktoberfest][๐Ÿš€ Status: Ready for Next Release][๐Ÿฐ Scope : Column] ๐Ÿ› Bug: Filtering MultiSelect in more than basic way #534
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Lookup column has a different display format than origin #416
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿš€ Status: Ready for Next Release][๐Ÿฐ Scope : Column] Feature: Select multiple files and download attachments. #335

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.101.2...0.104.1

0.101.2: Bug Fix Release 1/14/2023

๐Ÿš€ NocoDB : Bug Fix Release

  • [closed] ๐Ÿ”ฆ Feature: Trigger Webhook (after update) for changes in LinkToAnotherRecord field #4827
  • [closed] ๐Ÿ”ฆ Feature: Show all the rows on the same page #4813
  • [closed] ๐Ÿ”ฆ Feature: Move columns/rows using a drag & drop gesture #4811
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Show option to create new option for select fields only to owner/creator #4801
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Unexpected project_id in created filters #4793
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: LinkToAnotherRecord field is not shown in Gallery view if there is no record linked #4782
  • [๐Ÿ› Type: Bug][๐Ÿน DB : SQLite][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: DATETIME_DIFF Not Working on sqlite #4778
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Formula field: miscellaneous observations #4768
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: symbol col.table_name not found on PlanetScale #4763
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: JSON column save button not working #4760
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ด Priority : Critical] ๐Ÿ› Bug: Remove datasource fails with root DB MySQL PG #4759
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Cell copy paste behaviour inconsistent #4758
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Facing issue while building gui on Windows #4737
  • [โœจ Type: Enhancement][๐Ÿ˜ DB : Postgres][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Using SUBSTR on date fields not working - Extract date, time, year from the date field #4732
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: incorrect documentation - NC_DB is not mandatory but specified as mandatory #4724
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: inconsistent project tree view after project rename #4722
  • [๐Ÿฐ Scope : Column] ๐Ÿ› Bug: vue3: allow typing to narrow down search when selecting table for LTAR #3488

0.101.0: Feature Release 1/12/2023

๐Ÿš€ NocoDB Feature Release: Snowflake Support, BarCode Column & Emojis ๐Ÿš€

image

๐Ÿฅฌ What's new .. What's fresh ?

Snowflake Database support (Enterprise Feature - Early Preview)

This is an enterprise-only feature available for preview freely. You can add a nocodb enterprise key in the UI to get started (any value at the moment will do). And you should be able to unlock all the productivity features of a nocodb spreadsheet on your own Snowflake database.

Barcode Column

(This feature was completely implemented by our wonderful community member @flisowna ๐Ÿ‘)

A barcode column type is out! This new feature allows users to quickly scan and input barcode information in various supported formats including CODE128, EAN, EAN-13, EAN-8, EAN-5, EAN-2, UPC (A), CODE39, ITF-14, MSI, Pharmacode, Codabar. This new column type is compatible with the following valid column types, namely Number, SingleLineText, LongText, PhoneNumber, URL, Email, and Decimal.

We are thrilled to enable our customers with this new feature, which will help simplify the process of capturing, validating, and saving barcode information. With this innovative new feature, users can save time and reduce errors when entering barcode data.

We hope our customers enjoy the new barcode column type, and we look forward to continuing to bring our customers the latest innovations.

Reconfigurable table & view icons

Move over boring standalone static icons for tables & views. Add more colours, differentiate visually by opting out for separate icon for each table / view.

Add Data Source from within the project

We have now moved the option to add an existing database from within the project. No longer you have to do it from while creating the project. This change allows us to add multi data sources in the future (its available behind an easter egg at the moment ;)

๐Ÿ• Now, its demo time

Snowflake

https://user-images.githubusercontent.com/5435402/209937139-d00c6ff4-7061-43f2-936e-e5092c9f8f8d.mov

Barcode Column

https://user-images.githubusercontent.com/35857179/209751834-3e8eddfa-083d-448f-9a16-fcb74727cd3e.mp4

Multidata source

https://user-images.githubusercontent.com/5435402/209937133-3c1421de-33ff-4b5a-a832-1d75ef25cc5c.mov

๐Ÿ› Closed Issues

  • [๐Ÿ› Type: Bug][Status: Not Reproducible] ๐Ÿ› Bug: formula value in webhook comes up as output #4756
  • [๐Ÿ”ฆ Type: Feature] feat: Freeze columns and header #4753
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Disable edit option for cells in shared view #4750
  • [closed] Android #4739
  • [closed] ๐Ÿ”ฆ Feature: Need aggregation capabilities #4730
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: table icon configuration not visible with multiple sources #4713
  • [๐ŸŸ  Priority: High] ๐Ÿ› Bug: NC_INVITE_ONLY_SIGNUP env is not working with 0.100.2 #4708
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: When the primary key contains /, an error occurs when updating data #4704
  • [๐Ÿš€ Status: Ready for Next Release][Status: Reproducible] ๐Ÿ› Bug: using arrow keys to scroll through lookup or rollup values reports an error in cell #4702
  • [๐Ÿš€ Status: Ready for Next Release][Status: Reproducible] ๐Ÿ› Bug: Error popup when clearing a number field for a row in a postgres database #4701
  • [๐Ÿš€ Status: Ready for Next Release][๐ŸŸ  Priority: High] ๐Ÿ› Bug: Adding attachment is failing for editor role #4699
  • [closed] ๐Ÿ› Bug: nocodb\packages\nocodb\node_modules\sqlite3\lib\binding\napi-v6-win32-unknown-x64\node_sqlite3.node is not a valid Win32 application #4695
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Shared view link access (in incognito) redirects to sign-in page #4694
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: sql query and sql import #4689
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Cursor movements blocked during view rename #4686
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: expected a string but received a array #4685
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: SyntaxError: Unexpected token } in JSON --> breaks and lost all data in table #4682
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Provide iframe details for share view too #4680
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: More information on LinkToAnotherRecord Hover #4677
  • [closed] Suggestion: Add bounties? #4652
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: when I import a csv file,I ge a 404 error #4648
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: When saving long text the cell size increases #4639
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Lost value when judgement of empty value of cell #4638
  • [closed] Enhancement: Retain search items on tab switch #4636
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: referenced Number is "null" if the Value in the other Table is 0 #4628
  • [closed] ๐Ÿ› Bug: Error comes whenever monaco editor is opened #4619
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: nocodb still allows open invitation if google app ID is set #4618
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][Status: Reproducible] ๐Ÿ› Bug: Can't upload csv with empty value for 'Date' filed #4610
  • [closed] ๐Ÿ› Bug: Setting primary value removes existing relations #4606
  • [๐Ÿ› Type: Bug][๐ŸŽฐ Scope : Hosting] ๐Ÿ› Bug: 1-click deploy to heroku is broken #4602
  • [closed] Upload csv for existing data not working, #4600
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Create API broken (partially) for attachment after upgrade #4597
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Formula edit modal continues to display older column name in formula after rename #4595
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Formula issues with column names with a space in their names #4592
  • [๐Ÿ› Type: Bug][๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Expert a string but recevied an array #4589
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Add Formatting option to Datetime field #4582
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Extend support for Expanded row in Shared view #4579
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐ŸŸ  Priority: High] ๐Ÿ› Bug: Not able to type in expanded form if trying to add record from LTAR list #4575
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: change the error prompt for forgot password #4570
  • [๐Ÿ› Type: Bug][๐Ÿ˜ DB : Postgres][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Formula - IF failed on date columns on PG #4546
  • [๐Ÿš€ Status: Ready for Next Release][๐ŸŸฃ Priority: Low] ๐Ÿ› Bug: Column order not as configured in Download XLSX from shared grid view #4537
  • [closed] ๐Ÿ› Bug: On going issues in develop ( >0.99.2 ) #4529
  • [closed] Feature : Column options #4523
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Feeding any character when date cell in-focus, clears cell contents #4493
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: json Column โ†’ returning null, errors in console, won't save #4484
  • [๐Ÿ—๏ธ Type: In Development] [PR] Keyboard manoeuvre : open items #4407
  • [๐ŸŸ  Priority: High][๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Bug: Tab switch in a certain usecases is leading to block of UI #4402
  • [closed] ๐Ÿ› Bug: Windows Binary #4394
  • [๐Ÿ—๏ธ Type: In Development] [feat/multiple-source] Failed to open project #4355
  • [๐Ÿงฑ Type: Refactoring] refactor: clean up nc-cli #4334
  • [closed] ๐Ÿ› Bug: cell data disappears after page refresh #4329
  • [closed] ๐Ÿ› Bug: Socket hang up when importing from Airtable #4326
  • [closed] ๐Ÿ› Bug: Text in GridView gets deleted at the end while inputting text in SingleLineText cell #4303
  • [Status: Not Reproducible] ๐Ÿ› Bug: Duplicated user entries showing up #4264
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: AT import fails if other tables present in project #4230
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Abort trap: 6 #4177
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: TOKEN API can be use in all Project #4163
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Single select and Multiple Select -> allow adding new option within the cell. #4095
  • [closed] ๐Ÿ› Bug: Previous project table count is shown in current project #4028
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: The migration directory is corrupt, the following files are missing: nc_011_remove_old_ses_plugin #3997
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: DATEDIFF() #3950
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: Playwright for e2e tests #3939
  • [๐Ÿ”Ž Status: More Info Needed] ๐Ÿ”ฆ Feature: DropDown menu in nocoDB form #3934
  • [๐Ÿš€ Status: Ready for Next Release] Quick Import - AIRTABLE (Cannot read property 'length' of undefined) #3927
  • [๐Ÿ› Type: Bug][๐Ÿ”Ž Status: More Info Needed] ๐Ÿ› Bug: Filtering with equal operator is not working as expected #3874
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Cannot restrict users from creating projects #3867
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Display option for JSON row #3826
  • [๐Ÿ› Type: Bug][๐Ÿ”Ž Status: More Info Needed] Import currency field #3788
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] [Feature] Allow editing of the db credentials for a project which is on external db #3700
  • [๐Ÿ› Type: Bug][๐Ÿ‘“ Scope : View] ๐Ÿ› Bug: Opening Editor component throws errors in console #3631
  • [๐Ÿ”ฆ Type: Feature] Column type : QR Code #3581
  • [โœจ Type: Enhancement][๐Ÿ—๏ธ Status: In Resolution] Cypress tests improvements #3580
  • [๐Ÿ”Ž Status: More Info Needed] npm start on dashboard showing 404 Not Found #3047
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] Use Formula result in Rollup #3014
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Pressing the "here"-button in the "For production please see here." message does nothing #2823
  • [๐Ÿ—๏ธ Type: In Development] Select v2: error on reconfiguring dbType to varchar #2765
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] [Feature] Option to reconfigure external DB configuration parameters #2657
  • [๐Ÿ”Ž Status: More Info Needed] PostgreSQL specific type "inet" looks as empty string on NocoDB #2556
  • [๐Ÿ”Ž Status: More Info Needed] Suspected Memory Leak #2510
  • [๐Ÿ› Type: Bug] Unexpected errors when switching between tables #2494
  • [๐Ÿ”Ž Status: More Info Needed] "The "config.option.port" property must be of type number" and other issues #2305
  • [๐Ÿ”Ž Status: More Info Needed] When I create a new form and find that the field properties are incorrect, I can't change them. #2202
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] [Feature] Option to reconfigure (or) disable auto-save timeout during cell updates #2133
  • [๐Ÿ”ฆ Type: Feature] [Feature] Support rollup columns on virtual columns #1844
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] First load from docker or sharedbase or project is slow #1721
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ‘“ Scope : View] [Feature] Show the buttons without operation permission as gray. #1621
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [Feature] Multiple Link between records #1462
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Updating an existing webhook leads to an error #1439
  • [๐Ÿ”Ž Status: More Info Needed] Support ?ssl=true is NC_DATABASE_URL #1369
  • [๐Ÿ”ฆ Type: Feature][โ˜Ž Scope : API] [Feature] Limit Swagger API access #1338
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Multiselect edits not reflected across row values #1286
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: Digital Ocean default docker setup with a postgres database provided by DO doesn't run. #1174
  • [๐Ÿ”ฆ Type: Feature][๐ŸŒฎ Scope : Table] [Feature] Multilink between tables #1158
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project][โ˜Ž Scope : API] [Feature] Hide main Table view from comment and view roles #834
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš˜ Scope : Automation] After Update automation has access to old field value #808
  • [๐Ÿ› Type: Bug] Multiple id columns are shown when there is only 1 id column in the table. #806
  • [๐Ÿ’ก Type: Idea] Usability improvement suggestion from Discord user #803
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] New user pain points related to SQLite and improper error messages #749
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] [FEATURE] limit attachments to upload #685
  • [๐Ÿ”ฆ Type: Feature][๐Ÿฐ Scope : Column] Changing ID type fails #603
  • [โœจ Type: Enhancement] Feature: edit external database connection details #439
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿฐ Scope : Column] special characters in column names #411
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿ‘“ Scope : View] Issue: Align data to top in grid view #345
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ‘ฎ Scope : Auth] Feature: open user registration #284
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿšฅ Status: On Hold][๐Ÿ‘ฎ Scope : Auth] Ability to delete users #214
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Feature : Provide sample projects. #207
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Feature : Drag & Drop for dashboard #160
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Feature : SQL Editor #137
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Feature : SQL : Support Procedures & Functions #136

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.100.2...0.101.0

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€

0.101.0-beta.0 12/29/2022

๐Ÿš€ NocoDB Feature Pre-Release : Snowflake Support, BarCode Column & Emojis ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

Snowflake Database support (Enterprise Feature - Early Preview)

This is an enterprise-only feature available for preview freely. You can add a nocodb enterprise key in the UI to get started (any value at the moment will do). And you should be able to unlock all the productivity features of a nocodb spreadsheet on your own Snowflake database.

Barcode Column

A barcode column type is out! This new feature allows users to quickly scan and input barcode information in various supported formats including CODE128, EAN, EAN-13, EAN-8, EAN-5, EAN-2, UPC (A), CODE39, ITF-14, MSI, Pharmacode, Codabar. This new column type is compatible with the following valid column types, namely Number, SingleLineText, LongText, PhoneNumber, URL, Email, and Decimal.

We are thrilled to enable our customers with this new feature, which will help simplify the process of capturing, validating, and saving barcode information. With this innovative new feature, users can save time and reduce errors when entering barcode data.

We hope our customers enjoy the new barcode column type, and we look forward to continuing to bring our customers the latest innovations.

Reconfigurable table & view icons

Move over boring standalone static icons for tables & views. Add more colours, differentiate visually by opting out for separate icon for each table/view

Screenshot 2022-12-29 at 4 55 45 PM

Add Data Source from within the project

We have now moved the option to add an existing database from within the project. No longer you have to do it from while creating the project. This change allows us to add multi data sources in the future (its available behind an easter egg at the moment ;)

๐Ÿ• Now, its demo time

Snowflake

https://user-images.githubusercontent.com/5435402/209937139-d00c6ff4-7061-43f2-936e-e5092c9f8f8d.mov

Barcode Column

https://user-images.githubusercontent.com/35857179/209751834-3e8eddfa-083d-448f-9a16-fcb74727cd3e.mp4

Multidata source

https://user-images.githubusercontent.com/5435402/209937133-3c1421de-33ff-4b5a-a832-1d75ef25cc5c.mov

๐Ÿ› Closed Issues

  • [๐ŸŸ  Priority: High] ๐Ÿ› Bug: NC_INVITE_ONLY_SIGNUP env is not working with 0.100.2 #4708
  • [closed] ๐Ÿ› Bug: nocodb\packages\nocodb\node_modules\sqlite3\lib\binding\napi-v6-win32-unknown-x64\node_sqlite3.node is not a valid Win32 application #4695
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: sql query and sql import #4689
  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: More information on LinkToAnotherRecord Hover #4677
  • [closed] Suggestion: Add bounties? #4652
  • [closed] Enhancement: Retain search items on tab switch #4636
  • [closed] ๐Ÿ› Bug: Error comes whenever monaco editor is opened #4619
  • [closed] ๐Ÿ› Bug: Setting primary value removes existing relations #4606
  • [๐Ÿ› Type: Bug][๐ŸŽฐ Scope : Hosting] ๐Ÿ› Bug: 1-click deploy to heroku is broken #4602
  • [closed] Upload csv for existing data not working, #4600
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐ŸŸ  Priority: High] ๐Ÿ› Bug: Not able to type in expanded form if trying to add record from LTAR list #4575
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: change the error prompt for forgot password #4570
  • [closed] ๐Ÿ› Bug: On going issues in develop ( >0.99.2 ) #4529
  • [closed] Feature : Column options #4523
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Feeding any character when date cell in-focus, clears cell contents #4493
  • [๐ŸŸ  Priority: High][๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Bug: Tab switch in a certain usecases is leading to block of UI #4402
  • [closed] ๐Ÿ› Bug: Windows Binary #4394
  • [๐Ÿ—๏ธ Type: In Development] [feat/multiple-source] Failed to open project #4355
  • [closed] ๐Ÿ› Bug: cell data disappears after page refresh #4329
  • [closed] ๐Ÿ› Bug: Socket hang up when importing from Airtable #4326
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: AT import fails if other tables present in project #4230
  • [๐Ÿ› Type: Bug] ๐Ÿ› Bug: TOKEN API can be use in all Project #4163
  • [๐Ÿ› Type: Bug][๐Ÿ”Ž Status: More Info Needed] Import currency field #3788
  • [๐Ÿ”ฆ Type: Feature] Column type : QR Code #3581
  • [๐Ÿ”Ž Status: More Info Needed] npm start on dashboard showing 404 Not Found #3047
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] Pressing the "here"-button in the "For production please see here." message does nothing #2823
  • [๐Ÿ—๏ธ Type: In Development] Select v2: error on reconfiguring dbType to varchar #2765
  • [๐Ÿ”Ž Status: More Info Needed] PostgreSQL specific type "inet" looks as empty string on NocoDB #2556
  • [๐Ÿ”Ž Status: More Info Needed] Suspected Memory Leak #2510
  • [๐Ÿ”Ž Status: More Info Needed] "The "config.option.port" property must be of type number" and other issues #2305
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ”ญ Scope : Project] New user pain points related to SQLite and improper error messages #749

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.100.2...0.101.0-beta.0

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€

0.100.2 : Bug Fix Release 12/2/2022

๐Ÿš€ NocoDB : Bug Fix Release

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.100.1...0.100.2

0.100.1 : Feature release 12/1/2022

๐Ÿš€ NocoDB Feature Release : QR Code, Keyboard Shortcuts and ... ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

Import Airtable to NocoDB

:clapper: QR Code

We are excited to announce a new column type : QR Code! This generates QR Code for any row. QR Code generations works similar Forumula and currently supports these columns :

  • SingleLine Text
  • Long Text
  • Phone Number
  • Email
  • URL
  • Formula

Support for more columns will come soon.

And the more exciting bit of this feature is it is done by our community contributor Daniel (@spaudanjo) - Daniel is software engineer by profession and is passionate about building tech where there is humanitarian crisis. And he has dedicated time aside & raised grants to work on Noco.

:keyboard: Keyboard Shortcuts

With combinations of keys, you can trigger some actions without moving your mouse.

:cool: Copy and Paste

With Ctrl + C and Ctrl + V, we can copy the data from one cell to another, even to another tables. For LTAR columns, only BelongTo is supported.

:zap: Advanced Options in Column Menu

Advanced options has been added to the column menu. Now we can sort the column in an ascending order or descending order, hide the column, duplicate it or even insert the column after / before the chosen one. Also we show the count in badge for Fields, Filter and Sort.

๐Ÿ• Now, its demo time

:clapper: QR Code

In this version, we introduced a new column type - QR Code.

QR Code is a virtual column which supports different column types for the referenced value to be encoded. The generated QR code is dynamic, which means whenever the referenced column is changed, the QR code will be updated as well.

0.100.0-qr-code.webm

:keyboard: Keyboard Shortcuts

By pressing ctrl + /, you can see the available shortcut keys. Or you can check it out in Help Center.

If you are a Mac user, ctrl is cmd key.

0.100.0-keyboard-shortcuts.webm

:cool: Copy and Paste

Now you can copy a single cell and paste it to another cell. To copy the data, select the target cell and press ctrl + c , then press ctrl + v on the target cell. It could be another table and the existing cell data will be replaced.

0.100.0-copy-and-paste.webm

:zap: Advanced Options in Column Menu

Screenshot 2022-11-29 at 4 43 16 PM Screenshot 2022-11-29 at 4 43 29 PM

๐Ÿ‘€ Coming soon - a teaser below ๐Ÿ‘€ ๐ŸŽ‰ ๐Ÿš€

  • Supporting multiple database from a single project ๐Ÿคฏ ๐ŸคŸ โค๏ธ

https://user-images.githubusercontent.com/5435402/195718718-df3d6c14-8be6-4148-a2b4-2f0c5e23aa96.mp4

We cannot wait to release them soon. ๐Ÿค

๐Ÿ› Closed Issues

  • [๐Ÿ”ฆ Type: Feature] ๐Ÿ”ฆ Feature: LinkRecord modal, additional information in link cards like vika #4539
  • [closed] ๐Ÿ› Bug: Super admin is not assigned. How to asign and change admin? #4532
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Related database is not shown correctly since upgrade from 0.99.0 to 0.99.1 #4500
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: dropdown not getting destroyed from DOM #4369
  • [๐Ÿ‘‹ For : Community or Good First Issue] Not all fields are populated when using uuid field instead of serial id field #270
    • [closed] ๐Ÿ› Bug: No data displayed when navigating from a table on page 2 to a table that only has one page #4553
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Grid cell in edit mode - mouse based operations doesn't work #4542
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Attachment photo file size issue #4528
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Division in formula display nothing #4527
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Cell contents are not stored in BE for column type Year & Time #4520
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Unable to click after using IP address as URL #4517
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Using CTRL key to move inside webhook editor moves cursor on the underlying data sheet instead #4512
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Color coding for has-many, many-to-many, belongs-to relation #4501
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Allow pasting into text field without having to enter edit mode first #4496
  • [๐Ÿ› Type: Bug][๐Ÿน DB : SQLite][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: number sorting and filters don't work when column was changed from text to something numberic #4380
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐ŸŸก Priority: Medium] Creating composite PK in MySQL & Sqlite results in failure #1263
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐ŸŒฎ Scope : Table] [Feature] Copy-Pasting from NocoDB tables #978
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ญ Scope : Project] [Feature] Allow editing fileds if SQLite database is being used. #869

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.99.2...0.100.1

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€

0.99.2 : Bug Fix Release 11/26/2022

๐Ÿš€ NocoDB : Bug Fix Release

Closed issue

  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Cannot read properties of null (reading 'parentNode') #4494
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: onSearch should work with showSearch instead of use alone. #4489
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: In Record Detail/Edit overlay, cursor jumps into another input field after typing the first character #4483
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Webhook payload includes attachment json as string #4480
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Search should be separate for each table #4449
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: SingleSelect options do not keep their order #4429

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.99.1...0.99.2

0.99.1 : Bug Fix Release 11/25/2022

๐Ÿš€ NocoDB : Bug Fix Release

๐Ÿšจ Breaking change ๐Ÿšจ

  • Attachment field in list/read API will be a json (array of objects) instead of a json (string).

Closed issue

  • [closed] ๐Ÿ› Bug: NC_AUTH_JWT_SECRET is not inserted to nc_store #4470
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ด Priority : Critical] ๐Ÿ› Bug: Shared Gallery View requires a log in #4447
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: When the page number is greater than 1, the data cannot be queried #4432
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Need to click on "Cancel" after saving in order to close record editor #4430
  • [๐Ÿ› Type: Bug][๐Ÿฅ… DB : MSSQL][๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ด Priority : Critical] ๐Ÿ› Bug: fail to connect MSSQL db #4419
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: JSON columns aren't editable #4397
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Persian forms are loaded from Left to Right #4388
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Importing CSV without data results in infinity wait #4383
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Update row Failed on table with multiple primary key #4357
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Formula to isolate last name not working #4343
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Record url with tablename is not rightly encoded #4328
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Form validation failed #4276
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Unauthorized projects should not be listed #4265
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Validation messages missing in table create dialog #3659
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿฐ Scope : Column] Set Content-Type when upload file #2918

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.99.0...0.99.1

0.99.0 : Feature release 11/22/2022

๐Ÿš€ NocoDB Feature Release : Easy cell edit for all data types ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

Edit all data types within a cell with ease of keyboard. No mouse required.

  • Just hit enter on each cell. And edit the cell as you like.
  • Examples :
    • Even supports adding new single-select and multi-select option this way.
    • Press a number to change the rating.
    • Press space bar on a cell to open the row in expanded form.

Account Settings for Users and Super Admin

  • Super-admin gets new privilege to do seamless user management. (Exclusive to super admin)
    • org-level-creator role - this user can create a new project and access any invited project
    • org-level-viewer role - this user can't create a new project but they can access any invited project
  • New Signup can be enabled/disabled the super-admin with just a click of mouse. (Exclusive to super admin)
    • No longer it's required to set env variable for this.
  • Reset Password
    • The page for changing passwords is now moved to Users > Reset Password.
  • Token management
    • All new tokens created will be associated created user permissions. Easy to reason about.
    • Existing token will work as it is and only be visible to the super admin.

๐Ÿ• Now, its demo time

Account Settings

0.99.0-account-settings.webm

๐Ÿ‘€ Coming soon - a teaser below ๐Ÿ‘€ ๐ŸŽ‰ ๐Ÿš€

  • Supporting multiple database from a single project ๐Ÿคฏ ๐ŸคŸ โค๏ธ

https://user-images.githubusercontent.com/5435402/195718718-df3d6c14-8be6-4148-a2b4-2f0c5e23aa96.mp4

We cannot wait to release them soon. ๐Ÿค

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€


What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.98.4...0.99.0

0.98.4 : Bug Fix Release 11/8/2022

๐Ÿš€ NocoDB : Bug Fix Release

Closed issue

  • [closed] Tests (Playwright): Break test if un-expected network error message received #4300
  • [closed] ๐Ÿ”ฆ Feature: Rename View #4281
  • [closed] ๐Ÿ› Bug: Error during changing backend DB #4262
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ด Priority : Critical] ๐Ÿ› Bug: Editing cell (insert/update/delete) clear's off data from LTAR cell #4220
  • [closed] ๐Ÿ› Bug: New rows can't be retrieved after successful csv import message #4206
  • [closed] ๐Ÿ› Bug: Docmentใ€Development setupใ€‘not working #4158

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.98.3...0.98.4

0.98.3 : Bug Fix Release 10/28/2022

๐Ÿš€ NocoDB : Bug Fix Release

Closed issue

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.98.2...0.98.3

0.98.2 10/27/2022

๐Ÿš€ NocoDB : Bug Fix Release

Improvements

  • Airtable Import
  • CSV Import

Closed issue

  • [closed] ๐Ÿ› Bug: Text disappears while typing because of autosave. #4146
  • [closed] ๐Ÿ”ฆ Feature: change line wanted #4133
  • [๐Ÿคทโ€โ™€๏ธ Status: Won't Fix] ๐Ÿ› Bug: Date time issue #4129
  • [closed] ๐Ÿ”ฆ Feature: Add label and description column in View Form #4116
  • [closed] Is it possible to get data from Redmine and receive data import to NocoDb by using API #4079
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Edit column modal always focuses on column name input box on re render #4056
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: npx create-nocodb-app installed v0.92.4 #4042
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: npx create-nocodb-app doesn't run #4041
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: OpenAPI spec errors #4034
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Bug: Insert new row for tables with auto generated primary key #4029
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ‘“ Scope : View] ๐Ÿ› Bug: Issues with view order in the view sidebar #4021
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Clear selected cell by pressing delete #4016
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Image, on click from expanded row - appears in background #4004
  • [closed] ๐Ÿ› Bug: Windows download links broken and unsecure links promoted in docs #3998
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Clear cell doesn't work for Linked records field #3988
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Enabling Locked view, right click context options for project tree gets disabled #3987
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ”ฆ Feature: Share view option for Gallery #3986
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Error observed on deleting table #3971
  • [๐Ÿš€ Status: Ready for Next Release][Scope : Test [E2E]] [Cy] Delete table operation inconsistent #3969
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Changing the column types don't always change the corresponding Icon #3955
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Webhook Error: You must pass a string or Handlebars AST to Handlebars.compile. You passed [object Object] #3932
  • [๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿš€ Status: Ready for Next Release] [DOCS] Link the license to ReadMe #3910
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Binaries for PR is not working #3897
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Single select - renaming option value doesn't alter configured default value #3896
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: singleselect column type creation is failed because of high no of values #3892
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Change of column is not showing affect on database #3891
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Single select options update fail if default value is configured #3890
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: text field is populated as datetime field when table is created from import csv #3889
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Shared view download CSV doesn't apply configured filters #3887
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: NC_CONNECT_TO_EXTERNAL_DB_DISABLED env variable not working #3865
  • [๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Shared grid view SORT option broken #3859
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Scroll option missing for select column edit menu #3854
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] SDK: DB paging and limit not correct implemented #3825
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Bug: Reload icon in gallery view is not working #3784
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] Restrict access to app store #3781
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ‘“ Scope : View] Cannot open after upgrading version #3780
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Entire view flashes when a new linked record is added #3769
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] Shift view when you tab right/left to additional columns #3768
  • [๐Ÿš€ Status: Ready for Next Release] [API] Get Return 400 after some time #3767
  • [closed] Error after update (0.96.2) #3762
  • [๐Ÿš€ Status: Ready for Next Release][โ›ต Type: AT Import] Import Airtable to SQL Databases : MySQL import fails if single select doesn't have options defined #3757
  • [๐Ÿš€ Status: Ready for Next Release][โ›ต Type: AT Import] Import Airtable to SQL Databases : Self link's [LTAR to same table] are not imported #3753
  • [closed] Is there a keyword shortcut for inserting a new row? #3746
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] RTL view for ar language[Feature] #3725
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ด Priority : Critical] Perf/Memory issues #3705
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Table view is empty on initial render #3702
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Save a new row when only all required fields are entered #3696
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Error on deleting option from select field #3688
  • [๐Ÿš€ Status: Ready for Next Release] Filter active badge persist even after clearing filter list #3674
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] Duration column : icon displayed is that of number #3654
  • [โœจ Type: Enhancement] Enhancement- Import template, display duplicate column name error #3653
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿ‘“ Scope : View] Feature : Survey form view #3557
  • [๐Ÿš€ Status: Ready for Next Release] Show nc version in the project menu (left top) #3553
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release] CSV import : auto-populate multi-select options #3512
  • [๐Ÿ”Ž Status: More Info Needed] Improve validation of add filter form #3429
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] vue3: View related data should persist even when the view is changed #3261
  • [โœจ Type: Enhancement][๐Ÿš€ Status: Ready for Next Release][๐ŸŒž Scope : Data source] Time change after import excel #3036
  • [closed] Checkbox as textbox in link expanded form #3018
  • [๐Ÿ”Ž Status: More Info Needed] Exporting CSV does not support Chinese. #2701
  • [closed] CSV import failed #2446
  • [closed] [Bug] Cannot save a newly row (inline editor) ๐Ÿšจ #2193
  • [closed] Has Many single select filtering not working #1341
  • [๐Ÿงฑ Type: Refactoring] Refactor: centralising cell value rendering logic #1017
  • [โœจ Type: Enhancement] When importing Excelsheet the scroll bar for field mapping is very hard to see #984
  • [๐Ÿ”ฆ Type: Feature][๐ŸŽ Scope : Row] Feature : Row number required #787
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿ‘“ Scope : View] Feature : Support Kanban view #140

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.98.1...0.98.2

0.98.1 10/14/2022

๐Ÿš€ NocoDB Feature Release : Kanban View & Survey Form ๐Ÿš€

๐Ÿฅฌ What's new .. What's fresh ?

  • ๐Ÿ“— Kanban View: Its slick and its FREE! Display your data in different stacks and rearrange card items by drag-and-drop.
    • Grouped by SingleSelect column
    • Share your Kanban View with others by a link with / without password
    • Support Cover Image
  • ๐Ÿ“ Survey Form: Gorgeous & limitless survey forms on your own databases.
    • Share with different themes
    • Supports dark mode
  • ๐Ÿ–ผ๏ธ Gallery Share View: Showcase your image gallery to the world with a simple click of a button!
  • ๐Ÿ“‹ Copy From Multiple Cells: Now you can drag to select multiple cells and copy the data!
  • ๐Ÿ“ˆ Performance Optimization: The size of the production build snapshot has been reduced by ~33MB.

๐Ÿ• Now, its demo time

๐Ÿ“— Kanban View - they are slick and they are free!

https://user-images.githubusercontent.com/35857179/195574518-8edd7c89-6b5d-419a-9aaa-44dfb89084de.mp4

๐Ÿ“ Survey Form - unlimited & gorgeous!

https://user-images.githubusercontent.com/35857179/195617967-ad3a33f0-d8a2-4c16-9973-1636a480646f.mov

image

๐Ÿ“‹ Copy From Multiple Cells - productive!

https://user-images.githubusercontent.com/24416449/192377362-c86a6539-6297-44b8-b0c6-364cf0a941de.mp4

๐Ÿ‘€ Coming soon - a teaser below ๐Ÿ‘€ ๐ŸŽ‰ ๐Ÿš€

  • Supporting multiple database from a single project ๐Ÿคฏ ๐ŸคŸ โค๏ธ

https://user-images.githubusercontent.com/5435402/195718718-df3d6c14-8be6-4148-a2b4-2f0c5e23aa96.mp4

We cannot wait to release them soon. ๐Ÿค

๐Ÿ› Closed Issues

  • [๐ŸŽƒ For : Hacktoberfest] [Cy]: Circular reference in Formula column #4024
  • [๐Ÿ—๏ธ Type: In Development] ๐Ÿ› Bug: Missing uncategorised title when stack is collaped #3991
  • [๐Ÿ—๏ธ Type: In Development] [Survey form] Cell cursor persists in edit mode on {enter} #3968
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] ๐Ÿ› Bug: Typing in Filters -> 'Select field" doesn't work #3964
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Empty record in uncategorised stack #3959
  • [closed] ๐Ÿ”ฆ Feature: Hide fields from API calls #3957
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] URL for Expand row error's #3952
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Expand record doesn't open drawer for roles = Commenter/Viewer #3949
  • [closed] ๐Ÿ› Bug: Is there a way to use the API to post or patch a new record with a many-to-many / linked record relationship? #3923
  • [Scope : Test [E2E]] [Cypress] Reduce Cy.wait() & replace with appropriate class selectors & intercepts #3906
  • [๐Ÿคทโ€โ™€๏ธ Status: Won't Fix] ๐Ÿ› Bug: Inconsistency in table names in database when renamed #3895
  • [๐Ÿ› Type: Bug][Status: Reproducible] ๐Ÿ› Bug: Table name inconsistent in UI when renamed #3893
  • [closed] ๐Ÿ”ฆ Feature: option to share specific view to users instead all views #3877
  • [closed] Installation Error #3863
  • [closed] ๐Ÿ› Bug: Fatal process OOM #3856
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Shared base access error #3852
  • [๐Ÿ—๏ธ Type: In Development] [ExpandedForm] Click on attach-cell doesn't open attachment drag-drop modal in expanded row drawer #3843
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Padding observed in display for few columns #3842
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Grouping field not available if Kanban created after creating Form view #3841
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Copy view #3840
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Shared view shows empty page #3839
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Disable stack context menu in locked view mode #3838
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Expand record drawer doesn't have delete option for single select #3837
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Record added to uncategorised gets placed in first labeled stack #3834
  • [๐Ÿ—๏ธ Type: In Development] [Kanban] Delete record option in kanban view #3833
  • [closed] ๐Ÿ› Bug: Api where clause not working when table col name has unicode chars #3832
  • [closed] ๐Ÿ› Bug: Unknown variable dynamic import: ../lang/zh_CN.json #3812
  • [๐Ÿ› Type: Bug] TINYINT(1) values un-settable via form view #3789
  • [๐Ÿ”Ž Status: More Info Needed] After upgrading version attachment not found #3779
  • [๐Ÿ› Type: Bug] Full width icon is not hiding left nav-drawer #3761
  • [๐Ÿ—๏ธ Type: In Development] [feat/kanban-view] Open items #3716
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Filter: Control goes away from text-box while feeding input #3707
  • [๐Ÿš€ Status: Ready for Next Release] Add docs for unit tests #3706
  • [closed] CY Stability #3684
  • [๐Ÿš€ Status: Ready for Next Release] External MS SQL Server bug on creating foreign keys #3681
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] Form view doesn't re-open on click in right nav bar #3679
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] Tab Team & auth is empty #3677
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Unable to create select column #3676
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] tabs go missing at times #3673
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] FormView validation missing #3652
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] SMTP plugin error persists on opening form everytime #3651
  • [๐Ÿ—๏ธ Type: In Development] form view- use alias if configured for error message #3650
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] Add row using expanded form lists lookup/rollup columns #3649
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ—๏ธ Type: In Development] Display error on accessing disabled shared base link #3648
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐Ÿ‘“ Scope : View] [Bug]: Icons in Gallery View Drawer are tiny #3647
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release][๐ŸŸ  Priority: High] Password Protected Form View shows blank screen #3627
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] DB_QUERY_LIMIT_DEFAULT seems to not be working anymore #3617
  • [๐Ÿคทโ€โ™€๏ธ Status: Won't Fix][๐Ÿฐ Scope : Column] Sorting won't work correctly in column type SingleLineText with number-based text #3615
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐ŸŒฎ Scope : Table] Show real table name on alt+hover #3614
  • [๐Ÿ› Type: Bug][๐Ÿš€ Status: Ready for Next Release] Checkbox not clearly visible #3613
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ญ Scope : Project] [i18n] Language support extension- #3607
  • [closed] Difference between owner and creater #3600
  • [โœจ Type: Enhancement][๐Ÿš€ Status: Ready for Next Release] Enable API tests + add more tests #3579
  • [๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ด Priority : Critical] Expanded form issues #3566
  • [๐Ÿš€ Status: Ready for Next Release][โœˆ๏ธ Type: i18n translation] Crowdin for i18n translations #3514
  • [๐Ÿ› Type: Bug] Share form view with no columns should show an error or info message #3341
  • [๐Ÿ› Type: Bug][๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿš€ Status: Ready for Next Release] vue3: shared view list modal text wrap for lengthy password #3322
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ญ Scope : Project] Vue3 : UI translations #3278
  • [closed] [Vue3]: Fix circular component imports type errors #3208
  • [๐Ÿ”ฆ Type: Feature][๐Ÿ‘“ Scope : View] [Feature] Gallery Share View button missing #3152
  • [closed] [Vue3]: Unit Tests (Vitest) #3145
  • [โœˆ๏ธ Type: i18n translation] [i18n] Message "Field is required" not translate #3041
  • [๐Ÿš€ Status: Ready for Next Release] Re-sync fails after foreign key/table removal #3033
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿฐ Scope : Column] [Feature] "Now"-button for datetime field in form view #2863
  • [๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿ”ญ Scope : Project] ERD : add an option in table to show relations #2667
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿš€ Status: Ready for Next Release][๐Ÿฐ Scope : Column] Sort by "LinkToAnotherRecord" Columns #2572
  • [๐Ÿ•Š๏ธ Type: Migration][๐Ÿ—๏ธ Status: In Resolution] PostgreSQL : migration from 0084002 to 0090000 failed #2012
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿš€ Status: Ready for Next Release][๐ŸŽ Scope : Row] Feature: unique URL for each row (when previewed in a pop-up) #273
  • [โœจ Type: Enhancement][๐Ÿ”ฆ Type: Feature][๐Ÿ‘‹ For : Community or Good First Issue][๐Ÿ‘ฎ Scope : Auth] Consider dropping the requirement for specific characters in passwords #242

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.97.0...0.98.1

Join Our Team

Thank you for your love & support

๐Ÿ’œ ๐Ÿš€