What’s new
Grist Labs update: the evolution of leadership
We’re very excited to share some news that will help push Grist forward into the “sovereignty moment” that we’re experiencing worldwide. We think Grist is an excellent piece of software, but it’s also uniquely placed to provide real data ownership to the increasing number of organizations who are looking for it. We’ve made some leadership changes to make the most of this opportunity and reach these users:
- Anais Concepcion is now CEO, after co-leading Grist Labs for the last five years.
- Co-founder Dmitry Sagalovskiy is now Head of Product.
- Stefano Maffulli (former ED of Open Source Initiative) is joining as Chief Revenue Officer.
- Dipalie Mehta is joining as Head of Marketing.
Read our official press release for full details, including notes on seed funding and our path to Europe.
Airtable import improvements
If you still have data sitting in an Airtable base that’s itching to move to Grist, there’s no better time to migrate. We’ve made some improvements to the automatic process, including:
- Formula columns with field references are imported as better comments (accurate table and column names).
- Airtable “Select” field colors are now properly mapped to Grist choice colors.
- Single record link fields are imported as Reference (vs Reference List) columns.
- Imports now use the
/tablesendpoint for better availability. - Imports now target the current org and workspace.
- A nicer message is shown when Airtable OAuth integration isn’t configured.
grist-console
CTO Paul has resurrected Grist Labs Labs for an experiment for those familiar with a CLI. It’s very fun and surprisingly functional! You can try it right now, in fact: npm install grist-console -g
Features:
- Multi-pane page layouts
- Table and card view
- Functional linking (!)
- Editing, adding and deleting rows
- Multiple themes
- …and lots more, somehow. See the full breakdown on GitHub.
More updates
-
Fixed opaque
Originhandling for CORS requests. (PR)- This tightens up the parsing of the
Originheader, forcing the Opaque Origin ("null") to be handled explicitly, as well as falling back on it for invalid origin values. Helps when using anhttps://custom widget in anhttp://hosted site (e.g. local development).
- This tightens up the parsing of the
-
Custom widgets now receive Link Type for better initial state handling. (PR)
-
Every custom widget now receives linking status information to help answer questions such as: is my cursor being moved by some other section? are my records filtered by some other section? is my cursor moving some other section?
If you’re in a widget and would like behaviour to be conditional based on whether you’re linked to something, you can now do it. For example, if a calendar widget is unlinked it can default to showing today’s date.
This is the Link Type field from the Advanced Link Info section in the Creator Panel:
-
-
Searching within a document is now accent-insensitive. (PR)
-
Suggestions counter has been replaced by a status dot to remove counting ambiguity. I just think it’s neat.
A new version of grist-core has been released – v1.7.13 – and if you’re curious about the full release notes head over here.
Community highlights
- On Discord, wrightwells shared their Grist Finance API connector, described as “scaffolding for importing finance data from external APIs into a self-hosted Grist instance.” It features sync scheduling, though currently only supports Starling Bank as a source.
- dtinth created some useful docs covering service accounts and upserting via n8n (valid until their n8n PR is accepted, at least!).
- Two examples of project management suites being built in Grist that really show its flexibility. You can just do things.
- Isaytoo’s example shared on the French forum with custom calendar, Kanban, Gantt, and more.
- Benedicte Monguillon’s in-progress human resources app which uses Grist as a relational data store and has completely custom UI.
- Isaytoo’s example shared on the French forum with custom calendar, Kanban, Gantt, and more.
- There’s a new experimental Grist MCP option from Cerema Méditerranée with extensive documentation.
- One of our favorite custom widgets just got updated: Varamil’s simple filter. Click that link to see the full release notes.
- Speaking of favorites: Emanuele Gissi shared a fascinating native Grist pseudo-widget on Discord, implementing collapsing tree hierarchies in a self-referencing table using toggles and formulas.
- Maxime Lacoste is back with a custom widget that creates a tabular representation of a record to help view long text fields. Will also appeal to Firefox users circa the early 2000s.
Learning Grist
Grist 101
New to Grist? Check out our webinar designed to get you up to speed on essential features and helpful tricks.
Webinar – Vibing with Grist: AI Assisted Custom Data Interfaces
Have an idea of exactly how you want to view or interact with data, but not sure how to bring it to life? Grist has two easy ways to do so, made even easier with AI. Join us as we build dynamic visualizations with the Vibe View custom widget, and then an interactive custom widget with the custom widget builder.
Thursday May 21st at 11:00am US Eastern Time.
Automations: The Beginning
Automations are here — and this is just the beginning. In April, we introduced Grist’s new Automations feature and showed you how to set up row-level email notifications that fire automatically when your data changes. Watch to see how automations can save your team time and keep everyone in the loop.