March 2022 Newsletter#
We’re launching a new program to help teams get up and running fast on Grist. If you know what you need, but need help building it, we’re here to help. Here’s how it works:
- Eligibility. Anyone with a team site is eligible for the Sprouts program (even while on free trial).
- Schedule a free 30-minute consultation call. Email firstname.lastname@example.org and describe your use case. We’ll pair you with a Grist expert on our team and schedule a time to meet. On that call, we’ll estimate the scope of the work.
- For quick projects. If we estimate your project can be completed in less than an hour, we’ll do it ourselves — for free! Many use cases fall into this category.
- For larger projects. For projects longer than an hour, we’ll recommend a contractor who has been trained and vetted by Grist, and has quick access to our team.
Whether you choose to work with our contractor or with someone else, we’ll schedule one more 30-minute call to make sure everyone understands the project. Based on this, the contractor will estimate the work and quote a price.
Visit our website to submit an inquiry!
Conditional formatting is finally here! 🎊 In the creator panel in the column menu, under CELL STYLE you may now add conditional styles. Enter a formula and style the cell’s background and text color. You may add multiple conditional rules. Learn more.
Improved Column Type Guessing#
When you import or copy and paste data, Grist is now much better at parsing data and guessing column types. Phew! That means less data cleaning when importing new data! 🎉
New API Method for Add or Update#
We added a new method to update an existing record, or, if it does not exist, add a new one. Learn more.
Grist-help Is Now Public!#
Webinar: Custom Widgets#
Custom widgets have gotten easier. Learn how to configure custom widgets from the menu of premade widgets in the creator panel.
Thursday April 14th at 12:00pm US Eastern Time.
On March’s webinar, Anais walked through how to set up access rules on private and public documents.
Improve your Wordle stats with Grist! David Smedberg put Grist to the test by building a document that could track his Wordle stats across multiple devices and analyze his best guess words. He shared his document on our forum. His detailed blog post about his experience is worth a read. 🤩 Fantastic!
Apply Formula to Filtered/Visible Rows Only. Grist applies formulas to the whole column. What if you only want to transform filtered rows? Here’s a helpful workaround.
Toggle on/off if attachment present. Suppose you have an attachment column and would like to filter for rows that have attachments. Here’s how to toggle a switch to “on” if there is an attachment.
Showing images from URLs. Here’s how to configure a custom widget to preview images from URLs.
Event Sponsors + Attendees#
Track event registrations and ticket revenue, and reconcile sponsors and attendees.
Organize public giveaways on a first-come, first-serve basis. This template uses access rules to limit who can claim which gifts.
Keep track of tasks by department and project, and quickly flag tasks at risk
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! 🙏