NocoDB: 0.100.1 : Feature release

# 🚀 [NocoDB](https://nocodb.com) Feature Release : QR Code, Keyboard Shortcuts and ... 🚀 ## 🥬 What's new .. What's fresh ?  ### :clapper: QR Code We are excited to announce a new column type : QR Code! This generates QR Code for any row. QR Code generations works similar Forumula and currently supports these columns : - SingleLine Text - Long Text - Phone Number - Email - URL - Formula Support for more columns will come soon. And the more exciting bit of this feature is it is done by our community contributor Daniel (@spaudanjo) - Daniel is software engineer by profession and is passionate about building tech where there is humanitarian crisis. And he has dedicated time aside & raised grants to work on Noco. ### :keyboard: Keyboard Shortcuts With combinations of keys, you can trigger some actions without moving your mouse. ### :cool: Copy and Paste With `Ctrl` + `C` and `Ctrl` + `V`, we can copy the data from one cell to another, even to another tables. For LTAR columns, only BelongTo is supported. ### :zap: Advanced Options in Column Menu Advanced options has been added to the column menu. Now we can sort the column in an ascending order or descending order, hide the column, duplicate it or even insert the column after / before the chosen one. Also we show the count in badge for `Fields`, `Filter` and `Sort`. ## 🕐 Now, its demo time ## :clapper: QR Code In this version, we introduced a new column type - QR Code. QR Code is a virtual column which supports different column types for the referenced value to be encoded. The generated QR code is dynamic, which means whenever the referenced column is changed, the QR code will be updated as well. [0.100.0-qr-code.webm](https://user-images.githubusercontent.com/35857179/204971197-089d4ee6-ea92-4167-a65c-bd9c98aa3024.webm) ## :keyboard: Keyboard Shortcuts By pressing `ctrl` + `/`, you can see the available shortcut keys. Or you can check it out in Help Center. > If you are a Mac user, `ctrl` is `cmd` key. [0.100.0-keyboard-shortcuts.webm](https://user-images.githubusercontent.com/35857179/204980453-259e0b3e-ab36-4bf3-9f61-ad612b12572c.webm) ## :cool: Copy and Paste Now you can copy a single cell and paste it to another cell. To copy the data, select the target cell and press `ctrl` + `c` , then press `ctrl` + `v` on the target cell. It could be another table and the existing cell data will be replaced. [0.100.0-copy-and-paste.webm](https://user-images.githubusercontent.com/35857179/204969421-96d5d1b5-785a-4bb7-95d9-9b6cbc07ead5.webm) ## :zap: Advanced Options in Column Menu <img width="424" alt="Screenshot 2022-11-29 at 4 43 16 PM" src="https://user-images.githubusercontent.com/61551451/204515084-ce0ffa3b-39e4-40f9-b7c9-e71f7c714bdb.png"> <img width="229" alt="Screenshot 2022-11-29 at 4 43 29 PM" src="https://user-images.githubusercontent.com/61551451/204515105-c2862dee-b229-4ed4-9c5d-a9d8b21277a9.png"> ## 👀 Coming soon - a teaser below 👀 🎉 🚀 - Supporting multiple database from a single project 🤯 🤟 ❤️ https://user-images.githubusercontent.com/5435402/195718718-df3d6c14-8be6-4148-a2b4-2f0c5e23aa96.mp4 We cannot wait to release them soon. 🤝 ## 🐛 Closed Issues - [**🔦 Type: Feature**] 🔦 Feature: LinkRecord modal, additional information in link cards like vika [#4539](https://github.com/nocodb/nocodb/issues/4539) - [**closed**] 🐛 Bug: Super admin is not assigned. How to asign and change admin? [#4532](https://github.com/nocodb/nocodb/issues/4532) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Related database is not shown correctly since upgrade from 0.99.0 to 0.99.1 [#4500](https://github.com/nocodb/nocodb/issues/4500) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: dropdown not getting destroyed from DOM [#4369](https://github.com/nocodb/nocodb/issues/4369) - [**👋 For : Community or Good First Issue**] Not all fields are populated when using uuid field instead of serial id field [#270](https://github.com/nocodb/nocodb/issues/270) - - [**closed**] 🐛 Bug: No data displayed when navigating from a table on page 2 to a table that only has one page [#4553](https://github.com/nocodb/nocodb/issues/4553) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Grid cell in edit mode - mouse based operations doesn't work [#4542](https://github.com/nocodb/nocodb/issues/4542) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Attachment photo file size issue [#4528](https://github.com/nocodb/nocodb/issues/4528) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Division in formula display nothing [#4527](https://github.com/nocodb/nocodb/issues/4527) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Cell contents are not stored in BE for column type Year & Time [#4520](https://github.com/nocodb/nocodb/issues/4520) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Unable to click after using IP address as URL [#4517](https://github.com/nocodb/nocodb/issues/4517) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**] 🐛 Bug: Using CTRL key to move inside webhook editor moves cursor on the underlying data sheet instead [#4512](https://github.com/nocodb/nocodb/issues/4512) - [**🚀 Status: Ready for Next Release**] 🐛 Bug: Color coding for has-many, many-to-many, belongs-to relation [#4501](https://github.com/nocodb/nocodb/issues/4501) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**] 🔦 Feature: Allow pasting into text field without having to enter edit mode first [#4496](https://github.com/nocodb/nocodb/issues/4496) - [**🐛 Type: Bug**][**🐹 DB : SQLite**][**🚀 Status: Ready for Next Release**] 🐛 Bug: number sorting and filters don't work when column was changed from text to something numberic [#4380](https://github.com/nocodb/nocodb/issues/4380) - [**🐛 Type: Bug**][**🚀 Status: Ready for Next Release**][**🟡 Priority: Medium**] Creating composite PK in MySQL & Sqlite results in failure [#1263](https://github.com/nocodb/nocodb/issues/1263) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**][**🌮 Scope : Table**] [Feature] Copy-Pasting from NocoDB tables [#978](https://github.com/nocodb/nocodb/issues/978) - [**🔦 Type: Feature**][**🚀 Status: Ready for Next Release**][**🔭 Scope : Project**] [Feature] Allow editing fileds if SQLite database is being used. [#869](https://github.com/nocodb/nocodb/issues/869) ## What's Changed * Release 0.99.2 by @github-actions in https://github.com/nocodb/nocodb/pull/4507 * chore(deps): bump minimatch and mocha in /packages/nocodb by @dependabot in https://github.com/nocodb/nocodb/pull/4511 * chore(deps): bump minimatch from 3.0.4 to 3.1.2 in /packages/noco-docs by @dependabot in https://github.com/nocodb/nocodb/pull/4509 * chore(deps): bump minimatch from 3.0.4 to 3.1.2 in /packages/nc-plugin by @dependabot in https://github.com/nocodb/nocodb/pull/4508 * chore(deps): bump minimatch from 3.0.4 to 3.1.2 in /packages/nc-cli by @dependabot in https://github.com/nocodb/nocodb/pull/4510 * fix(swagger): update attachment column type by @pranavxc in https://github.com/nocodb/nocodb/pull/4513 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4515 * fix(nc-gui): Fixed column icon for LTAR, rollup by @mustafapc19 in https://github.com/nocodb/nocodb/pull/4505 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4516 * Copy in right menu, notification and refactor by @ketewan in https://github.com/nocodb/nocodb/pull/4244 * fix: fail to identity URL by @wingkwong in https://github.com/nocodb/nocodb/pull/4519 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4524 * Fix: exclude time and year cell from manual save by @pranavxc in https://github.com/nocodb/nocodb/pull/4530 * Add QR column type by @spaudanjo in https://github.com/nocodb/nocodb/pull/4468 * Added stress testing of newly added test to CI by @mustafapc19 in https://github.com/nocodb/nocodb/pull/4521 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4534 * Feat: Grid - Add advanced options in column header menu by @pranavxc in https://github.com/nocodb/nocodb/pull/4504 * fix: formula division for mysql by @wingkwong in https://github.com/nocodb/nocodb/pull/4543 * feat: reconnect quick import logs by @mertmit in https://github.com/nocodb/nocodb/pull/4486 * fix(gui): Miscellaneous GUI bugs by @pranavxc in https://github.com/nocodb/nocodb/pull/4544 * fix: improved refresh sidebar logic by @mertmit in https://github.com/nocodb/nocodb/pull/4545 * fix(test): Made default file field size limit to 20MB and is configurable using NC_ATTACHMENT_FIELD_SIZE env variable by @mustafapc19 in https://github.com/nocodb/nocodb/pull/4538 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4548 * feat: keyboard manoeuvre by @wingkwong in https://github.com/nocodb/nocodb/pull/4482 * docs: keyboard maneuver by @dstala in https://github.com/nocodb/nocodb/pull/4478 * Feat: Grid - copy paste cell data by @pranavxc in https://github.com/nocodb/nocodb/pull/4514 * chore(deps): bump terser from 4.8.0 to 4.8.1 in /packages/nocodb by @dependabot in https://github.com/nocodb/nocodb/pull/2780 * feat: sqlite alter table change column by @mertmit in https://github.com/nocodb/nocodb/pull/3668 * test: Field menu followup - playwright test by @pranavxc in https://github.com/nocodb/nocodb/pull/4547 * feat(nc-gui): add $e for shortcuts by @wingkwong in https://github.com/nocodb/nocodb/pull/4550 * fix(gui): Grid - add rating validation while pasting by @pranavxc in https://github.com/nocodb/nocodb/pull/4551 * Release 0.100.0 by @github-actions in https://github.com/nocodb/nocodb/pull/4555 * fix: Grid - Sync unsaved data properly when switching tab by @pranavxc in https://github.com/nocodb/nocodb/pull/4559 **Full Changelog**: https://github.com/nocodb/nocodb/compare/0.99.2...0.100.1 ## 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 💜 🚀