NocoDB 0.97.0 — Release Notes & Engineering Impact

# 🚀 [NocoDB](https://nocodb.com) : Feature Release 🚀 # ERD View & Link to a Specific Row <img width="1388" alt="Screenshot 2022-09-21 at 13 01 38" src="https://user-images.githubusercontent.com/5435402/191498680-6d5c4c38-49ca-4a4f-b3b0-187ed7b31332.png"> ## 🥬 What's new .. What's fresh ? - 🌈 **ERD Views** : NocoDB's user love creating tables - however without an ERD diagram its not so intuitive to understand the design of schema. Right ? - So we are happy to introduce ERD view at table and schema level. - Visualise all the relations (HasMany, ManyToMany) in the nicest possible way. - Drag and rearrange as you like. - 🔗 **Link to a row** : when you expand a row in spreadsheet as a form, it wasn't possible before to send a link to your co-worker. Not any more! - Now you can simply expand the row - click to get the link. - Or even simply copy from the browser url and send it to via slack or emails. As easy as it gets. # 🕐 Demo time ## 🌈 ERD View https://user-images.githubusercontent.com/5435402/191498877-4de466e6-7327-461c-8cec-702b3a6b49c9.mov ## 🔗 Link to Expanded Form View https://user-images.githubusercontent.com/5435402/191498919-af626828-0104-47e1-a653-4fadc3a3ef43.mov # 👀 Coming soon 👀 🎉 - 📊 [Kanban View](https://github.com/nocodb/nocodb/issues/140): Ohhhh yes - the most liked feature, 100s of 👍 on this feature by community, is in [the making](https://github.com/nocodb/nocodb/issues/140) & its free! Can't get any better. - 🎨 [Survey Form View](https://github.com/nocodb/nocodb/issues/3557): Gorgeous & limitless survey forms on your own databases. ### Kanban : Sneak preview [screen-capture (1).webm](https://user-images.githubusercontent.com/5435402/191495830-fd6ac379-e22e-40c0-932f-27afc0f83668.webm) ### Survey form : sneak preview https://user-images.githubusercontent.com/5435402/191495787-12711957-59b4-4a02-a33f-b6341efb09a8.mov We cannot wait to release them soon. 🤝 ## 🐛 Closed Issues - [**closed**] [Feature] LDAP or SAML [#3717](https://github.com/nocodb/nocodb/issues/3717) - [**Type: Bug**] Add new row toolbar button broken for gallery view [#3689](https://github.com/nocodb/nocodb/issues/3689) - [**closed**] Creating new tags for select and multi-select columns via API [feature request] [#3661](https://github.com/nocodb/nocodb/issues/3661) - [**Type: Bug**][**Type: In Development**] new project displays deleted project table name's [#3635](https://github.com/nocodb/nocodb/issues/3635) - [**closed**] Webhook filter condition add/update - grid view in the background appears to reload [#3633](https://github.com/nocodb/nocodb/issues/3633) - [**closed**] Dockerfile typo [#3619](https://github.com/nocodb/nocodb/issues/3619) - [**For: Community or Good First Issue**] [API] Create columns on table type linkToAnotherRecord [#3608](https://github.com/nocodb/nocodb/issues/3608) - [**closed**] Metadata on multi-instance deployment becomes unsynchronized [#3587](https://github.com/nocodb/nocodb/issues/3587) - [**closed**] [question] sum up rows? [#3586](https://github.com/nocodb/nocodb/issues/3586) - [**Type: Feature**] vue3: shared view list- `show all shared views of this table` option missing [#3480](https://github.com/nocodb/nocodb/issues/3480) - [**closed**] vue3: additional network queries when filter `auto apply` is disabled [#3479](https://github.com/nocodb/nocodb/issues/3479) - [**closed**] vue3: signUp page if root db file is for first use [#3458](https://github.com/nocodb/nocodb/issues/3458) - [**Scope: vue3**] vue3: Documentation [#3264](https://github.com/nocodb/nocodb/issues/3264) - [**closed**] Show cover image in gallery view also if fields is not enabled [Feature] [#3199](https://github.com/nocodb/nocodb/issues/3199) - [**Type: i18n translation**] [i18n] Language support extension- <language code> [#2904](https://github.com/nocodb/nocodb/issues/2904) - [**closed**] Can't add new record for many-to-many field [#2900](https://github.com/nocodb/nocodb/issues/2900) - [**closed**] Image is not shown in gallery view when the attachment field is hidden [#2864](https://github.com/nocodb/nocodb/issues/2864) - [**closed**] "Copy Project Info" does not work on Safari [#2824](https://github.com/nocodb/nocodb/issues/2824) - [**Type: In Development**][**Scope: UI / UX**] sort UI broken [#2781](https://github.com/nocodb/nocodb/issues/2781) - [**Type: Feature**][**Product : Project**] [Feature] One-to-One Relationship [#2777](https://github.com/nocodb/nocodb/issues/2777) - [**Type: Bug**][**Type: In Development**][**Status: Reproducible**] Error on trying to rename formula column [#2768](https://github.com/nocodb/nocodb/issues/2768) - [**For: Community or Good First Issue**] [Feature] Include the name of the deleting project into the dialog [#2752](https://github.com/nocodb/nocodb/issues/2752) - [**Type: In Development**] Safari browser UI functionality issues [#2666](https://github.com/nocodb/nocodb/issues/2666) - [**closed**] Add multiple row to existing table with a csv file [#2594](https://github.com/nocodb/nocodb/issues/2594) - [**closed**] options not shown when choosing from a LTAR column (not solved yet) [#2546](https://github.com/nocodb/nocodb/issues/2546) - [**closed**] API Authentication Failure [#2544](https://github.com/nocodb/nocodb/issues/2544) - [**closed**] [Feature] npx for nocodb-dev-daily [#2289](https://github.com/nocodb/nocodb/issues/2289) - [**closed**] NocoDB: Migrate Airtable to Postgres database - attachments are missing [#2269](https://github.com/nocodb/nocodb/issues/2269) - [**Priority: Low**][**Type: In Development**] [LTAR] right click - clear on LTAR field, throws error [#2105](https://github.com/nocodb/nocodb/issues/2105) - [**Type: In Development**][**Status: In Resolution**] [UIDT-improvements] Migration considerations & other items [#2037](https://github.com/nocodb/nocodb/issues/2037) - [**closed**] Multiselect color is not shown, when more than 10 slection options are given [#2002](https://github.com/nocodb/nocodb/issues/2002) - [**Type: In Development**] LTAR field- update operation not reflected till hard refresh [#1770](https://github.com/nocodb/nocodb/issues/1770) - [**closed**] Blank inscription form when NC_DASHBOARD_URL="/" (serving by Apache) [#1594](https://github.com/nocodb/nocodb/issues/1594) - [**closed**] Primary key column contains duplicate values [#1435](https://github.com/nocodb/nocodb/issues/1435) - [**closed**] Not fetching the data of tables after meta-sync [#1429](https://github.com/nocodb/nocodb/issues/1429) - [**closed**] ERR_OSSL_EVP_UNSUPPORTED [#1123](https://github.com/nocodb/nocodb/issues/1123) - [**closed**] Virtual hasMany relationships disappears when the table metadata is recreated [#851](https://github.com/nocodb/nocodb/issues/851) ## What's Changed * Release 0.96.4 by @github-actions in https://github.com/nocodb/nocodb/pull/3593 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/3556 * fix(nc-gui): lazy load languages for initial load perf by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3602 * chore(cypress): improvements by @pranavxc in https://github.com/nocodb/nocodb/pull/3597 * docs: NocoDB Documentation for 0.96.0 by @wingkwong in https://github.com/nocodb/nocodb/pull/3552 * feat(gui-v2): customizable urls in shared views by @dolsem in https://github.com/nocodb/nocodb/pull/3381 * fix: gallery card cover image distortion by @mertmit in https://github.com/nocodb/nocodb/pull/3618 * fix(nc-gui): make checkbox visible on hover & more easy to tick by @wingkwong in https://github.com/nocodb/nocodb/pull/3624 * refactor(gui): keep the right sidebar open by default by @pranavxc in https://github.com/nocodb/nocodb/pull/3626 * fix(gui): shared form view with password by @pranavxc in https://github.com/nocodb/nocodb/pull/3629 * add dolsem as a contributor by @allcontributors in https://github.com/nocodb/nocodb/pull/3632 * feat(nc-gui): add web types for directives by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3630 * refactor(nc-gui): defer loading project to subpage by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3606 * fix(gui): Importing Airtable to SQL databases - scroll fix by @pranavxc in https://github.com/nocodb/nocodb/pull/3636 * fix(nc-gui): checkbox cell unselectable by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3642 * fix(nc-gui): project state not properly reset by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3637 * fix(nc-gui): right sidebar collapse not working by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3660 * feat(nc-gui): store sidebar states separately by id by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3664 * fix(nc-gui): remove injection usage in callback by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3641 * Feat: fullscreen option to toggle nav drawers by @pranavxc in https://github.com/nocodb/nocodb/pull/3662 * feat(nc-gui): Added tooltip to show table name in table tree view by @mustafapc19 in https://github.com/nocodb/nocodb/pull/3634 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/3670 * test: cy views suite local storage & tab handling corrections by @dstala in https://github.com/nocodb/nocodb/pull/3667 * fix(gui): miscellaneous by @pranavxc in https://github.com/nocodb/nocodb/pull/3678 * refactor(nc-gui): hide loading spinner when reloading from webhook filters by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3646 * fix(pg): select column default value by @mertmit in https://github.com/nocodb/nocodb/pull/3620 * fix: select column issue by @mertmit in https://github.com/nocodb/nocodb/pull/3682 * API unit tests by @mustafapc19 in https://github.com/nocodb/nocodb/pull/3358 * Fix: Expanded form - hide reload and virtual columns if new record by @pranavxc in https://github.com/nocodb/nocodb/pull/3657 * fix: drop wrapping select queries for mssql by @mertmit in https://github.com/nocodb/nocodb/pull/3692 * fix: select column by @mertmit in https://github.com/nocodb/nocodb/pull/3691 * Feat: API - Add meta field to keep additional meta data by @pranavxc in https://github.com/nocodb/nocodb/pull/3683 * Fix: Add a fallback function copy to clipboard by @pranavxc in https://github.com/nocodb/nocodb/pull/3690 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/3697 * fix: Import Airtable to SQL Databases - fix number as a decimal by @dstala in https://github.com/nocodb/nocodb/pull/3638 * Fix: Miscellaneous bug fixes by @pranavxc in https://github.com/nocodb/nocodb/pull/3685 * test: cy-stability for dropdown by @dstala in https://github.com/nocodb/nocodb/pull/3699 * test: cy-stability-column edit operations by @dstala in https://github.com/nocodb/nocodb/pull/3704 * Fix: Filter - webhook and view filter bugs by @pranavxc in https://github.com/nocodb/nocodb/pull/3709 * fix(nc-gui): reset roles on app load by @bcakmakoglu in https://github.com/nocodb/nocodb/pull/3701 * test: use class names for menu & selection in filter & sort test by @dstala in https://github.com/nocodb/nocodb/pull/3712 * fix(api): apply column changes in order by @pranavxc in https://github.com/nocodb/nocodb/pull/3611 * Fix: Fullscreen button bugs by @pranavxc in https://github.com/nocodb/nocodb/pull/3713 * Feat/Add docs for unit tests by @mustafapc19 in https://github.com/nocodb/nocodb/pull/3714 * Fix: Random blank screen bug by @pranavxc in https://github.com/nocodb/nocodb/pull/3708 * refactor: i18n validation error messages by @dstala in https://github.com/nocodb/nocodb/pull/3658 * Feat: URL for expanded row by @pranavxc in https://github.com/nocodb/nocodb/pull/3655 * chore(gui): add cdn path as relative to load assets relative to the path by @pranavxc in https://github.com/nocodb/nocodb/pull/3722 * chore: skip cicd for draft PR by @dstala in https://github.com/nocodb/nocodb/pull/3724 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/3723 * feat(nc-gui): ERD by @mustafapc19 in https://github.com/nocodb/nocodb/pull/3612 * chore(gui): Build error by @pranavxc in https://github.com/nocodb/nocodb/pull/3728 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/3747 * Fix: Fixed issue regarding getRow helper in test env where it doesnt return undefined if row id doesnt exist by @mustafapc19 in https://github.com/nocodb/nocodb/pull/3727 * fix: add community translated by @mertmit in https://github.com/nocodb/nocodb/pull/3754 * 0.97.0 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/3755 **Full Changelog**: https://github.com/nocodb/nocodb/compare/0.96.4...0.97.0 # 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 💜 🚀