Back to Catalog
NocoDB logo

NocoDB

No-code platform that creates and manages databases with spreadsheet UI.

app no-code

Alternative to: Airtable, Google Sheets, Microsoft Lists, Coda, Smartsheet, Microsoft PowerApps, Monday.com

Website Repository Docs
NocoDB screenshot
About Versions (100)
Back to Versions

v0.106.0

2023-04-11

🚀 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

ScopeActions
RowCreate, Update, Delete
LTARLink, Unlink
FieldsShow/hide, Reorder
SortAdd, Update, Delete
FiltersAdd, Update, Delete (Excluding Filter Groups)
Row HeightUpdate
Column widthUpdate
ViewRename
TableRename

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

Changelog on GitHub →