NocoDB 0.105.0 — Release Notes & Engineering Impact

# 🚀 [NocoDB](https://nocodb.com) Feature Release : Formula Column can be Display-Value column 🚀 ## 🥬 What's new .. What's fresh ?  ### 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 <p align=""><a href="http://careers.nocodb.com" target="_blank"><img src="https://user-images.githubusercontent.com/61551451/169663818-45643495-e95b-48e2-be13-01d6a77dc2fd.png" width="250"/></a></p> 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](https://github.com/nocodb/nocodb/issues/5098) - [**closed**] 🔦 Feature: Github Actions Cache Removal after PR merge [#5082](https://github.com/nocodb/nocodb/issues/5082) - [**closed**] 🐛 Bug: `Duplicate Column` : cells get highlighted in RED [#5070](https://github.com/nocodb/nocodb/issues/5070) - [**closed**] 🔦 Feature: Enable edit menu for lookup & rollup columns [#5064](https://github.com/nocodb/nocodb/issues/5064) - [**closed**] 🐛 Bug: incorrect values in grid view [#5059](https://github.com/nocodb/nocodb/issues/5059) - [**closed**] 🐛 Bug: filter table display the wrong results until reload whole webpage [#5053](https://github.com/nocodb/nocodb/issues/5053) - [**🐛 Type: Bug**] 🐛 Bug: Lookup to attachment column is not correctly rendered. [#5052](https://github.com/nocodb/nocodb/issues/5052) - [**🐛 Type: Bug**] 🐛 Bug: Some features not working on hosted without internet connection [#5036](https://github.com/nocodb/nocodb/issues/5036) - [**closed**] 🐛 Bug: Failed Upgrade 0.100.2 to 0.104.1 [#5032](https://github.com/nocodb/nocodb/issues/5032) - [**closed**] 🐛 Bug: Avoid sync calls within backend [#5026](https://github.com/nocodb/nocodb/issues/5026) - [**closed**] 🐛 Bug: old data remains in spreadsheet [#5020](https://github.com/nocodb/nocodb/issues/5020) - [**🐛 Type: Bug**] 🐛 Bug: Can't import .csv or json from main import window : "Cannot read properties of undefined (reading 'is_meta')" [#5019](https://github.com/nocodb/nocodb/issues/5019) - [**closed**] Make the primary column sticky : Video [#5007](https://github.com/nocodb/nocodb/issues/5007) - [**Status: Reproducible**] 🐛 Bug: Unable to add multiple new empty records using consecutive `ALT + R` [#5006](https://github.com/nocodb/nocodb/issues/5006) - [**Status: Reproducible**] 🐛 Bug: blank cell is filled with data from the same cell from a previous page [#5005](https://github.com/nocodb/nocodb/issues/5005) - [**🐛 Type: Bug**] 🐛 Bug: Illegal arguments (string, object) on sign in [#4997](https://github.com/nocodb/nocodb/issues/4997) - [**closed**] 🐛 Bug: Performance degradation when upgrading to 0.104.2 [#4992](https://github.com/nocodb/nocodb/issues/4992) - [**closed**] 🐛 Bug: Make share a button instead of icon [#4986](https://github.com/nocodb/nocodb/issues/4986) - [**closed**] 🐛 Bug: Rollup on self-links (LTAR within table) displays incorrect results [#4980](https://github.com/nocodb/nocodb/issues/4980) - [**closed**] 🐛 Bug: save row on linking a record [#4978](https://github.com/nocodb/nocodb/issues/4978) - [**🔎 Status: More Info Needed**] Upload attachment and set it in a new row [#4935](https://github.com/nocodb/nocodb/issues/4935) - [**🔎 Status: More Info Needed**] 🐛 Bug: Can't delete columns [#4858](https://github.com/nocodb/nocodb/issues/4858) - [**🔎 Status: More Info Needed**] Bug : MSSQL - Field Date is Defaulting to Varchar instead of Date [#4826](https://github.com/nocodb/nocodb/issues/4826) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Can´t update higher than 0.100.2 [#4819](https://github.com/nocodb/nocodb/issues/4819) - [**closed**] 🐛 Bug: Error 403 when the editor uploads the image [#4805](https://github.com/nocodb/nocodb/issues/4805) - [**closed**] 🐛 Bug: Can't sync metadata after deleting a column or row [#4790](https://github.com/nocodb/nocodb/issues/4790) - [**🔎 Status: More Info Needed**] 🐛 Bug: Multiple incomplete records added while adding new row [#4789](https://github.com/nocodb/nocodb/issues/4789) - [**closed**] 🐛 Bug: API for nested fields other than primary field [#4757](https://github.com/nocodb/nocodb/issues/4757) - [**🔎 Status: More Info Needed**] 🐛 Bug: Export table to CSV not working in 0.100.2 [#4659](https://github.com/nocodb/nocodb/issues/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](https://github.com/nocodb/nocodb/issues/4651) - [**🐛 Type: Bug**] 🐛 Bug: Foreign Key name too long [#4615](https://github.com/nocodb/nocodb/issues/4615) - [**✨ Type: Enhancement**] Enhancements: Keyboard & UX follow up's [#4573](https://github.com/nocodb/nocodb/issues/4573) - [**🔎 Status: More Info Needed**] 🐛 Bug: drop table `table-name` - SQLITE_ERROR: no such table: table-name [#4535](https://github.com/nocodb/nocodb/issues/4535) - [**👩‍🔬 Status: In-Analysis**] 🐛 Bug: nc-help module does not have a main [#4323](https://github.com/nocodb/nocodb/issues/4323) - [**🐛 Type: Bug**] 🐛 Bug: Refresh token leads to logging out [#3792](https://github.com/nocodb/nocodb/issues/3792) - [**🐛 Type: Bug**] 🐛 Bug: Project info not copied to clipboard - where to find needed info? [#3598](https://github.com/nocodb/nocodb/issues/3598) - [**🔦 Type: Feature**][**👓 Scope : View**] Make the primary column sticky [#3583](https://github.com/nocodb/nocodb/issues/3583) - [**🔦 Type: Feature**][**🟣 Priority: Low**][**👓 Scope : View**] [Feature] Delete record option in Gallery view [#2101](https://github.com/nocodb/nocodb/issues/2101) - [**🔎 Status: More Info Needed**][**🥅 DB : MSSQL**] Users not displayed [#1351](https://github.com/nocodb/nocodb/issues/1351) - [**🔦 Type: Feature**][**🏎 Scope : Row**] Feature : Duplicate/clone row [#435](https://github.com/nocodb/nocodb/issues/435)