April 2022 Newsletter#
Rich Text Editor#
Add a notepad widget to your document and display a column’s data in a rich text editor. In the custom widget menu, select “Notepad” from the list of premade widgets.
New Font and Color Selector#
The color picker just got more colorful! Spice up your choices and columns with more font and color options. Bold, italic, underline, and
strikethrough is here! These options are also available with conditional formatting.
Copying Column Settings#
If you copy cells into an empty column, the original column’s type and options will also be copied. This includes numeric and date formatting, unconditional cell colors, and choice configurations. Note that conditional rules will not be copied.
New Zapier Action - Create or Update Record#
There is a new Grist action in Zapier. When importing external data via Zapier, you may now update existing records based on a merge key or, if there’s no match, create a new record. Learn more on Zapier.
This builds on the recently added add-or-update API endpoint.
If you store files in Dropbox, embed your files right in Grist. Select “Dropbox Embedder” from the list of custom widgets.
Webinar: Back to Basics#
We get asked all the time how to get started in Grist. The best way to demonstrate is with a real use case. We’ll take a spreadsheet workflow and improve it in Grist.
Thursday May 19th at 3:00pm US Eastern Time.
On April’s webinar, Natalie walked through how to configure the most useful custom widgets.
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.
Using toggle columns to create button-like experience. Josh uses Grist on mobile to track inventory in his flower shop. He shared how he uses toggle columns as buttons to streamline his workflow.
Summarize data from multiple tables. Sharpen your Python skills by following Natalie’s guide in how to pull in data from multiple tables to the same summary table.
For self-hosters, a template for Grist with traefik and Docker compose. Running Grist on your own computer is pretty easy. Hosting it to share with others requires a few more steps. Learn how.
U.S. National Parks Database#
Your one-stop resource for all national parks information! Look up parks by designation, state, activities, and more. Leave reviews and track your trips!
This database is crowdsourced and community-maintained. There’s a page in the database to submit suggestions and corrections.
Simple Time Tracker#
It’s like a stopwatch in a spreadsheet! With the added benefit of creating a log of total time spent on tasks.
Covey Time Management Matrix#
Organize your to-do list with the Covey time management method. Prioritize by what’s urgent and important.
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! 🙏