0.101.0: Feature Release
🚀 NocoDB Feature Release: Snowflake Support, BarCode Column & Emojis 🚀
🥬 What's new .. What's fresh ?
Snowflake Database support (Enterprise Feature - Early Preview)
This is an enterprise-only feature available for preview freely. You can add a nocodb enterprise key in the UI to get started (any value at the moment will do). And you should be able to unlock all the productivity features of a nocodb spreadsheet on your own Snowflake database.
Barcode Column
(This feature was completely implemented by our wonderful community member @flisowna 👏)
A barcode column type is out! This new feature allows users to quickly scan and input barcode information in various supported formats including CODE128, EAN, EAN-13, EAN-8, EAN-5, EAN-2, UPC (A), CODE39, ITF-14, MSI, Pharmacode, Codabar. This new column type is compatible with the following valid column types, namely Number, SingleLineText, LongText, PhoneNumber, URL, Email, and Decimal.
We are thrilled to enable our customers with this new feature, which will help simplify the process of capturing, validating, and saving barcode information. With this innovative new feature, users can save time and reduce errors when entering barcode data.
We hope our customers enjoy the new barcode column type, and we look forward to continuing to bring our customers the latest innovations.
Reconfigurable table & view icons
Move over boring standalone static icons for tables & views. Add more colours, differentiate visually by opting out for separate icon for each table / view.
Add Data Source from within the project
We have now moved the option to add an existing database from within the project. No longer you have to do it from while creating the project. This change allows us to add multi data sources in the future (its available behind an easter egg at the moment ;)
🕐 Now, its demo time
Snowflake
snowflake.mov
Barcode Column
0.101.0-barcode.mp4
Multidata source
multi.mov
🐛 Closed Issues
- [🐛 Type: Bug][Status: Not Reproducible] 🐛 Bug: formula value in webhook comes up as output #4756
- [🔦 Type: Feature] feat: Freeze columns and header #4753
- [🐛 Type: Bug] 🐛 Bug: Disable edit option for cells in shared view #4750
- [closed] Android #4739
- [closed] 🔦 Feature: Need aggregation capabilities #4730
- [🚀 Status: Ready for Next Release] 🐛 Bug: table icon configuration not visible with multiple sources #4713
- [🟠 Priority: High] 🐛 Bug: NC_INVITE_ONLY_SIGNUP env is not working with 0.100.2 #4708
- [🚀 Status: Ready for Next Release] 🐛 Bug: When the primary key contains /, an error occurs when updating data #4704
- [🚀 Status: Ready for Next Release][Status: Reproducible] 🐛 Bug: using arrow keys to scroll through lookup or rollup values reports an error in cell #4702
- [🚀 Status: Ready for Next Release][Status: Reproducible] 🐛 Bug: Error popup when clearing a number field for a row in a postgres database #4701
- [🚀 Status: Ready for Next Release][🟠 Priority: High] 🐛 Bug: Adding attachment is failing for editor role #4699
- [closed] 🐛 Bug: nocodb\packages\nocodb\node_modules\sqlite3\lib\binding\napi-v6-win32-unknown-x64\node_sqlite3.node is not a valid Win32 application #4695
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: Shared view link access (in incognito) redirects to sign-in page #4694
- [🔦 Type: Feature] 🔦 Feature: sql query and sql import #4689
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: Cursor movements blocked during view rename #4686
- [🚀 Status: Ready for Next Release] 🐛 Bug: expected a string but received a array #4685
- [🚀 Status: Ready for Next Release] 🐛 Bug: SyntaxError: Unexpected token } in JSON --> breaks and lost all data in table #4682
- [🔦 Type: Feature][🚀 Status: Ready for Next Release] 🔦 Feature: Provide iframe details for
share view
too #4680 - [🔦 Type: Feature] 🔦 Feature: More information on LinkToAnotherRecord Hover #4677
- [closed] Suggestion: Add bounties? #4652
- [🔎 Status: More Info Needed] 🐛 Bug: when I import a csv file,I ge a 404 error #4648
- [🐛 Type: Bug] 🐛 Bug: When saving long text the cell size increases #4639
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: Lost value when judgement of empty value of cell #4638
- [closed] Enhancement: Retain search items on tab switch #4636
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: referenced Number is "null" if the Value in the other Table is 0 #4628
- [closed] 🐛 Bug: Error comes whenever monaco editor is opened #4619
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: nocodb still allows open invitation if google app ID is set #4618
- [🐛 Type: Bug][🚀 Status: Ready for Next Release][Status: Reproducible] 🐛 Bug: Can't upload csv with empty value for 'Date' filed #4610
- [closed] 🐛 Bug: Setting primary value removes existing relations #4606
- [🐛 Type: Bug][🎰 Scope : Hosting] 🐛 Bug: 1-click deploy to heroku is broken #4602
- [closed] Upload csv for existing data not working, #4600
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: Create API broken (partially) for attachment after upgrade #4597
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: Formula edit modal continues to display older column name in formula after rename #4595
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: Formula issues with column names with a space in their names #4592
- [🐛 Type: Bug][🔎 Status: More Info Needed] 🐛 Bug: Expert a string but recevied an array #4589
- [🔦 Type: Feature][🚀 Status: Ready for Next Release] 🔦 Feature: Add Formatting option to Datetime field #4582
- [🔦 Type: Feature] 🔦 Feature: Extend support for Expanded row in Shared view #4579
- [🐛 Type: Bug][🚀 Status: Ready for Next Release][🟠 Priority: High] 🐛 Bug: Not able to type in expanded form if trying to add record from LTAR list #4575
- [🚀 Status: Ready for Next Release] 🔦 Feature: change the error prompt for forgot password #4570
- [🐛 Type: Bug][🐘 DB : Postgres][🚀 Status: Ready for Next Release] 🐛 Bug: Formula - IF failed on date columns on PG #4546
- [🚀 Status: Ready for Next Release][🟣 Priority: Low] 🐛 Bug: Column order not as configured in Download XLSX from shared grid view #4537
- [closed] 🐛 Bug: On going issues in develop ( >0.99.2 ) #4529
- [closed] Feature : Column options #4523
- [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: Feeding any character when date cell in-focus, clears cell contents #4493
- [🔎 Status: More Info Needed] 🐛 Bug: json Column → returning null, errors in console, won't save #4484
- [🏗️ Type: In Development] [PR] Keyboard manoeuvre : open items #4407
- [🟠 Priority: High][🏗️ Type: In Development] 🐛 Bug: Tab switch in a certain usecases is leading to block of UI #4402
- [closed] 🐛 Bug: Windows Binary #4394
- [🏗️ Type: In Development] [feat/multiple-source] Failed to open project #4355
- [🧱 Type: Refactoring] refactor: clean up nc-cli #4334
- [closed] 🐛 Bug: cell data disappears after page refresh #4329
- [closed] 🐛 Bug: Socket hang up when importing from Airtable #4326
- [closed] 🐛 Bug: Text in GridView gets deleted at the end while inputting text in SingleLineText cell #4303
- [Status: Not Reproducible] 🐛 Bug: Duplicated user entries showing up #4264
- [🐛 Type: Bug] 🐛 Bug: AT import fails if other tables present in project #4230
- [🔎 Status: More Info Needed] 🐛 Bug: Abort trap: 6 #4177
- [🐛 Type: Bug] 🐛 Bug: TOKEN API can be use in all Project #4163
- [🔦 Type: Feature] 🔦 Feature: Single select and Multiple Select -> allow adding new option within the cell. #4095
- [closed] 🐛 Bug: Previous project table count is shown in current project #4028
- [🔎 Status: More Info Needed] 🐛 Bug: The migration directory is corrupt, the following files are missing: nc_011_remove_old_ses_plugin #3997
- [🔦 Type: Feature][🚀 Status: Ready for Next Release] 🔦 Feature: DATEDIFF() #3950
- [🔦 Type: Feature] 🔦 Feature: Playwright for e2e tests #3939
- [🔎 Status: More Info Needed] 🔦 Feature: DropDown menu in nocoDB form #3934
- [🚀 Status: Ready for Next Release] Quick Import - AIRTABLE (Cannot read property 'length' of undefined) #3927
- [🐛 Type: Bug][🔎 Status: More Info Needed] 🐛 Bug: Filtering with equal operator is not working as expected #3874
- [🐛 Type: Bug] 🐛 Bug: Cannot restrict users from creating projects #3867
- [🔦 Type: Feature][🚀 Status: Ready for Next Release] 🔦 Feature: Display option for JSON row #3826
- [🐛 Type: Bug][🔎 Status: More Info Needed] Import currency field #3788
- [🔦 Type: Feature][🚀 Status: Ready for Next Release] [Feature] Allow editing of the db credentials for a project which is on external db #3700
- [🐛 Type: Bug][👓 Scope : View] 🐛 Bug: Opening Editor component throws errors in console #3631
- [🔦 Type: Feature] Column type : QR Code #3581
- [✨ Type: Enhancement][🏗️ Status: In Resolution] Cypress tests improvements #3580
- [🔎 Status: More Info Needed] npm start on dashboard showing 404 Not Found #3047
- [✨ Type: Enhancement][🔦 Type: Feature][🍰 Scope : Column] [Feature] Use Formula result in Rollup #3014
- [🔦 Type: Feature][🔭 Scope : Project] Pressing the "here"-button in the "For production please see here." message does nothing #2823
- [🏗️ Type: In Development] Select v2: error on reconfiguring dbType to varchar #2765
- [🔦 Type: Feature][🔭 Scope : Project] [Feature] Option to reconfigure external DB configuration parameters #2657
- [🔎 Status: More Info Needed] PostgreSQL specific type "inet" looks as empty string on NocoDB #2556
- [🔎 Status: More Info Needed] Suspected Memory Leak #2510
- [🐛 Type: Bug] Unexpected errors when switching between tables #2494
- [🔎 Status: More Info Needed] "The "config.option.port" property must be of type number" and other issues #2305
- [🔎 Status: More Info Needed] When I create a new form and find that the field properties are incorrect, I can't change them. #2202
- [✨ Type: Enhancement][🔦 Type: Feature][🔭 Scope : Project] [Feature] Option to reconfigure (or) disable auto-save timeout during cell updates #2133
- [🔦 Type: Feature] [Feature] Support rollup columns on virtual columns #1844
- [✨ Type: Enhancement][🔦 Type: Feature][🔭 Scope : Project] First load from docker or sharedbase or project is slow #1721
- [🔦 Type: Feature][👓 Scope : View] [Feature] Show the buttons without operation permission as gray. #1621
- [🔦 Type: Feature][🍰 Scope : Column] [Feature] Multiple Link between records #1462
- [🐛 Type: Bug] 🐛 Bug: Updating an existing webhook leads to an error #1439
- [🔎 Status: More Info Needed] Support ?ssl=true is NC_DATABASE_URL #1369
- [🔦 Type: Feature][☎ Scope : API] [Feature] Limit Swagger API access #1338
- [🔦 Type: Feature][🍰 Scope : Column] Multiselect edits not reflected across row values #1286
- [🐛 Type: Bug] 🐛 Bug: Digital Ocean default docker setup with a postgres database provided by DO doesn't run. #1174
- [🔦 Type: Feature][🌮 Scope : Table] [Feature] Multilink between tables #1158
- [🔦 Type: Feature][🔭 Scope : Project][☎ Scope : API] [Feature] Hide main Table view from
comment
andview
roles #834 - [🔦 Type: Feature][🚘 Scope : Automation] After Update automation has access to old field value #808
- [🐛 Type: Bug] Multiple id columns are shown when there is only 1 id column in the table. #806
- [💡 Type: Idea] Usability improvement suggestion from Discord user #803
- [✨ Type: Enhancement][🔦 Type: Feature][🔭 Scope : Project] New user pain points related to SQLite and improper error messages #749
- [🔦 Type: Feature][🍰 Scope : Column] [FEATURE] limit attachments to upload #685
- [🔦 Type: Feature][🍰 Scope : Column] Changing ID type fails #603
- [✨ Type: Enhancement] Feature: edit external database connection details #439
- [✨ Type: Enhancement][🔦 Type: Feature][👋 For : Community or Good First Issue][🍰 Scope : Column] special characters in column names #411
- [✨ Type: Enhancement][🔦 Type: Feature][👋 For : Community or Good First Issue][👓 Scope : View] Issue: Align data to top in grid view #345
- [🔦 Type: Feature][👮 Scope : Auth] Feature: open user registration #284
- [✨ Type: Enhancement][🔦 Type: Feature][🚥 Status: On Hold][👮 Scope : Auth] Ability to delete users #214
- [🔦 Type: Feature][🔭 Scope : Project] Feature : Provide sample projects. #207
- [🔦 Type: Feature][🔭 Scope : Project] Feature : Drag & Drop for dashboard #160
- [🔦 Type: Feature][🔭 Scope : Project] Feature : SQL Editor #137
- [🔦 Type: Feature][🔭 Scope : Project] Feature : SQL : Support Procedures & Functions #136
What's Changed
- Release 0.100.2 by @github-actions in #4578
- fix(nc-gui): type issues by @wingkwong in #4574
- feat: allow project to connect to multiple data sources by @mertmit in #3573
- New Crowdin updates by @o1lab in #4596
- QrCode: also allow decimals and numbers as referenced values by @spaudanjo in #4585
- fix(nocodb): provide header in XLSX.utils.json_to_sheet by @wingkwong in #4581
- fix(nc-gui): retrieve the correct column name based on the formula by @wingkwong in #4598
- fix(nocodb-sdk): include node.value for literal case by @wingkwong in #4599
- Copy paste cell more tests added by @mustafapc19 in #4552
- chore: previews for every PR release using Uffizzi by @waveywaves in #4460
- fix: add useNullAsDefault flag for sqlite on root level by @mertmit in #4609
- Add other DBs to uffizzi preview by @waveywaves in #4605
- fix(nc-gui): parse string date if date is not null by @wingkwong in #4611
- New Crowdin updates by @o1lab in #4608
- revert mssql and mysql in uffizzi previews by @waveywaves in #4614
- chore(deps): bump qs from 6.10.1 to 6.11.0 in /packages/noco-docs by @dependabot in #4620
- fix trivial typos in a README by @williamstein in #4623
- docs: remove heroku info by @wingkwong in #4627
- Fix getColVal in parserHelpers.ts -> col index can be 0 -> so check only that its not undefined by @semmjon in #4631
- chore(deps): bump qs and express in /packages/nc-cli by @dependabot in #4622
- New Crowdin updates by @o1lab in #4635
- New Crowdin updates by @o1lab in #4637
- New Crowdin updates by @o1lab in #4640
- fix: can’t find Id by @willnewii in #4632
- feat: pre-release by @wingkwong in #4601
- fix(nocodb): handle comparing a date with empty string in pg by @wingkwong in #4586
- New Crowdin updates by @o1lab in #4646
- Possible fix for API requests with wrong baseId ("undefined"). by @semmjon in #4633
- Update uffizzi compose with other dbs by @waveywaves in #4663
- Update --bug-report.yaml by @altosaar in #4536
- Add condition to uffizzi preview to run only on success of previous workflow by @waveywaves in #4676
- fix save search query by @ketewan in #4654
- fix multiselect by @ketewan in #4656
- feat: formula DATETIME_DIFF by @wingkwong in #4629
- feat(nc-gui): datetime options by @wingkwong in #4593
- refactor(nocodb): move convertAttachmentType to extractRawQueryAndExec by @wingkwong in #4612
- Correct parameter in delete token by @vijayrathore8492 in #4681
- feat: Snowflake support by @mertmit in #4645
- fix: search result can’t paging by @willnewii in #4692
- Feat: Custom table icon by @pranavxc in #4630
- fix(nocodb): formula returns empty result when identifier is null by @wingkwong in #4644
- refactor(gui): remove dropdown for create project from project list page by @dstala in #4703
- Barcode by @flisowna in #4641
- fix(gui): GUI - allow attachment upload if user have permission by @pranavxc in #4700
- Miscellaneous bug fixes and enhancements by @pranavxc in #4696
- New Crowdin updates by @o1lab in #4707
- fix: proper error if provided url is not shared base by @mertmit in #4705
- fix get filter by id API by @vijayrathore8492 in #4706
- Fix: GUI Treeview - table icon toggling in multi datasource view by @pranavxc in #4714
- Miscellaneous bug fixes by @pranavxc in #4715
- 0.101.0-beta.0 Pre-release by @github-actions in #4716
- Release 0.101.0-beta.0 by @github-actions in #4717
- Fix vue warning (remove unused class of Barcode Wrapper) by @flisowna in #4725
- chore(deps): bump json5 from 2.2.0 to 2.2.2 in /packages/nc-cli by @dependabot in #4718
- chore(deps): bump json5 and tsconfig-paths in /packages/nc-plugin by @dependabot in #4719
- chore(deps): bump json5, webpack and nuxt in /packages/noco-docs by @dependabot in #4720
- chore(deps): bump jsonwebtoken from 8.5.1 to 9.0.0 in /packages/nocodb by @dependabot in #4690
- fix(workflows): handle pre release tag case by @wingkwong in #4727
- fix: route problems after editing project name by @mertmit in #4726
- test: date picker configuration by @dstala in #4742
- New Crowdin updates by @o1lab in #4741
- Add sk language by @filiphanes in #4740
- i18n/language support for cs, eu, sk by @dstala in #4743
- New Crowdin updates by @o1lab in #4744
- fix(nc-gui): add customDistPath for monacoEditorPlugin by @wingkwong in #4738
- New Crowdin updates by @o1lab in #4747
- fix: remove datasource by @mertmit in #4761
- New Crowdin updates by @o1lab in #4765
- fix(nocodb): SUBSTR for postgres by @wingkwong in #4766
- refactor: nocodb documentation by @wingkwong in #4769
- fix(nocodb): MOD for postgres by @wingkwong in #4767
- New Crowdin updates by @o1lab in #4775
- fix: at import barcode type by @mertmit in #4780
- chore(deps): bump json5 from 1.0.1 to 1.0.2 in /tests/playwright by @dependabot in #4771
- chore(deps): bump json5 from 1.0.1 to 1.0.2 in /packages/nocodb-sdk by @dependabot in #4770
- chore(deps): bump json5 from 1.0.1 to 1.0.2 in /packages/nc-gui by @dependabot in #4772
- chore(deps): bump json5 from 1.0.1 to 1.0.2 in /packages/nocodb by @dependabot in #4773
- chore(deps): bump json5 from 1.0.1 to 1.0.2 in /packages/nc-plugin by @dependabot in #4774
- chore(deps): bump luxon from 1.28.0 to 1.28.1 in /packages/nocodb by @dependabot in #4791
- fix(nocodb): symbol col.table_name not found by @wingkwong in #4764
- fix: filters logic by @wingkwong in #4795
- fix(nocodb-sdk): formula curly hook logic + formula refactoring by @wingkwong in #4776
- fix(nc-gui): single multi select behaviours based on roles by @wingkwong in #4803
- Fix - Miscellaneous bugs by @pranavxc in #4762
- New Crowdin updates by @o1lab in #4804
- fix(nocodb): formula datetime diff for sqlite by @wingkwong in #4809
- fix(workflows): GitHub Actions annotations warnings by @wingkwong in #4802
- fix(nc-gui): show LTAR record in view for users to add even it is empty by @wingkwong in #4800
- 0.101.0 Pre-release by @github-actions in #4810
New Contributors
- @waveywaves made their first contribution in #4460
- @williamstein made their first contribution in #4623
- @semmjon made their first contribution in #4631
- @altosaar made their first contribution in #4536
- @flisowna made their first contribution in #4641
- @filiphanes made their first contribution in #4740
Full Changelog: 0.100.2...0.101.0
Join Our Team
Thank you for your love & support
💜 🚀