What’s new
Introducing F O C U S M O D E
Working with spreadsheets can be overwhelming. In this modern age, we’re overwhelmed with an overwhelming amount of information. Sometimes, we need to zoom in on what’s really important to make the most of our productivity. Introducing Grist’s F O C U S M O D E, a new way of viewing and working with spreadsheets that eliminates unwanted distractions and visual noise, letting you make the most of your data: one cell at a time.
Grist Enterprise - Admin Controls
A new suite of user management features have been added to Grist Enterprise. Installation administrators will be able to access the new controls, whose functions include:
- Viewing users, organizations, workspaces and documents in tabular form
- Removing users
- Modifying sharing settings for organizations, workspaces and documents
Learn more in our Help Center!
Spreadsheet Makeover - 3 new episodes!
If you haven’t been following Grist co-CEO Anais’ adventures over at Spreadsheet Makeover, you’ll want to check out the latest episodes, including:
- Revamping a donor database & relationship tracker for a children’s charity
- Building a complex catering CRM/profit calculator/hour tracker from disconnected spreadsheets
- Taking an existing grant management solution built in Grist and working through some common Grist pitfalls
The latter is especially informative for any Grist beginner struggling with references or overcoming “spreadsheet brain”. More to come!
grist-core has been updated to version 1.5.0. Lots of new stuff for self-hosters, so be sure to check out the release notes. Thank you to our first-time contributors!
More updates
- There are now endpoints for downloading attachments as .zip and .tar archives. For external attachments, there is also an endpoint for reconnecting attachments via .tar archives. Technical endpoint documentation can be found in our API reference.
- Grist Desktop has been updated, with a few desktop-specific bugs squashed.
Community highlights
-
From the French Grist forum (le forum Grist), audezu shares a cool trigger formula that tracks historical changes to a column.
-
In a similar vein, Varamil has shared an in-row chat-like widget that they use for collaboration.
-
Quentin Leroy has shared an adapter for Apache Superset enabling SQL querying of documents using the Grist API.
-
Another very cool showcase from audezu in le forum Grist – an access rule setup that limits users to editing columns only if another column is filled. That may sound odd or extremely specific, but seeing it in action shows how useful it could be on teams with varying permissions. Access rules!
-
lshalon on GitHub has added detailed documentation on how to use OpenRouter to enable other models for Grist’s AI Formula Assistant.
Working on something cool with Grist? Let us know by posting in the Showcase forum or our #grist-showcase Discord channel!
Learning Grist
Webinar - Creating Custom Invoices
Today is April 1st, but creating custom invoices in Grist is no joke!
Join us as we create and customize invoices right in Grist with the Invoice custom widget. You’ll learn how to set up your document to generate printable invoices for customers, and we’ll even show you how to update colors and add images to reflect your brand. Whether you’re starting from scratch or refining an existing invoice, this session will walk through how to create professional, tailored invoices for almost any organization.
Thursday April 24 at 11:00am US Eastern Time.
Access Rules for Distributed Organizations
In March, we explored how to secure and manage data across multiple locations — without the headaches. We covered strategies for controlling access to tables, columns, and rows, ensuring sensitive information stays in the right hands.
