👋👋 Hey Everybody, Hey Everybody! 👋👋

We are excited to present our latest release, packed with highly anticipated features. Let's explore the new additions.

🥬 What's new .. What's fresh ?

🌟 User fields

• Streamlined Collaboration: Effortlessly assign and track users within your workspace. Enhance team collaboration by associating specific records with the individuals responsible, creating a seamless flow.
• Efficient Task Assignment: Assign one or more members of your team to a specific record, thus providing a clear and organised way to distribute responsibilities among team members.
• Enhanced Data Insights: Leverage the User Field to gain deeper insights into your data - filter, sort or group records over user field. Whether you're tracking project contributions, managing client relationships, or monitoring team activities, these additional provisions provides a comprehensive view of user involvement across your workspace.

🌟 RichText fields

Now, you can go beyond simple text entries and add a touch of style and structure to your data.

• Text Formatting : Bold, Italics, Underline, Strikethrough
• Lists for Organisation : Numbered, Unordered, Tasks
• Headings: Structure your content with three levels of headings for a clear hierarchy. - Markdown Syntax Support: Leverage the power of Markdown syntax alongside our rich text editor. Use familiar shortcuts for quick and efficient text formatting.

Other major changes

Formula

• More formula functions supported
• Use of rollup within formula is now supported
• Use of formula results to build another formula is now enhanced

Webhook update trigger (conditional)

• The update trigger with conditions activates upon a record meeting the specified condition for a webhook configuration. The trigger does not activate based on records that already meet the conditions; instead, it requires a change in the state of the records to trigger the associated automation.

On behalf of the entire Team at NocoDB, we extend our warmest wishes to you for a joyous and festive Christmas season.

We appreciate the collaboration and support we've received from you throughout the year, and we are excited about the possibilities that lie ahead. Your continued support has been instrumental in our success, and we are truly grateful for the trust you have placed in NocoDB.

We are also thrilled to introduce the newest member of our NocoDB family - our official mascot, the Snow Leopard!

Now, we're turning to you, our incredible community, to help us give our Snow Leopard a name that captures its essence. We invite you to share your creativity and suggest a fitting name for our mascot.

-- Happy Holidays from Team NocoDB

Closed Issues

• [closed] 🐛 Bug: SQLite DB, formula NOW() returns only date #7303
• [🐛 Type: Bug] 🐛 Bug: Cannot destructure property 'options' of 'object null' as it is null #7284
• [Status: Reproducible] 🐛 Bug: Cannot use nocodb after signing up for a free account #7282
• [closed] 🐛 Bug: Cannot access delete workspace button on small screens | NocoDB Cloud #7275
• [Status: Reproducible] 🐛 Bug: V2 API returns wrong status code and message combination on 401 and 403 #7272
• [closed] 🐛 Bug: Minor UI fixes #7271
• [closed] 🔦 Feature: Browse documentation easily #7267
• [closed] 🔦 Feature: Search feature for publicly shared view #7265
• [closed] 🐛 Bug: V2 API - Impossible to unlink records - always "invalid input syntax for type integer" error #7262
• [closed] 🐛 Bug: Rich text cell, first character during transition from select mode to edit mode is lost #7261
• [closed] Upgrading without NC_AUTH_JWT_SECRET set #7258
• [closed] 🐛 Bug: Webhook triggered by complicated formula multiple times before value was committed #7256
• [closed] 🐛 Bug: Checkbox, Barcode cells are not aligning properly when the row height changes. #7253
• [🦭 DB : MariaDB] 🐛 Bug: Duplicate table/base fails for MariaDB #7231
• [closed] 🐛 Bug: Subsequent Longtext fields are distorted in Gallery or Kanban view #7227
• [closed] 🐛 Bug: excel import error #7211
• [closed] 🐛 Bug: UI/UX fixes - 2 #7210
• [closed] 🐛 Bug: column datatype not changing from SingleLineText to Number #7188
• [🔎 Status: More Info Needed] 🔦 Feature: Filter Days now uniformly utilizes 'datetime' for all calculations. #7176
• [closed] 🐛 Bug: [UI] hover effect in dropdown's #7135
• [closed] 🐛 Bug: formula related #7126
• [closed] 🐛 Bug: Upgrading from 0.105.1 to latest fails #7075
• [closed] 🐛 Bug: Documentation for RichText #7073
• [closed] 🔦 Feature: SEARCH function should support searching from the end #6448
• [closed] 🐛 Bug: insufficient and incorrect documentation for /auth/token/refresh endpoint #6078
• [closed] 🔦 Feature: Formula MONTH() to extract month from a date #5297
• [🔦 Type: Feature] 🔦 Feature: Modify Field after Webhook "After Update" #4130
• [🔦 Type: Feature][🍰 Scope : Column] [Feature] Add DATE() function for formulas #2605
• [🔦 Type: Feature][🍰 Scope : Column] [Feature] Collaborator field (Link to User) #2382
• [🔦 Type: Feature][🍰 Scope : Column] 🔦 Feature: Add quarter formula function #918

What's Changed

• Release 0.202.10 by @github-actions in https://github.com/nocodb/nocodb/pull/7223
• fix : fixed table cell overflow in uploadExcel Model by @musharaf-nocodb in https://github.com/nocodb/nocodb/pull/7221
• fix : insufficient and incorrect documentation for /auth/token/refresh endpoint by @aashishagrawall in https://github.com/nocodb/nocodb/pull/7095
• fix: Mysql - If buffer type convert to hex value and convert to int only if type is bit by @pranavxc in https://github.com/nocodb/nocodb/pull/7224
• fix: Miscellaneous ui errors by @pranavxc in https://github.com/nocodb/nocodb/pull/7230
• fix: support function calls for default timestamp by @mertmit in https://github.com/nocodb/nocodb/pull/7232
• fix: append before getList by @mertmit in https://github.com/nocodb/nocodb/pull/7234
• chore(renovate): Update patch (patch) by @renovate in https://github.com/nocodb/nocodb/pull/7216
• fix: poll plugin by @mertmit in https://github.com/nocodb/nocodb/pull/7248
• fix: selector and css by @mertmit in https://github.com/nocodb/nocodb/pull/7250
• New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/7251
• fix: clear fill handle properly on expanded form close by @mertmit in https://github.com/nocodb/nocodb/pull/7260
• Nc feat/webhook conditions by @dstala in https://github.com/nocodb/nocodb/pull/7246
• fix: rich text first char issue by @dstala in https://github.com/nocodb/nocodb/pull/7266
• UI/UX fixes - 2 by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/7218
• Updates to Uffizzi Deployment Workflow. by @axisofentropy in https://github.com/nocodb/nocodb/pull/7269
• Formula type extraction and improvements by @pranavxc in https://github.com/nocodb/nocodb/pull/7268
• fix: Has-many unlink api - accept array of object with primary key by @pranavxc in https://github.com/nocodb/nocodb/pull/7274
• feat: user field by @mertmit in https://github.com/nocodb/nocodb/pull/7202
• pw formula tests, check formula not supported error by @starbirdtech383 in https://github.com/nocodb/nocodb/pull/7273
• fix: Formula followup bugs by @pranavxc in https://github.com/nocodb/nocodb/pull/7279
• Nc fix/tab focus by @dstala in https://github.com/nocodb/nocodb/pull/7280
• fix: Increased min height and added scroll for long text in expanded … by @dstala in https://github.com/nocodb/nocodb/pull/7243
• Nc fix/formula revamp by @dstala in https://github.com/nocodb/nocodb/pull/7281
• fix: Update dtxs when decimal precision is changing by @pranavxc in https://github.com/nocodb/nocodb/pull/7278
• fix(nocodb): 403 forbidden message by @wingkwong in https://github.com/nocodb/nocodb/pull/7285
• Nc fix/UI ux fixes by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/7286
• Nc fix/formula fixes by @dstala in https://github.com/nocodb/nocodb/pull/7288
• minor bug fixes by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/7270
• Docs/0.203.0 by @dstala in https://github.com/nocodb/nocodb/pull/7294
• fix: Handle scenarios where no select options are there by @pranavxc in https://github.com/nocodb/nocodb/pull/7287
• feature / search added in shared view by @aashishagrawall in https://github.com/nocodb/nocodb/pull/7293
• Nc fix/formula bugs by @dstala in https://github.com/nocodb/nocodb/pull/7299
• feat(noco-docs): breadcrumb indexing by @wingkwong in https://github.com/nocodb/nocodb/pull/7300
• update tests for invalid function error by @starbirdtech383 in https://github.com/nocodb/nocodb/pull/7302
• chore(renovate): Update patch (patch) by @renovate in https://github.com/nocodb/nocodb/pull/7249
• docs: webhook updates by @dstala in https://github.com/nocodb/nocodb/pull/7307
• fix: SQLIte Formula - include time value in NOW function by @pranavxc in https://github.com/nocodb/nocodb/pull/7306
• 0.203.0 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/7308

New Contributors

• @axisofentropy made their first contribution in https://github.com/nocodb/nocodb/pull/7269

Full Changelog: https://github.com/nocodb/nocodb/compare/0.202.10...0.203.0