What’s New
New Grist Business plan
We’ve been working hard to make sure Grist suits larger teams with complex and sensitive data. To address this segment, we’ve updated our Pricing page to include a new Business plan — with a Self-Managed flavor! We’re hoping this new plan increases the transparency of pricing around Grist deployments that could use more of our support, rather than requiring organizations to reach out directly for pricing info.
There’s also a new option to subscribe annually. New Pro subscriptions are now $10 on the monthly plan, but still at $8 if paying annually. Existing Pro subscriptions are not affected by this change.
We’ve also updated our Professional Services page to include some new opportunities we have regarding getting expert help building Grist documents.
Formula timer
Enough is enough – it’s time to put your formulas through their paces.
It’s a common event to see a spreadsheet collapse under its own weight, like a dying star composed of conditionals. Even mighty Grist documents can slow down when the power of Python goes unchecked. But now there’s a way to diagnose your formulas before things go supernova. Introducing the formula timer, which lets you time formulas for specific changes or for a full document reload.
For more information, read all about saving milliseconds with the formula timer — written by one of the newest additions to the Grist Labs team, Jordan!
Ordering conditional styles (with bonus draggability)
You can now easily reorder conditional styles, on both rows and columns! Don’t ask how this was accomplished previously!
Self-hosting admin console improvements
Our new admin console is continuing to grow and develop as we work towards our ambitions of easier self-hosting.
-
The app’s authentication method is now included in the “Security Settings” section. If not set up, you’ll be warned.
-
Boot panel checks are now visible (and expanded/improved based on your feedback!). We’re still iterating on this, so please let us know on Discord if you have any more feedback.
-
To make the panel more robust, it now honors emergency access via a
GRIST_BOOT_KEY
setting if authentication is broken, and should even be usable if the app has some common misconfigurations. This means you can count on the admin panel not becoming inaccessible just when you need it most!
Community highlights
-
marc.fargas has provided our community with a excellently detailed walkthrough of his Grist → PDF rendering pipeline. The solution does require external services (which may not be completely free), but it’s an great example of extending Grist.
-
Riccardo_Polignieri has created a Python wrapper for Grist’s API called PyGrister! Get more Python in your workflow!
Working on something cool with Grist? Let us know by posting in the Showcase forum or our #grist-showcase Discord channel!
Learning Grist
Webinar: Reference Columns
In June, we’ll dive into what references are, how reference columns work in Grist, and explain how to use them to build productive dashboards using the Event Speaker Template.
Thursday June 20 at 3:00pm US Eastern Time.
Reference and Choice Dropdown List Filtering
In May, Anais returned to look at how filtering a reference or choice column’s dropdown list is very useful in a variety of cases. See how to take advantage of one of Grist’s newest and most sneakily-powerful features.