NocoDB - 0.106.0

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


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


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)


  • 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





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

  • Release 0.105.3 by @github-actions in
  • chore(action): setup node version by @pranavxc in
  • Do not check mime type during attachment download by @djmaze in
  • fix(nc-gui): single select issues by @wingkwong in
  • fix: Nested expanded form single/multi select field issue by @pranavxc in
  • fix: Grid - avoid toggling editEnabled on mouse down event by @pranavxc in
  • fix: Disable button to avoid duplicate api call when creating column, project and table by @pranavxc in
  • Geodata column and Map View (WIP) by @flisowna in
  • docs: update column types by @wingkwong in
  • add feature upload xlsx in existing table by @semmjon in
  • fix: wrong baseid in QuickImport by @semmjon in
  • refactor bulk operations by @semmjon in
  • New Crowdin updates by @o1lab in
  • feat: API payload validation and error handling by @pranavxc in
  • fix: Remove double click column edit option from shared form by @pranavxc in
  • fix: Column create/edit - show all db options if uidt is SpecificDBType by @pranavxc in
  • fix(nocodb): escape ? for raw sql query by @wingkwong in
  • enhancement(nc-gui): date filters by @wingkwong in
  • New Crowdin updates by @o1lab in
  • fix(nocodb): blank logic for LTAR columns by @wingkwong in
  • fix(nc-gui): reset filter value to null instead by @wingkwong in
  • New Crowdin updates by @o1lab in
  • New Crowdin updates by @o1lab in
  • Refactor api handler and introduce service layer by @pranavxc in
  • refactor: ajv validation & swagger by @wingkwong in
  • add feature to set custom pvc access mode, e.g. read-write-many by @semmjon in
  • fix: webhook no reset when addHook by @willnewii in
  • fix: No autosave when moving to "Next Row" in expanded record view by @gitstart in
  • chore(deps): bump minimist and commitizen in /packages/nc-plugin by @dependabot in
  • refactor(nocodb): APIs by @wingkwong in
  • fix: Missing slack channel list in webhook by @pranavxc in
  • refactor: ctl & svc layer by @wingkwong in
  • Chore: Update eslint rules by @pranavxc in
  • feat: Add shortcuts to navigate between rows in expanded form by @pranavxc in
  • refactor: sort import by @wingkwong in
  • fix(nocodb): add missing insert props by @wingkwong in
  • New Crowdin updates by @o1lab in
  • UI enhancement and fixes by @pranavxc in
  • refactor: formula by @wingkwong in
  • Refactor: disable app store and hasmany relation based on env by @pranavxc in
  • Introduce Pinia store to manage app state by @pranavxc in
  • refactor(nocodb): backend by @wingkwong in
  • fix(nocodb): sanitize / unsanitize logic by @wingkwong in
  • test: ut on pg by @dstala in
  • chore(deps): bump webpack from 5.73.0 to 5.76.1 in /packages/nc-gui by @dependabot in
  • chore: readme typos by @dammy001 in
  • chore(deps-dev): bump webpack from 5.65.0 to 5.76.0 in /packages/nc-cli by @dependabot in
  • fix(nc-gui): move eventOperation and onNotTypeChange logic out of loadPluginList by @wingkwong in
  • fix: tab control by @mertmit in
  • fix(nc-gui): return attachment url even fetch fails by @wingkwong in
  • refactor: use service api's in airtable import by @dstala in
  • fix: row numbering based on page size configured by @dstala in
  • Follow up fixes on geodata column and map view by @flisowna in
  • New Crowdin updates by @o1lab in
  • enhancement: filters by @wingkwong in
  • fix(sdk): escapeLiteral by @wingkwong in
  • fix: project errors by @wingkwong in
  • Mvp mobile layout and code scanner by @spaudanjo in
  • New Crowdin updates by @o1lab in
  • New Crowdin updates by @o1lab in
  • enhancement: webhooks by @wingkwong in
  • feat: title tag by @wingkwong in
  • chore: add nuxi prepare script for generates types. by @dammy001 in
  • refactor(nc-gui): use VNodeRef for focusInput & blur to call onRename by @wingkwong in
  • New Crowdin updates by @o1lab in
  • fix: unhide language menu by @rallisf1 in
  • enhancement: validations by @wingkwong in
  • fix(nc-gui): keyA selection by @wingkwong in
  • New Crowdin updates by @o1lab in
  • fix(nc-gui): extra patch request by @wingkwong in
  • test: fix project operations flaky test by @dstala in
  • enhancement: expanded form comments by @wingkwong in
  • New Crowdin updates by @o1lab in
  • feat: Replace icons with thin icon by @pranavxc in
  • test: corrections for new icons suite by @dstala in
  • enhancement: add icon reset option by @pranavxc in
  • fix: Rollup column icon missing and number column width issue by @pranavxc in
  • feat: undo/redo by @mertmit in
  • fix: add border for left tree view and icon alignment by @pranavxc in
  • test: use dayjs by @dstala in
  • New Crowdin updates by @o1lab in
  • Select query improvements by @pranavxc in
  • fix: Expanded form next/prev icon position by @pranavxc in
  • New Crowdin updates by @o1lab in
  • 0.106.0-beta.0 Pre-release by @github-actions in
  • Release 0.106.0-beta.0 by @github-actions in
  • New Crowdin updates by @o1lab in
  • refactor: webhooks by @wingkwong in
  • Update link for portuguese language by @poolborges in
  • fix (dbConfig): ssl connection with file path is not handled correctly by @kamalmahmudi in
  • refactor: Formula query builder optimization by @pranavxc in
  • New Crowdin updates by @o1lab in
  • fix(nocodb): Add postgres data source w/o CREATE ON DATABASE permission by @data-envoy in
  • fix: Maintain multi select option order by @pranavxc in
  • feat: local docker by @wingkwong in
  • New Crowdin updates by @o1lab in
  • New Crowdin updates by @o1lab in
  • fix: formula LTAR column references by @mertmit in
  • fix(nc-gui): page-size in pagination by @wingkwong in
  • 0.106.0-beta.1 Pre-release by @github-actions in
  • Release 0.106.0-beta.1 by @github-actions in
  • enhancement: audits by @wingkwong in
  • chore(deps): bump xml2js and @azure/ms-rest-js in /packages/nc-cli by @dependabot in
  • chore(deps): bump vm2 from 3.9.13 to 3.9.15 in /packages/nocodb by @dependabot in
  • 0.106.0 Pre-release by @github-actions in

New Contributors

  • @dammy001 made their first contribution in
  • @rallisf1 made their first contribution in
  • @poolborges made their first contribution in
  • @kamalmahmudi made their first contribution in
  • @data-envoy made their first contribution in

Full Changelog:


April 11, 2023, 9:30 a.m.
Register or login to:
  • ๐Ÿ”View and search all NocoDB releases.
  • ๐Ÿ› ๏ธCreate and share lists to track your tools.
  • ๐ŸšจSetup notifications for major, security, feature or patch updates.
  • ๐Ÿš€Much more coming soon!
Continue with GitHub
Continue with Google