Grist Core Versions Save

Highlights:

• Grist Forms have a new design, and now support features like displaying text fields as text areas and copying an embed code for a published form.
• Support for importing and exporting TSV and DOO files. Read all about it in our monthly newsletter.
• The "Contact support" link is now customizable. Thanks @vviers!
• The export CSV and XLSX endpoints now support a title query parameter for specifying the filename of the downloaded file. Thanks @CamilleLegeron!
• An experimental environment variable, GRIST_SKIP_REDIS_CHECKSUM_MISMATCH, is now available which causes checksum check failures to be treated as warnings rather than errors. Thanks @fflorent!
• Date filter strings are now translatable in Weblate. Thanks @thomasweaver627!
• The GRIST_ALLOWED_HOSTS environment variable has been removed. Thanks @jonathanperret!
• Fix for Ctrl-C not working in Docker. Thanks @fflorent!
• A new row menu shortcut, "Use as table headers", for quickly copying the selected row’s values to their columns’ headers. Thanks @CamilleLegeron!
• Podman can now be used to build the grist-core image from the Dockerfile. Thanks @paulfitz!
• Portability improvements to various bash scripts. Thanks @tykling!
• HTTP long polling is now supported as an alternative to WebSockets. Thanks @jonathanperret!
• Doc workers now shut down automatically when they are no longer in use. Thanks @fflorent!
• Webhooks can now be configured to only trigger when a specific column changes. Thanks @CamilleLegeron!
• Additional team sites can now be created. Thanks @CamilleLegeron!
• Misc. bug fixes and improvements.

See newsletter at https://support.getgrist.com/newsletters/2024-03/

Join our Discord Community if you'd like to get into development of Grist.

Highlights:

• An early version of a diagnostics page available at /boot. More to come later!
• Custom widgets will now only load once all required columns are mapped.
• Fix for hyphens not being escaped in snapshot URLs. Thanks @fflorent!
• Coaching call and contact urls are now configurable via environment variables. Thanks @CamilleLegeron and @vviers!
• The Access Rules page now uses more horizontal space when available. Thanks @CamilleLegeron!
• Post-release bug fixes and improvements for forms.
• Misc. bug fixes and improvements.

See newsletter at https://support.getgrist.com/newsletters/2024-02/.

Join our Discord Community if you'd like to get into development of Grist.

Highlights:

• Forms are now available in Grist! Learn all about them in the monthly newsletter.
• The API console is now accessible from the Document Settings page.
• Fix for disabled webhooks continuing to fetch table data. Thanks @fflorent!
• Fix for deadlock with webhooks on document load. Thanks @fflorent!
• Support for overriding end_session_endpoint using environment variable GRIST_OIDC_IDP_END_SESSION_ENDPOINT. Thanks @jyio!
• Improved error message in document recovery modal. Thanks @fflorent!
• New createSite feature flag. Useful for disabling team site creation in the UI. Thanks @fflorent!
• Fix for server crash when client passes malformed JSON. Thanks @fflorent!
• Fixes for strings that were previously untranslatable. Thanks @CamilleLegeron!
• Fix for Grist process not shutting down gracefully in Docker. Thanks @fflorent!
• Support for longer TLDs in ISEMAIL and ISURL. Thanks @vviers!
• Performance optimizations for fetching workspace access. Thanks @fflorent!
• Misc. bug fixes and improvements.

See newsletter at https://support.getgrist.com/newsletters/2024-01/.

Join our Discord Community if you'd like to get into development of Grist.

Highlights:

• In table widgets, you can now hit the spacebar to open the selected row as a record card.
• Secret /apiconsole landing page, ssh don't tell anyone.
• There are parts of a native form implementation starting to assemble behind the GRIST_EXPERIMENTAL_PLUGINS flag. Ssh again.
• Some fixes for filter link chains.

See newsletter at https://support.getgrist.com/newsletters/2023-12/

Join our Discord Community if you'd like to get into development of Grist.

Highlights:

• You can now open a record or referenced record in a pop-up card view. Read all about it in our newsletter.
• You can now specify the type of a new column from the "Add Column" menu.
• The calendar widget now comes pre-bundled with Grist, making it available even when offline.
• URLs that only have a docID (e.g. https://mysite.grist.mydomain.com/o/docs/{docID}) can now be used to open a document. Thanks @fflorent!
• New environment variables for configuring OpenID Connect name and email attributes, and disabling calls to the end session endpoint. Thanks @fflorent!
• Misc. bug fixes and improvements.

See newsletter at https://support.getgrist.com/newsletters/2023-11/

Join our Discord Community, you won't regret it.

Highlights:

• The new menu for adding columns is now enabled by default.
• OIDC is now supported for authentication. Thanks @fflorent!
• GRIST_FORWARD_AUTH_HEADER is now only respected on login endpoints by default, with the remaining endpoints handled by sessions. GRIST_IGNORE_SESSION may be set to override this behavior. Additionally, GRIST_PROXY_AUTH_HEADER is now an alias for GRIST_FORWARD_AUTH_HEADER.
• Attachments and system files are now excluded when download a document as a template. Thanks @wunter8!
• The /download/table-schema endpoint now supports colId for the header parameter. Thanks @fflorent!
• Misc. bug fixes and improvements.

Highlights:

• There’s a new menu of options when adding a column, including lookup and formula shortcuts. The new menu is disabled by default and can be enabled by setting GRIST_NEW_COLUMN_MENU. It will be enabled by default in the next release.
• Popup tips are now shown throughout Grist. These can be disabled by including helpCenter in GRIST_HIDE_UI_ELEMENTS, or excluding helpCenter from GRIST_UI_FEATURES.
• A new environment variable, GRIST_PROMCLIENT_PORT, can now be set to serve Prometheus metrics on the specified port number. Thanks @fflorent!
• Misc. bug fixes and improvements.

See newsletter at https://support.getgrist.com/newsletters/2023-10/

Highlights:

• New header parameter for the /download/csv and /download/xlsx endpoints, allowing you to specify whether to use column ids or labels for headers. Thanks @fflorent!
• Numeric table ids are now supported for the tableId parameter in the API. Thanks @CamilleLegeron!
• Misc. bug fixes.

Highlights:

• A calendar widget is now available. It has been developed as a custom widget, in the grist-widget repository. It can be presented natively by setting PERMITTED_CUSTOM_WIDGETS to calendar. A mechanism to bundle custom widgets with the Grist app, so there are no external dependencies, is under development.
• Certain kinds of loops are now permitted in widget linking. In particular, bidirectional linking is now permitted. For example, you can link a table to a calendar, such that moving the cursor in the table highlights different cards in the calendar, AND you can link in the opposite direction too.
• An /sql endpoint has been added, allowing arbitrary SELECTs to be run against a document. No modifications to the document are supported, and there is a default time limit of 1 second on queries.

See newsletter at https://support.getgrist.com/newsletters/2023-09/

Highlights:

• AI Assistant – you can now use the Llama family of self-hostable models via the llama2-cpp-python wrapper by configuring the expanded AI Assistant-related environment variables.
• 𝓢𝓽𝔂𝓵𝓮𝓭 column headers - see https://support.getgrist.com/col-types/#formatting-columns - thanks @CamilleLegeron and the ANCT!
• New .grist file download options - you can now download a .grist file’s structure without any data, which is useful for templating. Or you can download a .grist without document history which reduces file size.
• File importing has been updated with a new flow, with better support for multiple files/sheets and column mapping.
• Grist has been upgraded from Python 3.9 to 3.11. This update brings with it the following new features:
  • Execution should be slightly faster.
  • Additional support for the statistics module, including covariance, correlation, and linear_regression functions.
  • Support for Structural Pattern Matching.
  • You can now see ^ marks pointing at the problem in tracebacks, which can help debugging errors.
• Links are now clickable in widget and column description tooltips.
• Grid selection now supports CTRL/CMD+Shift+ shortcuts. If you’ve used this shortcut in other popular spreadsheet products, you’ll be right at home! Thanks @Ocarthon.
• There's a new, not yet documented endpoint for doing SQL queries directly against a document: https://github.com/gristlabs/grist-core/pull/641
• Core grist functionality was packaged up into a handy CSV viewer component: https://www.getgrist.com/grist-csv-viewer/