April 2022 Newsletter#
Welcome to our monthly newsletter of updates and tips for Grist users.
|
-
Rich Text Editor!
-
National Parks Database in Grist!
A community-maintained resource and application built entirely in Grist.
-
New Font Options!
Bold, italicize, underline, and
strikethroughyour text. -
Next webinar – back to basics
How to build efficient workflows in Grist.
-
2 new templates
Simple time tracker and Covey time management matrix.
What’s New#
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.
Dropbox Embedder#
If you store files in Dropbox, embed your files right in Grist. Select “Dropbox Embedder” from the list of custom widgets.
Learning Grist#
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.
Sprouts Program#
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.
Community Highlights#
-
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.
New Templates#
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.
If you feel inspired to make your own crowdsourced database, check out also the simpler crowdsourced list example. Reach out on our Community Forum to get help or share the result!
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! 🙏
- 🌟 New! Stackshare
- Capterra
- TrustRadius
We are here to support you#
Have questions, feedback, or need help? Search our Help Center, watch video tutorials, share ideas in our Community, or contact us at support@getgrist.com.