August 2022 Newsletter#
Free Team Sites#
Grist is most powerful when used collaboratively. That’s why we’re now offering free team sites for your whole team. Unlimited team members + unlimited documents, for documents under 5,000 rows. Free team sites are fully featured, too.
Conditional Row Styles#
You can now apply conditional styles to an entire row. In the creator panel, it’s under the
More Helpful Formula Errors + Autocomplete#
Writing and troubleshooting formulas just got a little bit easier with more helpful autocomplete suggestions and error messages. For example, in the screenshot below, the autocomplete helps write the common but hard-to-remember formula for reverse lookups, and the error includes a human-friendly explanation, and helpful suggestions to fix it.
Want to learn more about formulas? There is a lot about formulas in our Help Center, including this recently-added formula cheat sheet.
Open Raw Data from Widget#
You can open a widget’s source table without leaving the page. In the widget menu, click on “Show raw data”. This is particularly handy for charts and custom widgets.
Left Pane Now Auto Expands#
Did you know you can collapse the left-side page menu to give yourself more space? Now, the collapsed menu auto-expands on hover, giving you more room on small screens! 🎉
Hide Multiple Columns#
You may now select multiple columns, right click to open the column menu, and hide all selected columns with a click.
Community & Open Source Contributions 🙏#
Grist is open source. We’re grateful to the open source community for their contributions. Here are two recent highlights.
Quickly Rename Pages#
To rename a page name, all you need to do now is click. Thank you, @LouisDelbosc!
Custom Widgets: Add Column Description in Creator Panel#
For custom widget devs: when specifying what columns your widget needs access to, you can now include a description to help guide your widget users, as shown here. Thank you, @yohanboniface!
Open Source + Cool Dev Highlights 👩💻#
grist-core omnibus. Paul published a grist-core omnibus to make self-hosting easier.
Grist as an electron app. User stan-donarise packaged Grist as an electron app that works on Windows 7 or later. How cool is that! 😉
Generate docx from template. User stan-donarise didn’t stop there. He integrated docxtemplater into a custom widget to generate reports and documents in Grist.
Webinar: Sharing Partial Data with Link Keys#
In September we’ll explain how to use one of Grist’s coolest and least explored features: link keys. Learn how to use Grist’s link keys to share partial data, such as a single row, with third parties.
Thursday September 22nd at 3:00pm US Eastern Time.
Relational Data + Reference Columns#
In August, Natalie dove deep into reference columns and how to use them in dashboards and formulas.
Get up and running fast with expert help. If you know what you need, but need help building it, the Sprouts program may be for you.
Team Meetings Organizer#
Use this template to store team meeting minutes, action items, project documentation and more.
Thank you to Grist user Eduardo who shared this template with us. It’s been lightly modified to meet more general purpose needs.
Want to learn how this was built? Watch Natalie build it on August’s webinar.
Organize your projects, contact info, and tasks in this personal notebook.
This template was built by Grist user Julien. It has been translated and lightly modified to meet more general purpose needs. Check out his showcase in the community forum!
If you have a cool template you’d like to share, we’d love to hear about it in the community showcase!
Help spread the word?#
If you’re interested in helping Grist grow, consider leaving a review on product review sites. Here’s short list where your review could make a big impact. Thank you! 🙏