🚀 NocoDB 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

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