0.205.1: Bug Fix Release

🐛 Closed Issues

• [closed] 🐛 Bug: Copy to clipboard is failing with error #8022
• [closed] 🐛 Bug: Survey form- for rich text, Shift + Enter behaves as Enter #8010
• [🐛 Type: Bug] 🐛 Bug: The UI breaks when toggling the field type from single select to multi-select while creating a new field. #8000
• [closed] 🐛 Bug: ACL base editor permission, it not quite right #7992
• [closed] 🐛 Bug: Reduce gap between icons in rating field to fit 10 icons in default width of column (200px) #7985
• [closed] 🐛 Bug: Rating field icon is not updating on changing icon in edit column dropdown #7981
• [closed] 🐛 Bug: Formula - RIGHT and LEFT functions are not working in Postgres base #7961
• [🐛 Type: Bug] 🐛 Bug: Wrong virtual cell icon in column delete modal #7926
• [closed] 🐛 Bug: PW & Docs update for pre-filled form #7811
• [closed] 🐛 Bug: Handle forbidden column reordering more gracefully #7808
• [closed] 🐛 Bug: Docs update for Form new design #7765
• [closed] 🐛 Bug: MAX() in formula did not get the desired result #7720
• [🔎 Status: More Info Needed] 🐛 Bug: Sometimes after editing a form view it randomly stops being viewable when visiting the public share link #7714
• [closed] 🐛 Bug: Calendar UI/UX #7691
• [closed] 🔦 Feature: Locked Galleries should only be locked granularly #7547
• [closed] 🐛 Bug: After insert webhook triggering when clicking add row #7545
• [closed] 🐛 Bug: CSV Import fails in localhost #7544
• [closed] 🐛 Bug: webhook body tab absent #7525
• [closed] 🐛 Bug: cannot delete a row with a column of type link: "Failed to deleted record: the referenced record does not exist" #7480
• [closed] 🐛 Bug: Cannot use 'in' operator to search for 'id' in 1 error on insert #7470
• [🔎 Status: More Info Needed] 🐛 Bug: Failed to duplicate base #7428
• [closed] 🐛 Bug: Record height in expanded view should be adjustable #7228
• [closed] 🔦 Feature: Support Pasting Images for File Type Tables #7045
• [closed] 🐛 Bug: AjvError: Invalid request body when importing from Airtable #6867
• [closed] 🐛 Bug: "failed to copy to clipboard" when more than one cell is selected #5333
• [🔦 Type: Feature][🔭 Scope : Project] Feature request : personnalization of title and logo #494
• [closed] 🐛 Bug: Shared view- Cannot read properties of undefined (reading 'rqd') #8036
• [closed] 🐛 Bug: Shared form view doesn't show fields after a field is deleted on the grid #8032
• [closed] 🐛 Bug: Text overflow or unnecessary line break in top bar Data/Details mode switch #8028
• [Status: Reproducible] 🐛 Bug: Attachment file names have redundant file extension if MIME type extension != existing file extension #7897
• [closed] 🐛 Bug: View filter group not replicated on duplicate view & also not able to delete already existing filters from duplicated view #7728
• [🔦 Type: Feature] 🔦 Feature: Show user name in the User management and Base members lists #7323
• [closed] 🔦 Feature: Incomplete translation display #6338

What's Changed

• Release 0.204.9 by @github-actions in #7952
• Post-release: Master and develop branch sync by @pranavxc in #7953
• fix(nc-gui): calendar minor fixes by @DarkPhoenix2704 in #7943
• New Crowdin updates by @o1lab in #7955
• Nc fix/insert issue by @pranavxc in #7947
• New Crowdin updates by @o1lab in #7956
• fix: Reset offset count when closing modal or when filter query changes by @pranavxc in #7942
• chore(renovate): Update patch (patch) by @renovate in #7950
• Nc fix/misc bugs by @dstala in #7958
• fix: update discord link by @mertmit in #7964
• chore(deps): bump webpack-dev-middleware from 5.3.3 to 5.3.4 in /packages/noco-docs by @dependabot in #7934
• chore(renovate): Update patch (patch) by @renovate in #7959
• fix: Formula - RIGHT and LEFT methods argument type correction by @pranavxc in #7962
• Nc feat/form view builder field settings in right pannel and fixed column delete modal virtual cell icon issue by @rameshmane7218 in #7927
• Nc fix/form view typo mistak by @rameshmane7218 in #7972
• Nc Feat: Allow inline edit rich text field in form view by @rameshmane7218 in #7974
• Nc fix(nc-gui): allow copy paste email id from gmail in team & settings, for example, abc abc@gmail.com by @rameshmane7218 in #7963
• chore(renovate): Update dependency @unocss/nuxt to ^0.58.7 by @renovate in #7976
• test: change suite to emulate UI by @dstala in #7980
• Nc fix(nc-gui): Bug fixes by @rameshmane7218 in #7979
• Nc fix(nc-gui): prefill currency readonly field ui alignment issue by @rameshmane7218 in #7978
• fix: type issues with SqlClient by @mertmit in #7970
• New Crowdin updates by @o1lab in #7977
• chore(renovate): Update patch to ^10.3.6 (patch) by @renovate in #7982
• Nc fix(nc-gui): remove lookup cell chip min width fixed value by @rameshmane7218 in #7969
• Nc fix(nc-gui): Reduce gap between icons in rating field to fit 10 icons in default width of column by @rameshmane7218 in #7986
• fix typo by @fulldecent in #7988
• Nc docs/form view by @dstala in #7990
• Nc fix: add missing formula docs and link by @rameshmane7218 in #7987
• fix: shared form pw error handling by @mertmit in #7991
• New Crowdin updates by @o1lab in #7994
• fix: opt in to import.meta.* properties by @danielroe in #7983
• Enable calendar view by @pranavxc in #8003
• docs: gmt info by @dstala in #8002
• chore(renovate): Update patch (patch) by @renovate in #7996
• Nc calendar enable by @dstala in #7995
• chore: docs translation placeholders by @DarkPhoenix2704 in #7760
• Nc fix(nc-gui): ui break on toggle between select based field type by @rameshmane7218 in #8001
• New Crowdin updates by @o1lab in #8006
• chore(renovate): Update dependency @nestjs/serve-static to ^4.0.2 - autoclosed by @renovate in #8005
• chore(deps): bump express from 4.18.3 to 4.19.2 in /packages/noco-docs by @dependabot in #7967
• fix(nc-gui): Survey form- for rich text, Shift + Enter behaves as Enter by @rameshmane7218 in #8011
• chore(renovate): Update dependency pg to ^8.11.4 by @renovate in #8013
• chore(renovate): Update dependency @unocss/nuxt to ^0.58.9 by @renovate in #8016
• Nc docs/calendar by @dstala in #7998
• Nc fix/calendar by @dstala in #7997
• fix: Use useCopy composable for copying content to clipboard by @pranavxc in #8023
• 0.205.0 Pre-release by @github-actions in #8024
• Release 0.205.0 by @github-actions in #8025
• chore: post-release sync by @github-actions in #8026
• Support m...

0.205.0 : Introducing Calendar View & Revamped Form View

👋👋 Hey Everybody, Hey Everybody! 👋👋

🚀 Introducing Calendar View & Revamped Form View!

📆 Calendar View

We're excited to announce the release of the highly anticipated calendar view! Calendar view allows you to attach any of the date/datetime columns in a familiar calendar format!! (Calendar View Docs)

Key Features

• Calendar Layout: View your records that contain date fields in a traditional monthly, weekly, or daily calendar layout, complete with customisable views.
• Drag-and-Drop Scheduling: Easily reschedule events or tasks by simply dragging and dropping them to a new date on the calendar.
• Sort & Filter Records: Narrow down the records that gets displayed - filter your calendar view by specific criteria, such as project, team member, or any other relevant field.

We're confident that the new calendar view will significantly enhance your productivity and time management capabilities. Give it a try and let us know what you think!

📝 Revamped Form View

We're thrilled to introduce the all-new form view, packed with exciting features and improvements to enhance your form creation experience. Get ready to streamline your data collection process like never before!

• Simplified Form Builder: We have significantly revamped our form builder for the ease of use. With a sleek interface and drag-and-drop functionality, you can effortlessly add, rearrange, and customise form fields.

• Banner & Logo Images: Elevate your forms' professional appeal by adding banner and logo images. This new feature allows you to showcase your brand identity and create a consistent look across all your forms.

• Customisable Background Colour: Express your brand personality or match your forms to a specific theme by choosing a custom background colour.

• Pre-Filled Forms by Encoding URLs: NocoDB enables pre-filling fields in shared form views with specific values by setting URL parameters, allowing creation of custom URLs with desired field values.

• Customisable Select Fields: Now you have more control over how select fields are displayed in your forms. Choose between a dropdown or list view, and even limit the options shown in the form view.

We're confident that these enhancements will streamline your form creation process, boost user engagement, and elevate your brand's professional image. Give the revamped form view a try and let us know your thoughts!

As always, if you have any questions or feedback, our dedicated support team is here to assist you.

---

🐛 Closed Issues

• [closed] 🐛 Bug: Copy to clipboard is failing with error #8022
• [closed] 🐛 Bug: Survey form- for rich text, Shift + Enter behaves as Enter #8010
• [🐛 Type: Bug] 🐛 Bug: The UI breaks when toggling the field type from single select to multi-select while creating a new field. #8000
• [closed] 🐛 Bug: ACL base editor permission, it not quite right #7992
• [closed] 🐛 Bug: Reduce gap between icons in rating field to fit 10 icons in default width of column (200px) #7985
• [closed] 🐛 Bug: Rating field icon is not updating on changing icon in edit column dropdown #7981
• [closed] 🐛 Bug: Formula - RIGHT and LEFT functions are not working in Postgres base #7961
• [🐛 Type: Bug] 🐛 Bug: Wrong virtual cell icon in column delete modal #7926
• [closed] 🐛 Bug: PW & Docs update for pre-filled form #7811
• [closed] 🐛 Bug: Handle forbidden column reordering more gracefully #7808
• [closed] 🐛 Bug: Docs update for Form new design #7765
• [closed] 🐛 Bug: MAX() in formula did not get the desired result #7720
• [🔎 Status: More Info Needed] 🐛 Bug: Sometimes after editing a form view it randomly stops being viewable when visiting the public share link #7714
• [closed] 🐛 Bug: Calendar UI/UX #7691
• [closed] 🔦 Feature: Locked Galleries should only be locked granularly #7547
• [closed] 🐛 Bug: After insert webhook triggering when clicking add row #7545
• [closed] 🐛 Bug: CSV Import fails in localhost #7544
• [closed] 🐛 Bug: webhook body tab absent #7525
• [closed] 🐛 Bug: cannot delete a row with a column of type link: "Failed to deleted record: the referenced record does not exist" #7480
• [closed] 🐛 Bug: Cannot use 'in' operator to search for 'id' in 1 error on insert #7470
• [🔎 Status: More Info Needed] 🐛 Bug: Failed to duplicate base #7428
• [closed] 🐛 Bug: Record height in expanded view should be adjustable #7228
• [closed] 🔦 Feature: Support Pasting Images for File Type Tables #7045
• [closed] 🐛 Bug: AjvError: Invalid request body when importing from Airtable #6867
• [closed] 🐛 Bug: "failed to copy to clipboard" when more than one cell is selected #5333
• [🔦 Type: Feature][🔭 Scope : Project] Feature request : personnalization of title and logo #494

What's Changed

• Release 0.204.9 by @github-actions in #7952
• Post-release: Master and develop branch sync by @pranavxc in #7953
• fix(nc-gui): calendar minor fixes by @DarkPhoenix2704 in #7943
• New Crowdin updates by @o1lab in #7955
• Nc fix/insert issue by @pranavxc in #7947
• New Crowdin updates by @o1lab in #7956
• fix: Reset offset count when closing modal or when filter query changes by @pranavxc in #7942
• chore(renovate): Update patch (patch) by @renovate in #7950
• Nc fix/misc bugs by @dstala in #7958
• fix: update discord link by @mertmit in #7964
• chore(deps): bump webpack-dev-middleware from 5.3.3 to 5.3.4 in /packages/noco-docs by @dependabot in #7934
• chore(renovate): Update patch (patch) by @renovate in #7959
• fix: Formula - RIGHT and LEFT methods argument type correction by @pranavxc in #7962
• Nc feat/form view builder field settings in right pannel and fixed column delete modal virtual cell icon issue by @rameshmane7218 in #7927
• Nc fix/form view typo mistak by @rameshmane7218 in #7972
• Nc Feat: Allow inline edit rich text field in form view by @rameshmane7218 in #7974
• Nc fix(nc-gui): allow copy paste email id from gmail in team & settings, for example, abc abc@gmail.com by @rameshmane7218 in #7963
• chore(renovate): Update dependency @unocss/nuxt to ^0.58.7 by @renovate in #7976
• test: change suite to emulate UI by @dstala in #7980
• Nc fix(nc-gui): Bug fixes by @rameshmane7218 in #7979
• Nc fix(nc-gui): prefill currency readonly field ui alignment issue by @rameshmane7218 in #7978
• fix: type issues with SqlClient by @mertmit in #7970
• New Crowdin updates by @o1lab in #7977
• chore(renovate): Update patch to ^10.3.6 (patch) by @renovate in #7982
• Nc fix(nc-gui): remove lookup cell chip min width fixed value by @rameshmane7218 in #7969
• Nc fix(nc-gui): Reduce gap between icons in rating field to fit 10 icons in default width of column by @rameshmane7218 in #7986
• fix typo by @fulldecent in #7988
• Nc docs/form view by @dstala in #7990
• Nc fix: add missing formula docs and link by @rameshmane7218 in #7987
• fix: shared form pw error handling by @mertmit in #7991
• New Crowdin updates by @o1lab in #7994
• fix: opt in to import.meta.* properties by @danielroe in #7983
• Enable calendar view by @pranavxc in https...

0.204.9

🐛 Closed Issues

• [closed] 🐛 Bug: Insert data API(v2) not returning proper response #7945
• [Status: Reproducible] 🐛 Bug: When editing a field name, the formula using it are updated, but the calculated value is ERR #7923
• [closed] 🐛 Bug: ctrl+click on base/table/view to open in new tab is not working in Window/Linux #7920
• [closed] 🔦 Feature: While editing webhook show bulk hooks in disabled state #7913
• [Status: Reproducible] 🐛 Bug: Attachment file names have redundant file extension if MIME type extension != existing file extension #7897
• [closed] Failed to resolve entry for package "nocodb-sdk"🐛 Bug: #7896
• [closed] 🐛 Bug: nocodb-sdk uses PUT instead of PATCH for api.dbDataTableRow.update #7886
• [🐛 Type: Bug] 🐛 Bug: form with default value configured for select field leads to error #7869
• [closed] Where should I modify the sorting data query logic in order to customize the sorting functionality? #7737

What's Changed

• Sync master with develop branch by @pranavxc in #7909
• Release 0.204.7 by @github-actions in #7911
• Nc option to block users by @pranavxc in #7917
• Post-release : Sync master with develop branch by @pranavxc in #7918
• Nc feat/one to one by @pranavxc in #7915
• Nc fix(nc-gui): Use control key instead of ctrl from useMagicKeys by @rameshmane7218 in #7921
• Nc fix: Form view bug fixes by @rameshmane7218 in #7899
• feat: errors v2 by @mertmit in #7916
• fix(nc-gui): Hide Members tab for base when user doesn't have newUser permission by @IFGGit in #7922
• New Crowdin updates by @o1lab in #7892
• Nc fix/links excluded list modal offset bug by @dstala in #7919
• Nc feat(nc-gui): disable webhook bulk events while editing webhook by @rameshmane7218 in #7914
• fix: formula error on field title update by @mertmit in #7924
• Nc fix(nc-gui): form attachment visibility issue on upload by @rameshmane7218 in #7929
• chore: increase timeout for running fe & be by @mertmit in #7928
• chore(renovate): Update patch (patch) by @renovate in #7905
• New Crowdin updates by @o1lab in #7930
• Sync master by @pranavxc in #7931
• 0.204.8 Pre-release by @github-actions in #7933
• Release 0.204.8 by @github-actions in #7935
• chore(renovate): Update patch to v0.204.8 (patch) by @renovate in #7936
• chore: update upgradeNocodbSdk script by @mertmit in #7940
• New Crowdin updates by @o1lab in #7944
• chore(renovate): Update patch (patch) by @renovate in #7937
• Post-release sync by @pranavxc in #7938
• chore: create PR for master sync after release by @mertmit in #7941
• fix: Use column title as alias in bulk insert return statement by @pranavxc in #7946
• 0.204.9 Pre-release by @github-actions in #7951

Full Changelog: 0.204.7...0.204.9

0.204.7: Bug Fix Release

🐛 Closed Issues

• [closed] 🐛 Bug: User permissions on base get reset #7902
• [closed] [Question] I want to understand how you used sheet js to build you smart sheet? #7893
• [closed] The interface in the controller always redirects to the login page. #7887
• [closed] NocoDB random table identifier on V2 API Spec #7879
• [closed] 🐛 Bug: multi field editor option colour change #7874
• [closed] 🐛 Bug: Roles other than superadmin don't have ability to edit own comment #7870
• [closed] 🔦 Feature: Swap keyboard shortcut for going to first and last pages #7853
• [closed] 🔦 Feature: Allow to set global default for interpreting LongText columns as Markdown ("rich text") #7832
• [Status: Reproducible] 🐛 Bug: bug with column edit when working with multi select field #7733
• [closed] 🐛 Bug: Unable to render this definition. The provided definition does not specify a valid version field. #7657
• [closed] 🐛 Bug: Record URL is broken #7453

What's Changed

• Release 0.204.5 by @github-actions in #7859
• chore: downgrade sqlite version for executable by @pranavxc in #7861
• Post-release master to develop sync by @pranavxc in #7862
• Tweak terminology by @salim-b in #7866
• New Crowdin updates by @o1lab in #7863
• Nc feat: Swap keyboard shortcut for going to first and last pages by @rameshmane7218 in #7865
• chore(deps): Add integrity for the xlsx tarball by @IFGGit in #7835
• fix(nocodb): comment update not working for roles other than superAdmin by @DarkPhoenix2704 in #7873
• Nc fix(nc-gui): select type fields default value update issue by @rameshmane7218 in #7864
• fix: api-snippet-v2 by @dstala in #7875
• feat(nc-gui): new share ui by @DarkPhoenix2704 in #7845
• fix(nc-gui): Hide Rename, Delete, Add record buttons when user doesn't have necessary permissions by @IFGGit in #7871
• Nc fix/scroll behavior by @dstala in #7889
• Revert "feat(nc-gui): new share ui" by @dstala in #7890
• Nc fix(nc-gui): MFE select field type options color change issue by @rameshmane7218 in #7891
• chore(deps): bump follow-redirects from 1.15.5 to 1.15.6 in /packages/noco-docs by @dependabot in #7883
• Document NC_MAX_ATTACHMENTS_ALLOWED by @salim-b in #7894
• fix(nc-gui): incorrect maxAttachmentSize by @wingkwong in #7900
• chore(renovate): Update patch (patch) by @renovate in #7831
• fix: Always store full version data of base-users in cache by @pranavxc in #7904
• Release 0.204.6 by @github-actions in #7907
• 0.204.7 Pre-release by @pranavxc in #7908

New Contributors

• @salim-b made their first contribution in #7866
• @IFGGit made their first contribution in #7835

Full Changelog: 0.204.5...0.204.7

0.204.5: Bug Fix Release

🐛 Closed Issues

• [closed] 🐛 Bug: Image display issue #7851
• [closed] 🐛 Bug: Creating a new table hangs if Default database is not visible #7850
• [closed] 🐛 Bug: typo in swagger response "BadReqeust" #7848
• [🐛 Type: Bug][Roadmap : Q1 2023] 🐛 Bug: Updating SQlite source path is not functioning as expected #7844
• [Status: Reproducible] 🐛 Bug: Form iFrames broken (403 Not Allowed) #7828
• [Status: Reproducible] 🐛 Bug: Use of CreatedAt filter #7826
• [closed] 📚 Doc: Edit this page links are broken #7816
• [closed] 🐛 Bug: Public form appears system field #7800
• [🐛 Type: Bug] 🐛 Bug: Long text wrap; show full word in first line if possible & then suffix ... #7781
• [closed] 🐛 Bug: shared survey form UI needs fix if form description is lengthy #7780
• [Status: Reproducible] 🐛 Bug: shuffle broken in 0.204.3 #7776
• [closed] 🐛 Bug: app.nocodb.com API limiting to 100 rows even when limit set higher #7761
• [closed] 🔦 Feature: if nocodb alternative to airtable, why don't we design initiative better ui/ux than airtable? #7700
• [closed] 🐛 Bug: Submit attachment in form does not working #7699
• [closed] 🔦 Feature: Add to context menu, open in new tab #7693
• [Status: Reproducible] 🐛 Bug: Pagination skips record in Link Records modal #7655
• [closed] 🔦 Feature: Add URL encode function for formulas #6811
• [🔦 Type: Feature][🔭 Scope : Project] [Feature] Prefill form with default values #2862

What's Changed

• Release 0.204.4 by @github-actions in #7789
• fix(docs): related topics links in table operations by @wingkwong in #7784
• Chore/sync main to dev by @pranavxc in #7792
• fix: keep hidden fields on undo by @dstala in #7779
• New Crowdin updates by @o1lab in #7794
• chore(renovate): Update dependency nocodb to v0.204.4 by @renovate in #7791
• feat(nc-gui): Calendar Year View Updates by @DarkPhoenix2704 in #7734
• chore(deps): sync dependencies by @wingkwong in #7797
• refactor: move query param check to a common function by @dstala in #7795
• fix: Remove invalid comma in swagger json by @pranavxc in #7798
• fix: Remove invalid character from swagger json by @pranavxc in #7799
• fix: handle if error is undefined/null in ErrorBoundary component by @pranavxc in #7802
• refactor: show body tab for customization by @dstala in #7790
• feat(nc-gui): new field icons by @dstala in #7803
• fix(nc-gui): update system icons by @DarkPhoenix2704 in #7804
• chore(renovate): Update minor (minor) by @renovate in #6999
• feat(nc-gui): refined ranges support & end Date for Date Field by @DarkPhoenix2704 in #7753
• chore(renovate): Update patch (patch) by @renovate in #7805
• chore(renovate): Update dependency @iconify-json/lucide to ^1.1.172 by @renovate in #7812
• Nc fix(docs): Update broken edit this page link by @rameshmane7218 in #7817
• chore(renovate): Update dependency nodemailer to ^6.9.12 by @renovate in #7821
• Nc fix(nc-gui): long text field UI changes by @rameshmane7218 in #7824
• Nc feat: Prefill shared form by query params by @rameshmane7218 in #7786
• New Crowdin updates by @o1lab in #7827
• Nc fix(nc-gui): Incorrect route when navigating to view after visiting base members page by @rameshmane7218 in #7822
• New Crowdin updates by @o1lab in #7829
• Nc fix/auto collapse sidebar base table by @rameshmane7218 in #7820
• fix: add timeout to webhook calls by @mertmit in #7830
• fix: support Date filter operations in where query params for Created… by @dstala in #7834
• Nc feat(nc-gui): open base/table/view in a new tab on pressing Ctrl & clicking on them by @rameshmane7218 in #7818
• fix: duplicate base/model by @mertmit in #7823
• fix(nc-gui): lint by @DarkPhoenix2704 in #7836
• Nc fix(nc-gui): row height menu dropdown ui changes by @rameshmane7218 in #7839
• fix: missing calendar optmzin on oss by @DarkPhoenix2704 in #7838
• fix: allow shared form in iframe by @dstala in #7840
• Nc fix/7808 column reorder by @dstala in #7837
• Add support for URLENCODE function by @mitya57 in #6831
• Nc feat: Color option for Base logo by @rameshmane7218 in #7807
• feat: base level share by @DarkPhoenix2704 in #7833
• New Crowdin updates by @o1lab in #7846
• New Crowdin updates by @o1lab in #7852
• fix(nc-gui): Update offset of LinkedRecords in accordance with links and unlinks by @DarkPhoenix2704 in #7841
• Nc fix/browser console warnings by @dstala in #7855
• fix: disable default source menu/action options if it's disabled by @dstala in #7854
• docs: Correct typo in swagger response definition by @iron3oxide in #7849
• fix: Sync both filename and connection.filename when updating SQLite datasource by @pranavxc in #7856
• Nc feat/survey form v2 by @rameshmane7218 in #7843
• fix(nc-gui): lint errors by @rameshmane7218 in #7857
• 0.204.5 Pre-release by @github-actions in #7858

New Contributors

• @mitya57 made their first contribution in #6831
• @iron3oxide made their first contribution in #7849

Full Changelog: 0.204.4...0.204.5

0.204.4

🐛 Closed Issues

• [closed] 🐛 Bug: Export CSV is missing the id or primary keys (cloud) #7749
• [closed] 🐛 Bug: Unable to add new record to linked table by "add new link" #7748
• [Status: Reproducible] 🐛 Bug: datetime copy paste bug #7739
• [closed] 🐛 Bug: Sometimes unable to delete fields #7715
• [closed] 🔦 Feature: Reset form in less than 5 seconds #7711
• [closed] 🐛 Bug: Duplicating a form view only adds fields; all other form and field configurations are missing. #7686
• [closed] 🐛 Bug: Form field order is different in backend than in the public view #7671
• [closed] 🐛 Bug: modified row height, double click to switch to edit mode doesn't work #7658
• [closed] 🐛 Bug: MySQL Server Created-at, Updated-at issue #7585
• [closed] 🐛 Bug: meta db tables are not listed after connecting to external data source #7771
• [Status: Reproducible] 🐛 Bug: If you remove a user from a base, you can't easily re-add them #7775
• [closed] 🐛 Bug: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? After upgrade to 0.204.1 (and .2) #7770
• [closed] 🐛 Bug: Form view TBD-3 #7701
• [🔎 Status: More Info Needed] 🐛 Bug: file attachment didnt attached while sending it with a form #7507
• [📞 Status: Need Internal Discussion] 🐛 Bug: Undo doesn't cover hidden fields #7363

What's Changed

• Release 0.204.1 by @github-actions in #7708
• Post-release sync by @pranavxc in #7710
• Nc fix: URL and LongText cell double click edit enable issue by @rameshmane7218 in #7703
• Nc feat/form view tbd 1 by @rameshmane7218 in #7717
• fix(nc-gui): file-saver import issue by @rameshmane7218 in #7718
• Nc fix: column delete issue due to incorrect switch break statement in column delete service by @rameshmane7218 in #7722
• New Crowdin updates by @o1lab in #7697
• fix: cache del and update by @mertmit in #7727
• Nc feat/form view tbd 2 by @rameshmane7218 in #7729
• feat(nc-gui): calendar field customization by @DarkPhoenix2704 in #7673
• New Crowdin updates by @o1lab in #7736
• chore(renovate): Security update Update dependency nodemailer to v6.9.9 [SECURITY] by @renovate in #7723
• feat(nc-gui): calendar drag-drop granularity by @DarkPhoenix2704 in #7731
• chore(renovate): Update patch (patch) by @renovate in #7647
• chore(deps): update package-lock.json in noco-docs by @wingkwong in #7746
• fix: nestjs issues by @mertmit in #7745
• fix: wrong usage of deepDel by @dstala in #7747
• fix: various small issues by @mertmit in #7750
• chore(deps-dev): bump vite from 4.5.1 to 4.5.2 by @dependabot in #7744
• Nc test/filter leap year fix by @dstala in #7752
• chore(renovate): Security update Update dependency nodemailer to v6.9.9 [SECURITY] by @renovate in #7742
• fix(nc-gui): unable to add new record to linked table by add new link by @rameshmane7218 in #7751
• chore(renovate): Update patch (patch) by @renovate in #7743
• fix(nc-gui): invalid docs link by @rameshmane7218 in #7757
• Nc fix: add support to copy paste date and dateTime with unknown format by @rameshmane7218 in #7759
• fix: issue with attachment upload by @mertmit in #7756
• docs: update documentation links by @wingkwong in #7754
• chore(renovate): Update patch (patch) by @renovate in #7758
• 0.204.2 Pre-release by @github-actions in #7762
• Release 0.204.2 by @github-actions in #7763
• Chore/executable build bug by @pranavxc in #7766
• Post-release sync by @pranavxc in #7767
• fix: Multi-source table list cache issue by @pranavxc in #7772
• 0.204.3 Pre-release by @github-actions in #7773
• Release 0.204.3 by @github-actions in #7774
• docs: webhook image fix by @dstala in #7769
• fix: clear list on user delete to refresh inheritance by @mertmit in #7778
• ix: SQLite - upgrader timeout bug by @pranavxc in #7777
• Nc fix: add missing signedPath or signedUrl in form attachements by @rameshmane7218 in #7768
• Nc feat/form view tbd 3 by @rameshmane7218 in #7741
• New Crowdin updates by @o1lab in #7782
• chore(renovate): Update patch (patch) by @renovate in #7764
• chore(renovate): Update patch (patch) by @renovate in #7785
• feat(nocodb): calendar data apis by @DarkPhoenix2704 in #7716
• fix: Handle group by load method exceptions by @pranavxc in #7787
• 0.204.4 Pre-release by @github-actions in #7788

Full Changelog: 0.204.1...0.204.4

0.204.1: Bug Fix Release

🐛 Closed Issues

• [closed] 🐛 Bug: In development environment FileSaver.saveAs is not a function on trying to download view #7702
• [closed] 🐛 Bug: Adding a new field from the multifield editor is, by default, displayed in all views #7684
• [Status: Reproducible] 🐛 Bug: Have to double-click on rich text field in a public form to add text, backend field name is displayed #7668
• [closed] 🐛 Bug: CSS issue with Form Text (word breaks) #7667
• [closed] 🔦 Feature: Create Nocodb template under dooqod.com #7660
• [closed] 🐛 Bug: build-local-docker-image.sh not working #7642
• [closed] 🐛 Bug: Composite primary key row insertion error #7626
• [closed] 🐛 Bug: Sort from field context menu doesn't work (if applied before using sort from toolbar) #7609
• [closed] 🐛 Bug: The attachment cell does not allow adding another file if the file name already exists. #7601
• [closed] 🔦 Feature: Drag and drop image from webpage to attachment cell #7598
• [closed] 🐛 Bug: CmdL UI/UX changes #7592
• [closed] 🐛 Bug: Base reorder in Mobile View #7582
• [closed] 🐛 Bug: User has the access to rename, duplicate and delete view from breadcrumb in shared base #7572
• [closed] 🐛 Bug: The UI breaks when navigating between the base, table, and view through the breadcrumb in the shared base #7571
• [closed] 🐛 Bug: TypeError: e.isAuthenticated is not a function (backend) #7567
• [closed] 🐛 Bug: Minor UI changes #7565
• [closed] 🐛 Bug: Cmd+J is not working in oss #7563
• [closed] 🐛 Bug: ERROR: Offset is beyond the total number of records #7561
• [closed] 🐛 Bug: copy paste on dateTime field with formatting applied #7557
• [closed] 🐛 Bug: copy paste on date field with formatting applied #7552
• [closed] 🐛 Bug: Row creation issue when connecting to external MariaDB database #7550
• [closed] 🐛 Bug: Organization Level Creator can change their own role, leading to loss of Creator Access #7539
• [closed] 🔦 Feature: Base reorder #7536
• [closed] 🐛 Bug: VIEWER can't receive form e-mail notifications #7535
• [closed] 🐛 Bug: Base page doesn't show table icons #7533
• [closed] 🐛 Bug: Tabbing in the 'Add New Link' page doesn't select the record components #7520
• [closed] 🔦 Feature: Keyboard interactions on tables: new rows #7519
• [closed] 🐛 Bug: Auto focus the search field in the 'Add New Link' form #7518
• [closed] this issue is not closed. #7515
• [closed] 🐛 Bug: webhook trigger on triggering delete of selected records #7511
• [closed] 🐛 Bug: When searching for a non-existant entry it is fine on page 1 of tables but shows"internal error" when doing the same in any other page number. #7501
• [closed] 🔦 Feature: Copying links #7493
• [closed] 🔦 Feature: Enable keyboard shortcuts for oss (cmd+k, cmd+l, cmd+j) #7486
• [closed] Pricing #7483
• [closed] 🐛 Bug: In shared view expanded form after clicking reload api is failing #7468
• [closed] 🐛 Bug: Error when adding sort / filter #7460
• [closed] 🐛 Bug: Shared base and shared view expanded form #7456
• [closed] 🐛 Bug: Kanban view loadMoreKanbanData api is failing due to incorrect offset payload #7451
• [closed] 🐛 Bug: In shared kanban view expanded form all field values are empty #7448
• [Status: Reproducible] 🐛 Bug: Renaming of Belongs To column #7441
• [Status: Reproducible] 🐛 Bug: SUBSTR({Date Field}, idx, idx) not working anymore. #7440
• [closed] 🔦 Feature: Allow to @ or @@ other team members and show as notication or email. #7430
• [closed] 🐛 Bug: field newly added should be hidden by default in existing views (Link field) #7421
• [closed] 🐛 Bug: Audit log, not possible to know who is the user #7418
• [closed] 🐛 Bug: Currency field not updating on Safari #7415
• [closed] 🐛 Bug: Drag 'n Drop columns not working on Safari #7414
• [Status: Reproducible] 🐛 Bug: Invalid formula IF ... == TRUE() or FALSE() #7399
• [closed] 🐛 Bug: Filter type related errors #7396
• [closed] 🐛 Bug: GUI does not save custom order of Table Views #7395
• [closed] 🐛 Bug: No playwright test cases for Multifield Editor #7393
• [closed] 🐛 Bug: In GUI only first 20 items of Single Select and Multi-Select fields can be seen or edited/deleted #7390
• [🐹 DB : SQLite] 🐛 Bug: Groupby doesn't work on formula fields with numbers #7382
• [closed] 🔦 Feature: Bulk delete selected rows #7379
• [Status: Reproducible] 🐛 Bug: API V2 - when Page Size > Total Records returned, API response contains incorrect page size and isLastpage values #7368
• [Status: Reproducible] 🐛 Bug: API V2 "Offset is beyond the total number of records" error status code returned is 200 instead of 400 #7367
• [closed] 🐛 Bug: webhook conditions for date field need fix #7360
• [closed] 🐛 Bug: Rich text & long text modal UX #7359
• [closed] 🐛 Bug: Currency datatype keeps changing to SpecificDBType automatically #7315
• [🙋‍♀️ Type: Question] 🐛 Bug: Webhooks with new conditions checker #7312
• [closed] 🐛 Bug: Toggle Show NULL in Cellsremoves table/schema editor access #7295
• [closed] 🐛 Bug: Grouping by lookup column does not display the group name #7226
• [🐛 Type: Bug] 🐛 Bug: date cell copy paste related #7183
• [closed] 🐛 Bug: Audit log for external database not visible through UI #7165
• [closed] 🐛 Bug: Shared gallery view, click on any record #7145
• [closed] 🐛 Bug: OTP not sending Email #7129
• [closed] 🐛 Bug: select field issue with trailing spaces when creating using API #7087
• [👩‍🔬 Status: In-Analysis] 🐛 Bug: Tasks disappearing from view on status change #7051
• [🔎 Status: More Info Needed] 🐛 Bug: Import Excel date field gives the wrong dates for column #7049
• [🐛 Type: Bug] 🐛 Bug: Currency field updation not reflecting to external postgres DB #6255
• [🐛 Type: Bug] 🐛 Bug: Values in currency fields are not saved [Firefox] #6086
• [closed] 🔦 Feature: Use value of formula in lookups #5986
• [closed] Feature: Global search should include all fields by default #5970
• [Status: Reproducible] 🔦 Feature: Pressing tab while on a form should move the cursor to the next field #5969
• [closed] 🔦 Feature: Expand record option for shared view #5945
• [closed] 🔦 Feature: formula column filter type support based on form...

0.204.0: Really exciting update: We are introducing 4 new fields!

👋👋 Hey Everybody, Hey Everybody! 👋👋

🚀 A Really Exciting Update! We are introducing FOUR new fields.

❗Upgrade note : Refer to upgrade notes at the end please

Introducing "Created By" and "Last Modified By" Fields!

Imagine a world of possibilities where your data is not just a set of numbers and text, but a tapestry of creators and curators! With our latest feature, NocoDB is taking your data to a new level. 🌟

👩‍💻 Use Case 1: Enhanced Accountability 👨‍💻

Have you ever wondered who created that critical entry in your database? With the "Created By" field, you can now instantly trace the mastermind behind each record. 🕵️‍♀️ This is invaluable for tracking changes, ensuring accountability, and knowing who to reach out to when questions arise.

📆 Use Case 2: History Made Easy 📆

Every change counts, and with the "Last Modified By" field, you'll have a play-by-play of who edited your data and when. 📚 No more guesswork! This is your backstage pass to tracking data history effortlessly.

👩‍🔬 Use Case 3: Collaborative Data Magic 👨‍🔬

In a world of teamwork and collaboration, these fields become your secret sauce for smooth operations. Imagine seamlessly working together on a project, knowing who's behind each data move. 💪

⚡️ Use Case 4: Powering Trust and Transparency ⚡️

Boost trust and transparency in your organization by showing your stakeholders that you've got a grip on your data. 💼 With "Created By" and "Last Modified By," you can confidently showcase your commitment to data governance.

Stay on top of all data mysteries. 🌐✨

Introducing "Created At" and "Last Modified At" Fields!

NocoDB is thrilled to introduce the "Created At" and "Updated At" fields to supercharge your data management. 🌟

📅 Use Case 1: Timestamping all records 📅

With the "Created At" field, you'll know precisely when each record was born, down to the second. 🕒 It's perfect for tracking the age of your data and identifying trends over time. 📈

🔄 Use Case 2: Real-Time Updates 🔄

"Updated At" is your dynamic ally. It records the exact moment a record was last modified, keeping you in sync with the latest changes. 🚀 No more wondering if your data is up-to-date!

Please note Created At and Updated At existed as default fields as date time values from day 1 of NocoDB. However, from this version these will be new fields that you could add to any new table (even multiple times).

---

❗Upgrade note

This upgrade may take time depending on the number of bases and tables. We've added 4 new default fields (Create By, Last Modified By, Created At, Updated At) to each table. You can monitor the upgrade progress in the logs and please be patient.

New Fields Upgarde behavior:

• Bases (Default Database): All tables will have these new fields. New tables created in this version will also have them.
• Bases with External Databases:
  • Existing tables: Default fields are NOT created. You can manually create them if needed.
  • New tables: These fields will be created if you create new tables.

Closed Issues

• [closed] 🐛 Bug: newest dev build 0.203.2-20240108-0603 not working #7387
• [🐛 Type: Bug] 🐛 Bug: time format not matched in UI and API #7385
• [closed] 🐛 Bug: In multifield editor updated field changes are not reflected until page reload #7365
• [closed] 🐛 Bug: In links field list item dateTime & Time field display value is not displayed as cell display #7354
• [closed] 🐛 Bug: Group by header height changes with row height configuration (lookup field) #7353
• [closed] 🐛 Bug: Validation is broken on URL column #7349
• [closed] 🐛 Bug: NULL display in cell isn't uniform #7344
• [closed] 🐛 Bug: getaddrinfo ENOTFOUND host.docker.internal #7340
• [closed] 🐛 Bug: Select field while it is updating the data, the changes are not being visually displayed. #7334
• [closed] 🐛 Bug: Updating to the latest version overwrites fields with the NOW() formula #7332
• [closed] 🐛 Bug: some of the field types when used as display value- text is not rendered in blue #7301
• [closed] 🐛 Bug: select multiple cells, clear - related formula column's data doesn't reload automatically #7296
• [closed] 🔦 Feature: Login options #7292
• [closed] 🔦 Feature: use chart-js #7283
• [Status: Reproducible] 🐛 Bug: Expanded view: LongText got cleared when adding/removing links #7257
• [closed] 🔦 Feature: Sort for user management #7254
• [closed] 🔦 Feature: Expand viewable SingleSelect area #7236
• [🐛 Type: Bug] 🐛 Bug: Formula IF is null not working #4678

0.203.2: Bug Fix Release

What's Changed

• [🐛 Type: Bug] 🐛 Bug: SUBSTR not working after updating #7324
• [closed] 🐛 Bug: richtext- underline & strikethrough formatting doesn't persist #7318
• [closed] 🐛 Bug: Expanded record UX #7172

What's Changed

• Release 0.203.0 by @github-actions in #7309
• Use different name for upload artifact to avoid conflict by @pranavxc in #7310
• Merge pull request #7310 from nocodb/develop by @pranavxc in #7311
• fix: shared form user field by @mertmit in #7316
• New Crowdin updates by @o1lab in #7319
• fix: strike and underline for rich text by @dstala in #7320
• fix: select default user playwright test fail issue by @rameshmane7218 in #7326
• Fix/expanded record ux by @rameshmane7218 in #7298
• fix: Formula validation correction by @pranavxc in #7329
• 0.203.1 Pre-release by @github-actions in #7330
• Release 0.203.1 by @github-actions in #7331
• fix: Broken logo in Signin/Signup page by @pranavxc in #7333
• fix: Use withDefaults for setting default prop value by @pranavxc in #7335
• 0.203.2 Pre-release by @github-actions in #7336

Full Changelog: 0.203.0...0.203.2

0.203.0: Introducing User field & RichText field

👋👋 Hey Everybody, Hey Everybody! 👋👋

We are excited to present our latest release, packed with highly anticipated features. Let's explore the new additions.

🥬 What's new .. What's fresh ?

🌟 User fields

• Streamlined Collaboration: Effortlessly assign and track users within your workspace. Enhance team collaboration by associating specific records with the individuals responsible, creating a seamless flow.
• Efficient Task Assignment: Assign one or more members of your team to a specific record, thus providing a clear and organised way to distribute responsibilities among team members.
• Enhanced Data Insights: Leverage the User Field to gain deeper insights into your data - filter, sort or group records over user field. Whether you're tracking project contributions, managing client relationships, or monitoring team activities, these additional provisions provides a comprehensive view of user involvement across your workspace.

🌟 RichText fields

Now, you can go beyond simple text entries and add a touch of style and structure to your data.

• Text Formatting : Bold, Italics, Underline, Strikethrough
• Lists for Organisation : Numbered, Unordered, Tasks
• Headings: Structure your content with three levels of headings for a clear hierarchy.
  - Markdown Syntax Support: Leverage the power of Markdown syntax alongside our rich text editor. Use familiar shortcuts for quick and efficient text formatting.

Other major changes

Formula

• More formula functions supported
• Use of rollup within formula is now supported
• Use of formula results to build another formula is now enhanced

Webhook update trigger (conditional)

• The update trigger with conditions activates upon a record meeting the specified condition for a webhook configuration. The trigger does not activate based on records that already meet the conditions; instead, it requires a change in the state of the records to trigger the associated automation.

---

On behalf of the entire Team at NocoDB, we extend our warmest wishes to you for a joyous and festive Christmas season.

We appreciate the collaboration and support we've received from you throughout the year, and we are excited about the possibilities that lie ahead. Your continued support has been instrumental in our success, and we are truly grateful for the trust you have placed in NocoDB.

We are also thrilled to introduce the newest member of our NocoDB family - our official mascot, the Snow Leopard!

Now, we're turning to you, our incredible community, to help us give our Snow Leopard a name that captures its essence. We invite you to share your creativity and suggest a fitting name for our mascot.

-- Happy Holidays from Team NocoDB

---

Closed Issues

• [closed] 🐛 Bug: SQLite DB, formula NOW() returns only date #7303
• [🐛 Type: Bug] 🐛 Bug: Cannot destructure property 'options' of 'object null' as it is null #7284
• [Status: Reproducible] 🐛 Bug: Cannot use nocodb after signing up for a free account #7282
• [closed] 🐛 Bug: Cannot access delete workspace button on small screens | NocoDB Cloud #7275
• [Status: Reproducible] 🐛 Bug: V2 API returns wrong status code and message combination on 401 and 403 #7272
• [closed] 🐛 Bug: Minor UI fixes #7271
• [closed] 🔦 Feature: Browse documentation easily #7267
• [closed] 🔦 Feature: Search feature for publicly shared view #7265
• [closed] 🐛 Bug: V2 API - Impossible to unlink records - always "invalid input syntax for type integer" error #7262
• [closed] 🐛 Bug: Rich text cell, first character during transition from select mode to edit mode is lost #7261
• [closed] Upgrading without NC_AUTH_JWT_SECRET set #7258
• [closed] 🐛 Bug: Webhook triggered by complicated formula multiple times before value was committed #7256
• [closed] 🐛 Bug: Checkbox, Barcode cells are not aligning properly when the row height changes. #7253
• [🦭 DB : MariaDB] 🐛 Bug: Duplicate table/base fails for MariaDB #7231
• [closed] 🐛 Bug: Subsequent Longtext fields are distorted in Gallery or Kanban view #7227
• [closed] 🐛 Bug: excel import error #7211
• [closed] 🐛 Bug: UI/UX fixes - 2 #7210
• [closed] 🐛 Bug: column datatype not changing from SingleLineText to Number #7188
• [🔎 Status: More Info Needed] 🔦 Feature: Filter Days now uniformly utilizes 'datetime' for all calculations. #7176
• [closed] 🐛 Bug: [UI] hover effect in dropdown's #7135
• [closed] 🐛 Bug: formula related #7126
• [closed] 🐛 Bug: Upgrading from 0.105.1 to latest fails #7075
• [closed] 🐛 Bug: Documentation for RichText #7073
• [closed] 🔦 Feature: SEARCH function should support searching from the end #6448
• [closed] 🐛 Bug: insufficient and incorrect documentation for /auth/token/refresh endpoint #6078
• [closed] 🔦 Feature: Formula MONTH() to extract month from a date #5297
• [🔦 Type: Feature] 🔦 Feature: Modify Field after Webhook "After Update" #4130
• [🔦 Type: Feature][🍰 Scope : Column] [Feature] Add DATE() function for formulas #2605
• [🔦 Type: Feature][🍰 Scope : Column] [Feature] Collaborator field (Link to User) #2382
• [🔦 Type: Feature][🍰 Scope : Column] 🔦 Feature: Add quarter formula function #918

What's Changed

• Release 0.202.10 by @github-actions in #7223
• fix : fixed table cell overflow in uploadExcel Model by @musharaf-nocodb in #7221
• fix : insufficient and incorrect documentation for /auth/token/refresh endpoint by @aashishagrawall in #7095
• fix: Mysql - If buffer type convert to hex value and convert to int only if type is bit by @pranavxc in #7224
• fix: Miscellaneous ui errors by @pranavxc in #7230
• fix: support function calls for default timestamp by @mertmit in #7232
• fix: append before getList by @mertmit in #7234
• chore(renovate): Update patch (patch) by @renovate in #7216
• fix: poll plugin by @mertmit in #7248
• fix: selector and css by @mertmit in #7250
• New Crowdin updates by @o1lab in #7251
• fix: clear fill handle properly on expanded form close by @mertmit in #7260
• Nc feat/webhook conditions by @dstala in #7246
• fix: rich text first char issue by @dstala in #7266
• UI/UX fixes - 2 by @rameshmane7218 in #7218
• Updates to Uffizzi Deployment Workflow. by @axisofentropy in #7269
• Formula type extraction and improvements by @pranavxc in #7268
• fix: Has-many unlink api - accept array of object with primary key by @pranavxc in #7274
• feat: user field by @mertmit in #7202
• pw formula tests, check formula not supported error by @starbirdtech383 in #7273
• fix: Formula followup bugs by @pranavxc in #7279
• Nc fix/tab focus by @dstala in #7280
• fix: Increased min height and added scroll for long text in expanded … by @dstala in #7243
• Nc fix/formula revamp by @dstala in #7281
• fix: Update dtxs when decimal precision is changing by @pranavxc in #7278
• fix(nocodb): 403 forbidden message by @wingkwong in #7285
• Nc fix/UI ux fixes by @rameshmane7218 in #7286
• Nc fix/formula fixes by @dstala in #7288
• minor bug fixes by @rameshmane7218 in https://githu...