🚀 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

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

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 https://github.com/nocodb/nocodb/pull/5176
chore(action): setup node version by @pranavxc in https://github.com/nocodb/nocodb/pull/5171
Do not check mime type during attachment download by @djmaze in https://github.com/nocodb/nocodb/pull/5181
fix(nc-gui): single select issues by @wingkwong in https://github.com/nocodb/nocodb/pull/5183
fix: Nested expanded form single/multi select field issue by @pranavxc in https://github.com/nocodb/nocodb/pull/5194
fix: Grid - avoid toggling editEnabled on mouse down event by @pranavxc in https://github.com/nocodb/nocodb/pull/5187
fix: Disable button to avoid duplicate api call when creating column, project and table by @pranavxc in https://github.com/nocodb/nocodb/pull/5189
Geodata column and Map View (WIP) by @flisowna in https://github.com/nocodb/nocodb/pull/4749
docs: update column types by @wingkwong in https://github.com/nocodb/nocodb/pull/5204
add feature upload xlsx in existing table by @semmjon in https://github.com/nocodb/nocodb/pull/5164
fix: wrong baseid in QuickImport by @semmjon in https://github.com/nocodb/nocodb/pull/5159
refactor bulk operations by @semmjon in https://github.com/nocodb/nocodb/pull/5165
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5202
feat: API payload validation and error handling by @pranavxc in https://github.com/nocodb/nocodb/pull/5174
fix: Remove double click column edit option from shared form by @pranavxc in https://github.com/nocodb/nocodb/pull/5206
fix: Column create/edit - show all db options if uidt is SpecificDBType by @pranavxc in https://github.com/nocodb/nocodb/pull/5193
fix(nocodb): escape ? for raw sql query by @wingkwong in https://github.com/nocodb/nocodb/pull/5221
enhancement(nc-gui): date filters by @wingkwong in https://github.com/nocodb/nocodb/pull/5185
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5229
fix(nocodb): blank logic for LTAR columns by @wingkwong in https://github.com/nocodb/nocodb/pull/5230
fix(nc-gui): reset filter value to null instead by @wingkwong in https://github.com/nocodb/nocodb/pull/5233
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5246
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5250
Refactor api handler and introduce service layer by @pranavxc in https://github.com/nocodb/nocodb/pull/5239
refactor: ajv validation & swagger by @wingkwong in https://github.com/nocodb/nocodb/pull/5222
add feature to set custom pvc access mode, e.g. read-write-many by @semmjon in https://github.com/nocodb/nocodb/pull/5163
fix: webhook no reset when addHook by @willnewii in https://github.com/nocodb/nocodb/pull/5223
fix: No autosave when moving to "Next Row" in expanded record view by @gitstart in https://github.com/nocodb/nocodb/pull/5249
chore(deps): bump minimist and commitizen in /packages/nc-plugin by @dependabot in https://github.com/nocodb/nocodb/pull/5251
refactor(nocodb): APIs by @wingkwong in https://github.com/nocodb/nocodb/pull/5253
fix: Missing slack channel list in webhook by @pranavxc in https://github.com/nocodb/nocodb/pull/5261
refactor: ctl & svc layer by @wingkwong in https://github.com/nocodb/nocodb/pull/5262
Chore: Update eslint rules by @pranavxc in https://github.com/nocodb/nocodb/pull/5252
feat: Add shortcuts to navigate between rows in expanded form by @pranavxc in https://github.com/nocodb/nocodb/pull/5184
refactor: sort import by @wingkwong in https://github.com/nocodb/nocodb/pull/5267
fix(nocodb): add missing insert props by @wingkwong in https://github.com/nocodb/nocodb/pull/5268
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5273
UI enhancement and fixes by @pranavxc in https://github.com/nocodb/nocodb/pull/5271
refactor: formula by @wingkwong in https://github.com/nocodb/nocodb/pull/5270
Refactor: disable app store and hasmany relation based on env by @pranavxc in https://github.com/nocodb/nocodb/pull/5272
Introduce Pinia store to manage app state by @pranavxc in https://github.com/nocodb/nocodb/pull/5274
refactor(nocodb): backend by @wingkwong in https://github.com/nocodb/nocodb/pull/5269
fix(nocodb): sanitize / unsanitize logic by @wingkwong in https://github.com/nocodb/nocodb/pull/5293
test: ut on pg by @dstala in https://github.com/nocodb/nocodb/pull/5289
chore(deps): bump webpack from 5.73.0 to 5.76.1 in /packages/nc-gui by @dependabot in https://github.com/nocodb/nocodb/pull/5301
chore: readme typos by @dammy001 in https://github.com/nocodb/nocodb/pull/5294
chore(deps-dev): bump webpack from 5.65.0 to 5.76.0 in /packages/nc-cli by @dependabot in https://github.com/nocodb/nocodb/pull/5298
fix(nc-gui): move eventOperation and onNotTypeChange logic out of loadPluginList by @wingkwong in https://github.com/nocodb/nocodb/pull/5295
fix: tab control by @mertmit in https://github.com/nocodb/nocodb/pull/5172
fix(nc-gui): return attachment url even fetch fails by @wingkwong in https://github.com/nocodb/nocodb/pull/5303
refactor: use service api's in airtable import by @dstala in https://github.com/nocodb/nocodb/pull/5280
fix: row numbering based on page size configured by @dstala in https://github.com/nocodb/nocodb/pull/5305
Follow up fixes on geodata column and map view by @flisowna in https://github.com/nocodb/nocodb/pull/5248
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5310
enhancement: filters by @wingkwong in https://github.com/nocodb/nocodb/pull/5306
fix(sdk): escapeLiteral by @wingkwong in https://github.com/nocodb/nocodb/pull/5316
fix: project errors by @wingkwong in https://github.com/nocodb/nocodb/pull/5307
Mvp mobile layout and code scanner by @spaudanjo in https://github.com/nocodb/nocodb/pull/5114
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5321
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5322
enhancement: webhooks by @wingkwong in https://github.com/nocodb/nocodb/pull/5317
feat: title tag by @wingkwong in https://github.com/nocodb/nocodb/pull/5323
chore: add nuxi prepare script for generates types. by @dammy001 in https://github.com/nocodb/nocodb/pull/5296
refactor(nc-gui): use VNodeRef for focusInput & blur to call onRename by @wingkwong in https://github.com/nocodb/nocodb/pull/5327
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5331
fix: unhide language menu by @rallisf1 in https://github.com/nocodb/nocodb/pull/5329
enhancement: validations by @wingkwong in https://github.com/nocodb/nocodb/pull/5328
fix(nc-gui): keyA selection by @wingkwong in https://github.com/nocodb/nocodb/pull/5342
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5346
fix(nc-gui): extra patch request by @wingkwong in https://github.com/nocodb/nocodb/pull/5340
test: fix project operations flaky test by @dstala in https://github.com/nocodb/nocodb/pull/5350
enhancement: expanded form comments by @wingkwong in https://github.com/nocodb/nocodb/pull/5341
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5348
feat: Replace icons with thin icon by @pranavxc in https://github.com/nocodb/nocodb/pull/5343
test: corrections for new icons suite by @dstala in https://github.com/nocodb/nocodb/pull/5363
enhancement: add icon reset option by @pranavxc in https://github.com/nocodb/nocodb/pull/5357
fix: Rollup column icon missing and number column width issue by @pranavxc in https://github.com/nocodb/nocodb/pull/5382
feat: undo/redo by @mertmit in https://github.com/nocodb/nocodb/pull/5332
fix: add border for left tree view and icon alignment by @pranavxc in https://github.com/nocodb/nocodb/pull/5383
test: use dayjs by @dstala in https://github.com/nocodb/nocodb/pull/5384
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5389
Select query improvements by @pranavxc in https://github.com/nocodb/nocodb/pull/5379
fix: Expanded form next/prev icon position by @pranavxc in https://github.com/nocodb/nocodb/pull/5390
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5391
0.106.0-beta.0 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/5394
Release 0.106.0-beta.0 by @github-actions in https://github.com/nocodb/nocodb/pull/5395
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5400
refactor: webhooks by @wingkwong in https://github.com/nocodb/nocodb/pull/5349
Update link for portuguese language by @poolborges in https://github.com/nocodb/nocodb/pull/5404
fix (dbConfig): ssl connection with file path is not handled correctly by @kamalmahmudi in https://github.com/nocodb/nocodb/pull/5364
refactor: Formula query builder optimization by @pranavxc in https://github.com/nocodb/nocodb/pull/5392
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5408
fix(nocodb): Add postgres data source w/o CREATE ON DATABASE permission by @data-envoy in https://github.com/nocodb/nocodb/pull/5399
fix: Maintain multi select option order by @pranavxc in https://github.com/nocodb/nocodb/pull/5413
feat: local docker by @wingkwong in https://github.com/nocodb/nocodb/pull/5402
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5422
New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/5425
fix: formula LTAR column references by @mertmit in https://github.com/nocodb/nocodb/pull/5421
fix(nc-gui): page-size in pagination by @wingkwong in https://github.com/nocodb/nocodb/pull/5426
0.106.0-beta.1 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/5427
Release 0.106.0-beta.1 by @github-actions in https://github.com/nocodb/nocodb/pull/5428
enhancement: audits by @wingkwong in https://github.com/nocodb/nocodb/pull/5403
chore(deps): bump xml2js and @azure/ms-rest-js in /packages/nc-cli by @dependabot in https://github.com/nocodb/nocodb/pull/5442
chore(deps): bump vm2 from 3.9.13 to 3.9.15 in /packages/nocodb by @dependabot in https://github.com/nocodb/nocodb/pull/5435
0.106.0 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/5446

New Contributors

@dammy001 made their first contribution in https://github.com/nocodb/nocodb/pull/5294
@rallisf1 made their first contribution in https://github.com/nocodb/nocodb/pull/5329
@poolborges made their first contribution in https://github.com/nocodb/nocodb/pull/5404
@kamalmahmudi made their first contribution in https://github.com/nocodb/nocodb/pull/5364
@data-envoy made their first contribution in https://github.com/nocodb/nocodb/pull/5399

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

NocoDB - 0.106.0