NocoDB: 0.104.1: Feature Release

# 🚀 [NocoDB](https://nocodb.com) Feature Release : ERD Fullscreen, Fixed Row height, Multi-file download 🚀 ## 🥬 What's new .. What's fresh ?  ### ERD Fullscreen : * Visualising ERD views for table and schema was a feature that our users have been really loving. And now they can go fullscreen and have a bird eyes view of tables and the relationship. ### Fixed Row Height * Irrespective of the columns and their content - we help you visualise the rows in fixed heights. Why should it be any different in a spreadsheet ? :) ### Multi-file download * You can now download all files related to a cell with one click. ### Row browsing * With in-place next-and-previous button in expanded row view - you can easily go to next and previous rows with one-click without having to close and reopen the expanded form. ## 🕐 Now, its demo time [](https://youtu.be/3ZY2G71Yzps) ## 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 - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Division in formula display 'Invalid Formula' [#4929](https://github.com/nocodb/nocodb/issues/4929) - [**🚀 Status: Ready for Next Release**][**Status: Reproducible**] 🐛 Bug: AND() and OR() formulas broken nesting and output in ver 0.102.2 [#4920](https://github.com/nocodb/nocodb/issues/4920) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Not able to use arrow keys and space key in filter value field [#4916](https://github.com/nocodb/nocodb/issues/4916) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Checkbox sort in PG locates NULL & false differently [#4881](https://github.com/nocodb/nocodb/issues/4881) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Local attachments become 404 after setting up a storage plugin [#4880](https://github.com/nocodb/nocodb/issues/4880) - [**closed**] 🐛 Bug: Immediate Authorization Failure Using Postgres Docker Compose [#4878](https://github.com/nocodb/nocodb/issues/4878) - [**🚀 Status: Ready for Next Release**] 🔦 Feature: Remove or set optional toLowerCase() on Single/Multi Section Type [#4874](https://github.com/nocodb/nocodb/issues/4874) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Decimal Auto Type Section on Excel Import [#4873](https://github.com/nocodb/nocodb/issues/4873) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Unable to remove data-source if a lookup column was created [#4871](https://github.com/nocodb/nocodb/issues/4871) - [**closed**] 🐛 Bug: Unable to set myself as superadmin to access plugin list [#4867](https://github.com/nocodb/nocodb/issues/4867) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: role `creator` can delete projects created by `owner` (or other users) [#4863](https://github.com/nocodb/nocodb/issues/4863) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Skip displaying AppStore under project-menu [#4852](https://github.com/nocodb/nocodb/issues/4852) - [**closed**] 🐛 Bug: App Store not working: "pluginList - org-level-creator : Not allowed" [#4845](https://github.com/nocodb/nocodb/issues/4845) - [**closed**] Nocodedb [#4839](https://github.com/nocodb/nocodb/issues/4839) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Executable release action publishes directly in github action [#4837](https://github.com/nocodb/nocodb/issues/4837) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Shared form issue [#4830](https://github.com/nocodb/nocodb/issues/4830) - [**closed**] 🐛 Bug: socket.io does not use subfolder URL [#4818](https://github.com/nocodb/nocodb/issues/4818) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: DATETIME_DIFF Function's result incorrect in SQLite [#4816](https://github.com/nocodb/nocodb/issues/4816) - [**closed**] 🐛 Bug: Deleting user from main admin panel needs text change. [#4815](https://github.com/nocodb/nocodb/issues/4815) - [**🐛 Type: Bug**][**🔎 Status: More Info Needed**] 🐛 Bug: Kanban goes blank permanently after editing row [#4691](https://github.com/nocodb/nocodb/issues/4691) - [**closed**] 🐛 Bug: Updating user permissions [#4684](https://github.com/nocodb/nocodb/issues/4684) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: "Share View" of Kanban is showing up blank [#4670](https://github.com/nocodb/nocodb/issues/4670) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Publicly shared Gallery Views don't show the cover image [#4664](https://github.com/nocodb/nocodb/issues/4664) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Modals/Popup about Table dependencies has some flaws [#4662](https://github.com/nocodb/nocodb/issues/4662) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**][**🦭 DB : MariaDB**] 🐛 Bug: Default value automatically sets as NULL for SingleSelect [#4625](https://github.com/nocodb/nocodb/issues/4625) - [**closed**] 🐛 Bug: Kanban View- Grouping Field not automatically coming to kanban view. Also no way to do it manually [#4624](https://github.com/nocodb/nocodb/issues/4624) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**] 🔦 Feature: make ERD diagram full screen and exportable [#4616](https://github.com/nocodb/nocodb/issues/4616) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Use of space-bar in Shared grid view throws error [#4580](https://github.com/nocodb/nocodb/issues/4580) - [**closed**] Documentation: explain funding/pricing/sustainability model [#4522](https://github.com/nocodb/nocodb/issues/4522) - [**🔎 Status: More Info Needed**][**🔦 Type: Feature**] 🔦 Feature: Change Kanban Stack Order [#4487](https://github.com/nocodb/nocodb/issues/4487) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Filtering on single select empty cells are ignored [#4462](https://github.com/nocodb/nocodb/issues/4462) - [**👋 For : Community or Good First Issue**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Latest logo favicon used in API Docs [#4396](https://github.com/nocodb/nocodb/issues/4396) - [**👋 For : Community or Good First Issue**] 🐛 Bug: Docker terminal not accessible [#4372](https://github.com/nocodb/nocodb/issues/4372) - [**🔦 Type: Feature**] 🔦 Feature: View based Api key forever [#4368](https://github.com/nocodb/nocodb/issues/4368) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Shared form: Border missing for LTAR column type [#4293](https://github.com/nocodb/nocodb/issues/4293) - [**closed**] 🔦 Feature: link to another record custom column [#4282](https://github.com/nocodb/nocodb/issues/4282) - [**closed**] Playwright improvments [#4277](https://github.com/nocodb/nocodb/issues/4277) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**] 🔦 Feature: Easily browse from one record to the next (previous record, next record) [#4255](https://github.com/nocodb/nocodb/issues/4255) - [**🚀 Status: Ready for Next Release**][**🏗️ Type: In Development**] 🐛 Bug: Attachment URLs are stored with base_url prefixed [#4185](https://github.com/nocodb/nocodb/issues/4185) - [**🏗️ Type: In Development**] [PR# 3847] Error observed with migrated DB during project table navigation [#4002](https://github.com/nocodb/nocodb/issues/4002) - [**closed**] Environments for each PR made [#3990](https://github.com/nocodb/nocodb/issues/3990) - [**closed**] 🐛 Bug: Shared Views do not honour project theme [#3974](https://github.com/nocodb/nocodb/issues/3974) - [**Scope : Test [E2E]**] [Cypress][CI-CD] Grid view not rendered [#3903](https://github.com/nocodb/nocodb/issues/3903) - [**Scope : Test [E2E]**] [Cypress] Add tests for Single-select & Multi-select data type [#3858](https://github.com/nocodb/nocodb/issues/3858) - [**closed**] [Feature] Count items on a many-to-many column [#3800](https://github.com/nocodb/nocodb/issues/3800) - [**closed**] DevOps issues [#3527](https://github.com/nocodb/nocodb/issues/3527) - [**closed**] nocodb org readme [#3415](https://github.com/nocodb/nocodb/issues/3415) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: vue3 : While creating lookup - show LinkToAnotherRecord instead of ChildTable [#3403](https://github.com/nocodb/nocodb/issues/3403) - [**✨ Type: Enhancement**][**🔦 Type: Feature**][**👓 Scope : View**] vue3 : Use right side drawer for SharedView list and add new row [#3332](https://github.com/nocodb/nocodb/issues/3332) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**][**🔭 Scope : Project**] [Feature] Include google fonts / Prevent fonts to be loaded from google [#3059](https://github.com/nocodb/nocodb/issues/3059) - [**🔦 Type: Feature**][**👮 Scope : Auth**] Feature request - Change admin email & manually approve users [#2973](https://github.com/nocodb/nocodb/issues/2973) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**][**🍰 Scope : Column**] [Feature] Limit attachments [#2905](https://github.com/nocodb/nocodb/issues/2905) - [**👋 For : Community or Good First Issue**] Old table structure after upgrading from 0.84.16 to 0.92.3 [#2601](https://github.com/nocodb/nocodb/issues/2601) - [**🐛 Type: Bug**][**🔎 Status: More Info Needed**] 🐛 Bug: Form fields are loaded incompletely when the view is being shared [#2514](https://github.com/nocodb/nocodb/issues/2514) - [**👋 For : Community or Good First Issue**] Sort option not displaying columns properly or fully [#2481](https://github.com/nocodb/nocodb/issues/2481) - [**🔎 Status: More Info Needed**] Field Check Boxes Unresponsive on Android [#2480](https://github.com/nocodb/nocodb/issues/2480) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**][**🍰 Scope : Column**] [Feature] Visual distinction between NULL and empty string [#2409](https://github.com/nocodb/nocodb/issues/2409) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**][**🍰 Scope : Column**] [Feature] Cell Display Options [#2287](https://github.com/nocodb/nocodb/issues/2287) - [**🕊️ Type: Migration**] Migration from 0084002 to 0090000 failed [#2155](https://github.com/nocodb/nocodb/issues/2155) - [**🏗️ Type: In Development**] 🐛 Bug: [web-hook] error in data payload [#2103](https://github.com/nocodb/nocodb/issues/2103) - [**🐛 Type: Bug**] Can´t create form view [#2031](https://github.com/nocodb/nocodb/issues/2031) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Filtering by checkbox columns is inconsistent [#2014](https://github.com/nocodb/nocodb/issues/2014) - [**🔎 Status: More Info Needed**] Can´t create gallery view or form view [#1971](https://github.com/nocodb/nocodb/issues/1971) - [**🔦 Type: Feature**] Paid upgrades/modules [#1887](https://github.com/nocodb/nocodb/issues/1887) - [**closed**] Delete table button shouldn't be adjacent to add row [#1826](https://github.com/nocodb/nocodb/issues/1826) - [**🟣 Priority: Low**][**🏗️ Type: In Development**] m2m table listed in meta-sync tab [#1708](https://github.com/nocodb/nocodb/issues/1708) - [**🔦 Type: Feature**][**🍰 Scope : Column**] [Feature] Add comments to cell / record [#1538](https://github.com/nocodb/nocodb/issues/1538) - [**🔎 Status: More Info Needed**] Tables are not created on Postgres [#1323](https://github.com/nocodb/nocodb/issues/1323) - [**🔦 Type: Feature**][**🍰 Scope : Column**] [Feature] Multiselect manual ordering [#1141](https://github.com/nocodb/nocodb/issues/1141) - [**🔦 Type: Feature**][**☎ Scope : API**] [Feature] Limit API Token Permissions [#941](https://github.com/nocodb/nocodb/issues/941) - [**🔦 Type: Feature**][**👓 Scope : View**] [Feature] Gantt view [#854](https://github.com/nocodb/nocodb/issues/854) - [**🔦 Type: Feature**][**🔭 Scope : Project**] Embed NocoDB in browser for offline usage [#849](https://github.com/nocodb/nocodb/issues/849) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**][**👓 Scope : View**] Feature : Set fixed row height [#831](https://github.com/nocodb/nocodb/issues/831) - [**✨ Type: Enhancement**][**🔦 Type: Feature**][**👋 For : Community or Good First Issue**][**🎃 For : Hacktoberfest**][**🚀 Status: Ready for Next Release**][**🍰 Scope : Column**] 🐛 Bug: Filtering MultiSelect in more than basic way [#534](https://github.com/nocodb/nocodb/issues/534) - [**✨ Type: Enhancement**][**🔦 Type: Feature**][**🍰 Scope : Column**] Lookup column has a different display format than origin [#416](https://github.com/nocodb/nocodb/issues/416) - [**✨ Type: Enhancement**][**🔦 Type: Feature**][**👋 For : Community or Good First Issue**][**🚀 Status: Ready for Next Release**][**🍰 Scope : Column**] Feature: Select multiple files and download attachments. [#335](https://github.com/nocodb/nocodb/issues/335) ## What's Changed * fix(workflow): add draft mode by @wingkwong in https://github.com/nocodb/nocodb/pull/4838 * docs(readme): fix korean expressions by @proke03 in https://github.com/nocodb/nocodb/pull/4842 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4843 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4846 * fix(favicon): update favicon used in API Docs by @gitstart in https://github.com/nocodb/nocodb/pull/4849 * fix iframe issue with multiple embedded views by @flisowna in https://github.com/nocodb/nocodb/pull/4853 * fix(nc-gui): get public gallery data from sharedView.view by @wingkwong in https://github.com/nocodb/nocodb/pull/4855 * Undo select option removal by @ketewan in https://github.com/nocodb/nocodb/pull/4781 * fix: kanban share view issues by @wingkwong in https://github.com/nocodb/nocodb/pull/4848 * chore(action): extract current version from package.json by @pranavxc in https://github.com/nocodb/nocodb/pull/4872 * fix: hide system relation column from LTAR popup by @mertmit in https://github.com/nocodb/nocodb/pull/4866 * fix: injection warnings on shared view by @mertmit in https://github.com/nocodb/nocodb/pull/4876 * feat: add filter types for multiselect field by @southball in https://github.com/nocodb/nocodb/pull/4379 * fix: Miscellaneous bugs by @pranavxc in https://github.com/nocodb/nocodb/pull/4861 * refactor: tests better org & clean-up by @dstala in https://github.com/nocodb/nocodb/pull/4882 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4887 * feat: Remove or set optional toLowerCase() on Single/Multi Section Type by @gitstart in https://github.com/nocodb/nocodb/pull/4891 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4893 * fix(wording): Implement inclusive writing in French by @ZoeThivet in https://github.com/nocodb/nocodb/pull/4897 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4905 * fix: Set sort order of nulls in postgres by @pranavxc in https://github.com/nocodb/nocodb/pull/4885 * fix: MariaDB default value by @mertmit in https://github.com/nocodb/nocodb/pull/4900 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4910 * test: filter & sort for multiselect by @dstala in https://github.com/nocodb/nocodb/pull/4886 * fix: filtering options for select columns by @mertmit in https://github.com/nocodb/nocodb/pull/4901 * fix: remove relations in a logical order from meta on base delete by @mertmit in https://github.com/nocodb/nocodb/pull/4918 * Fix: Grid view - keydown event handler issues by @pranavxc in https://github.com/nocodb/nocodb/pull/4917 * fix: SQL server column alter and create bugs by @pranavxc in https://github.com/nocodb/nocodb/pull/4883 * Fix: Filter - include null values in not like filter result by @pranavxc in https://github.com/nocodb/nocodb/pull/4922 * test: enterprise key verification by @dstala in https://github.com/nocodb/nocodb/pull/4923 * feat(nc-gui): Added fullscreen support to ERD by @mustafapc19 in https://github.com/nocodb/nocodb/pull/4911 * fix: isPg, isMysql calls by @mertmit in https://github.com/nocodb/nocodb/pull/4870 * feat: row height for grid view by @mertmit in https://github.com/nocodb/nocodb/pull/4840 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4926 * fix(nocodb): argument of OR/AND must be type boolean, not type integer by @wingkwong in https://github.com/nocodb/nocodb/pull/4928 * feat: visual distinction between NULL and empty string by @mertmit in https://github.com/nocodb/nocodb/pull/4908 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4936 * chore(deps): bump ua-parser-js from 0.7.32 to 0.7.33 in /packages/noco-docs by @dependabot in https://github.com/nocodb/nocodb/pull/4925 * build(deps): bump cookiejar from 2.1.3 to 2.1.4 in /packages/nocodb by @dependabot in https://github.com/nocodb/nocodb/pull/4921 * fix: Decimal Auto Type Section on Excel Import by @gitstart in https://github.com/nocodb/nocodb/pull/4915 * chore: bumb mysql container image version to 8.0.32 by @wingkwong in https://github.com/nocodb/nocodb/pull/4930 * feat: attachments by @wingkwong in https://github.com/nocodb/nocodb/pull/4820 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4940 * test: clamped text issue with pg by @dstala in https://github.com/nocodb/nocodb/pull/4943 ## New Contributors * @proke03 made their first contribution in https://github.com/nocodb/nocodb/pull/4842 * @gitstart made their first contribution in https://github.com/nocodb/nocodb/pull/4849 * @southball made their first contribution in https://github.com/nocodb/nocodb/pull/4379 * @ZoeThivet made their first contribution in https://github.com/nocodb/nocodb/pull/4897 **Full Changelog**: https://github.com/nocodb/nocodb/compare/0.101.2...0.104.1