NocoDB: 0.262.2: Bug Fix Release

## 🐛 Closed Issues - [**closed**] 🐛 Bug: Row Filtered Creates Row Artifact/Ghost [#10758](https://github.com/nocodb/nocodb/issues/10758) - [**closed**] 🐛 Bug: upload a csv file in existing table with FK fields to other [#10754](https://github.com/nocodb/nocodb/issues/10754) - [**🐛 Type: Bug**][**Status: Reproducible**] 🐛 Bug: Error "FilterChildrenList" - Editor users not allowed to use filter groups. [#10741](https://github.com/nocodb/nocodb/issues/10741) - [**closed**] 🐛 Bug: Date-Time Lookup Field Displays Incorrect Time && Format difference in lookup [#10736](https://github.com/nocodb/nocodb/issues/10736) - [**closed**] 🐛 Bug: Upload csv / excel sometimes stuck on loading [#10713](https://github.com/nocodb/nocodb/issues/10713) - [**🐛 Type: Bug**] 🐛 Bug: Images are not showed on grid view [#10712](https://github.com/nocodb/nocodb/issues/10712) - [**closed**] 🐛 Bug: if i make a lookup column where the "lookup field" is a link, it doesn't show in the grid view [#10710](https://github.com/nocodb/nocodb/issues/10710) - [**closed**] 🐛 Bug: Upload CSV failing to import the file: `document.fonts.values() is not iterable` [#10709](https://github.com/nocodb/nocodb/issues/10709) - [**closed**] 🐛 Bug: Syntax error in REGEX_REPLACE causes Table to completely CRASH & Cannot Export CSV [#10708](https://github.com/nocodb/nocodb/issues/10708) - [**🐛 Type: Bug**] 🐛 Bug: Image Preview Crops to Square Instead of Maintaining Aspect Ratio [#10702](https://github.com/nocodb/nocodb/issues/10702) - [**closed**] 🐛 Bug: audit log do not retrieved correctly for composite pk [#10700](https://github.com/nocodb/nocodb/issues/10700) - [**closed**] 🐛 Bug: URL formatted formula field does not open URL on click in grid view [#10697](https://github.com/nocodb/nocodb/issues/10697) - [**closed**] 🐛 Bug: Audit log for update do not recorder for external connection [#10691](https://github.com/nocodb/nocodb/issues/10691) - [**closed**] 🐛 Bug: error "No record found" [#10689](https://github.com/nocodb/nocodb/issues/10689) - [**closed**] 🐛 Bug: has-many self link, unable to create BT relation [#10688](https://github.com/nocodb/nocodb/issues/10688) - [**closed**] 🐛 Bug: No auto attribution of columns if special characters when importing from file [#10686](https://github.com/nocodb/nocodb/issues/10686) - [**🔎 Status: More Info Needed**] Feature Request: Better Error Message for Importing Data into Existing Table with Single Select Field Containing Undefined Choice (Impossible to import any csv, xlsx or ods file if not) [#10685](https://github.com/nocodb/nocodb/issues/10685) - [**closed**] how to change language? help wanted [#10675](https://github.com/nocodb/nocodb/issues/10675) - [**closed**] 🐛 Bug: links no records linked [#10665](https://github.com/nocodb/nocodb/issues/10665) - [**Status: Not Reproducible**] 🐛 Bug: duplicating a project ends with error and all of the views are lost [#10657](https://github.com/nocodb/nocodb/issues/10657) - [**closed**] 🐛 Bug: Webhook condition with "is blank" on a User-type field fails to trigger. [#10655](https://github.com/nocodb/nocodb/issues/10655) - [**Status: Reproducible**] 🐛 Bug: Geo Input field is NOT working in Form [#10650](https://github.com/nocodb/nocodb/issues/10650) - [**closed**] 🐛 Bug: In expanded record from kanban view - unable to save edited data (for editor role) [#10614](https://github.com/nocodb/nocodb/issues/10614) - [**closed**] 🔦 Feature: Support for Handlebars Helpers (e.g., eq) in Webhooks and Other Features [#10534](https://github.com/nocodb/nocodb/issues/10534) - [**Status: Not Reproducible**] 🐛 Bug: Kanban view expand record order [#10521](https://github.com/nocodb/nocodb/issues/10521) - [**🐛 Type: Bug**] 🐛 Bug: blank / empty filter error on json field [#10452](https://github.com/nocodb/nocodb/issues/10452) - [**Status: Reproducible**] 🐛 Bug: Failing xls/csv imports [#10421](https://github.com/nocodb/nocodb/issues/10421) - [**closed**] 🐛 Bug: Parentheses support in where query param [#10385](https://github.com/nocodb/nocodb/issues/10385) - [**Status: Reproducible**] 🐛 Bug: Currency numbers are not formatted correctly when displayed on the card. [#10298](https://github.com/nocodb/nocodb/issues/10298) - [**🐛 Type: Bug**] 🐛 Bug: Rows Inserted via REST API Not Visible in Kanban View [#10057](https://github.com/nocodb/nocodb/issues/10057) - [**🔦 Type: Feature**] 🔦 Feature: Want to paste Google Map geo data to geo data column directly. [#9908](https://github.com/nocodb/nocodb/issues/9908) - [**🐛 Type: Bug**][**Status: Reproducible**] 🐛 Bug: SUM fails if field is blank [#9876](https://github.com/nocodb/nocodb/issues/9876) - [**🐛 Type: Bug**] 🐛 Bug: (ExternalDB) PDF attachments served from s3 have wrong domain configured in nocodb cloud [#9821](https://github.com/nocodb/nocodb/issues/9821) - [**🐛 Type: Bug**] 🐛 Bug: Inquiry Regarding Data Import Issue for Existing Table [#9814](https://github.com/nocodb/nocodb/issues/9814) - [**🐛 Type: Bug**] 🐛 Bug: Allow expand cell option for formula field when content length is more [#9564](https://github.com/nocodb/nocodb/issues/9564) - [**🐛 Type: Bug**] 🐛 Bug: limit ignored in api [#9513](https://github.com/nocodb/nocodb/issues/9513) - [**🐛 Type: Bug**] 🐛 Bug: "Records to link" not showing details in forms [#9347](https://github.com/nocodb/nocodb/issues/9347) - [**🐛 Type: Bug**] 🐛 Bug: Forms autoconvert markdown but won't parse code blocks [#9172](https://github.com/nocodb/nocodb/issues/9172) - [**🔦 Type: Feature**] 🔦 Feature: Use "created time" and "last modified time" in Rollup [#9114](https://github.com/nocodb/nocodb/issues/9114) - [**closed**] Nested logic as query parameter [#8835](https://github.com/nocodb/nocodb/issues/8835) - [**closed**] 🔦 Feature: Convert Formula column to other type [#7639](https://github.com/nocodb/nocodb/issues/7639) - [**closed**] 🐛 Bug: Export to Excel via API [#7215](https://github.com/nocodb/nocodb/issues/7215) - [**Status: Reproducible**] 🐛 Bug: inserting links with sort enabled for lookup [#7185](https://github.com/nocodb/nocodb/issues/7185) - [**closed**] 🐛 Bug: The response view does not see a pagination bar on Android's Edge [#7042](https://github.com/nocodb/nocodb/issues/7042) - [**🏗️ Status: In Resolution**][**🌞 Scope : Data source**] 🐛 Bug: Expanded view is empty [#6682](https://github.com/nocodb/nocodb/issues/6682) - [**closed**] 🐛 Bug: Connection terminated [#5417](https://github.com/nocodb/nocodb/issues/5417) ## What's Changed * fix: Prevent sum from failing if field is blank by @Bchenjamin in https://github.com/nocodb/nocodb/pull/9977 * chore(deps): bump path-to-regexp and express in /packages/nc-cli by @dependabot in https://github.com/nocodb/nocodb/pull/10001 * Release 0.262.1 by @github-actions in https://github.com/nocodb/nocodb/pull/10647 * chore: post-release sync by @github-actions in https://github.com/nocodb/nocodb/pull/10648 * Formula builder type corrections by @pranavxc in https://github.com/nocodb/nocodb/pull/10649 * chore: bump deps by @mertmit in https://github.com/nocodb/nocodb/pull/10646 * Nc fix(nc-gui): remove link mark on adding space at the end by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10654 * fix: geodata form input broken by @dstala in https://github.com/nocodb/nocodb/pull/10653 * fix user blank not working in webhook by @dstala in https://github.com/nocodb/nocodb/pull/10658 * fix: signed url not working for s3 based providers by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10651 * Nc feat: figma css variables by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10660 * set default dt for each imported column if not exists by @fendy3002 in https://github.com/nocodb/nocodb/pull/10661 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/10656 * feat(nix/docker/aio/ssl): support for adhoc certs by @sinanmohd in https://github.com/nocodb/nocodb/pull/10666 * feat: badged formula lookup by @dstala in https://github.com/nocodb/nocodb/pull/10664 * fix: rich text font weight by @dstala in https://github.com/nocodb/nocodb/pull/10663 * fix: formula URL format click by @mertmit in https://github.com/nocodb/nocodb/pull/10673 * feat: sync fw by @mertmit in https://github.com/nocodb/nocodb/pull/10671 * fix: excel export using api by @fendy3002 in https://github.com/nocodb/nocodb/pull/10644 * Nc fix prod issues by @dstala in https://github.com/nocodb/nocodb/pull/10674 * Nc feat/linked fields page designer by @AmitJoki in https://github.com/nocodb/nocodb/pull/10676 * feat (nocodb): add handlebar helpers to webhook template by @fendy3002 in https://github.com/nocodb/nocodb/pull/10629 * fix: add validation for ? and $ symbol in table name #4564 by @fendy3002 in https://github.com/nocodb/nocodb/pull/10626 * Nc fix/extension cleanup by @dstala in https://github.com/nocodb/nocodb/pull/10679 * fix: ltar follow model / view sort by @fendy3002 in https://github.com/nocodb/nocodb/pull/10680 * Nc feat/query filter parser by @dstala in https://github.com/nocodb/nocodb/pull/10683 * fix: Self link BT link issue in expanded form by @pranavxc in https://github.com/nocodb/nocodb/pull/10695 * fix: No-record found error in expanded form by @pranavxc in https://github.com/nocodb/nocodb/pull/10694 * fix: upload title matching by @fendy3002 in https://github.com/nocodb/nocodb/pull/10693 * fix: apply limit when querying from api by @fendy3002 in https://github.com/nocodb/nocodb/pull/10668 * feat: change formula column to single line text while retaining data by @fendy3002 in https://github.com/nocodb/nocodb/pull/10627 * Nc fix: confirm before leaving shared view/base by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10618 * Nc fix/external db audit log by @fendy3002 in https://github.com/nocodb/nocodb/pull/10701 * Nc fix/locked view by @dstala in https://github.com/nocodb/nocodb/pull/10677 * fix: do not show invalid tooltip over url field if it is empty by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10714 * Nc fix(nc-gui): use object-fit contain property to render attachment cell by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10706 * Nc canvas related issues by @dstala in https://github.com/nocodb/nocodb/pull/10711 * fix: Sanitise string literals in formula by @pranavxc in https://github.com/nocodb/nocodb/pull/10718 * fix: Handle row ID of audit record for tables with composite primary keys by @pranavxc in https://github.com/nocodb/nocodb/pull/10704 * fix: last week of decemeber is cut off by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10716 * fix: Formula - Check for circular reference by @mertmit in https://github.com/nocodb/nocodb/pull/10720 * fix: Handle missing searchPath value while merging config by @pranavxc in https://github.com/nocodb/nocodb/pull/10722 * Nc feat: column helper setup by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10652 * fix: unref potential open handles by @mertmit in https://github.com/nocodb/nocodb/pull/10730 * fix: add missing optional chain by @mertmit in https://github.com/nocodb/nocodb/pull/10732 * fix: duplicate for columns with comma by @mertmit in https://github.com/nocodb/nocodb/pull/10731 * Nc fix/currency number format in expanded form by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10719 * fix(nc-gui): prevent select value on type in input if input box is already focused by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10735 * fix: use custom shutdown hook for long polling connections by @mertmit in https://github.com/nocodb/nocodb/pull/10733 * fix: Handle rendering of Lookup to HM/MM column in grid by @pranavxc in https://github.com/nocodb/nocodb/pull/10738 * fix: local port hang issue by @mertmit in https://github.com/nocodb/nocodb/pull/10745 * chore(nc-gui): lint by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10750 * fix: clear calendar range if one col is updated by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10727 * Fix (nc-gui): upload dialog sometimes stuck on loading spinner by @fendy3002 in https://github.com/nocodb/nocodb/pull/10715 * fix: after import, do not set incorrect column as display value from frontend by @fendy3002 in https://github.com/nocodb/nocodb/pull/10699 * chore: bump rspack by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10744 * fix: Row artifact/ghost row. by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10761 * fix: update filter value if select options are updated by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10755 * fix: on field update trigger filter reload by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10764 * fix: invalid filter acl by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10751 * fix(nc-gui): disable horizontal scroll in lookup cell by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10734 * add import getRenderAsTextFunForUiType by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10769 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/10687 * fix: datetime lookup bug by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10770 * Nc fix/condition column name amb by @dstala in https://github.com/nocodb/nocodb/pull/10771 * Nc Fix: Allow expand cell option for formula field when content length is more by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10759 * Nc Fix: Only display value field info is visible in link record dropdown of form view by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10749 * chore(nc-gui): lint by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10775 * Sync missing changes by @pranavxc in https://github.com/nocodb/nocodb/pull/10777 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/10778 * fix: filters for json by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10723 * Nc feat/formula change column audit by @dstala in https://github.com/nocodb/nocodb/pull/10780 * allow foreign key to be imported by @dstala in https://github.com/nocodb/nocodb/pull/10773 * Nc fix/string too long error by @dstala in https://github.com/nocodb/nocodb/pull/10779 * track different injected row when link / unlink by @dstala in https://github.com/nocodb/nocodb/pull/10774 * Nc feat/filter error handling by @dstala in https://github.com/nocodb/nocodb/pull/10781 * chore: bump sentry and posthog by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/10785 * Nc Fix: ExtDB / SQL View fixes by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10739 * feat: move info message to i18n and add tooltip by @dstala in https://github.com/nocodb/nocodb/pull/10787 * Nc fix: trim whitespace of single select cell value on type conversion by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/10724 * New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/10783 * 0.262.2 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/10788 ## New Contributors * @Bchenjamin made their first contribution in https://github.com/nocodb/nocodb/pull/9977 **Full Changelog**: https://github.com/nocodb/nocodb/compare/0.262.1...0.262.2