September 2023 Newsletter#

What’s New#

Calendar widget 🗓️#

The time has come… the Official Grist Calendar Widget is here! We know its handy as we’ve already updated a bunch of our templates to include it. 😅 We’ve even created new ones that specifically feature the calendar widget (more info below).

  • Events are created using associated Date or DateTime columns
  • Day, week & month views
  • Drag-and-drop event editing
  • Support for cursor linking – select an event and have it update a linked widget automatically (this is helpful if you want to see an event’s details in a card widget, for example)

Calendar widget screenshot

SEE DOCUMENTATION

SQL endpoint#

Grist now has an SQL endpoint that lets you run read-only SELECT queries via the Grist API! This is exciting for a very “select” set of Grist users. 🤠

For example, here’s a simple SQL query performed on our Lightweight CRM template (these are not real emails!): SELECT Email FROM Contacts WHERE Due IS NOT NULL

See here for the complete API documentation.

Community Highlights#

  • @jperon’s found a way to create an advanced search widget using Python’s eval method. See the community post for an example, as it’s a bit tricky to explain.
  • Shout out to @prijatelj.francek for their work on the new Slovenian translation. See here for more information on translating Grist.

Working on something cool with Grist? Let us know by posting in the Showcase forum!

Learning Grist#

New orientation video#

New Grist users will see an updated orientation video when they sign up, which may also be a helpful refresher for existing users.

Webinar: Calendar#

Calendars are here! Learn all the tips and tricks to get the most out of calendar views in your documents. Cards pair nicely with calendars, so we’ll dive into card widgets, too.

Thursday October 26th at 3:00pm US Eastern Time.

SIGN UP FOR OCTOBER’S WEBINAR

Deconstructing the Payroll Template#

When looking at our templates you may wonder why templates are structured in a particular way. In September we rebuilt our Payroll Template.

This template uses formulas to look up hourly rates based on person, role, and date. Learn how to build dynamic summary dashboards that summarize data by categories and let you drill into the records in those categories.

WATCH SEPTEMBER’S RECORDING

Templates#

Trip Planning#

Summer may be over, but that just means it’s time to plan your next trip. Use Grist’s new Trip Planning template to plan & organize multiple trips in one place, with detailed itineraries and packing lists. This template is also a great showcase for the new calendar widget!

Trip Planning template screenshot

GO TO TEMPLATE

Social Media Content Calendar#

But wait, there’s more! We’ve adapted and improved the document we use internally to help keep track of our social posting and turned it into a template.

Build and track campaigns, approve content and schedule posts (text/image/video). And yes, this template makes great use of the new calendar widget as well!

Social Media Content Calendar template GIF

GO TO TEMPLATE

Help spread the word#

If you’re interested in helping Grist grow, consider leaving a review on product review sites. Here’s a short list where your review could make a big impact. Thank you! 🙏

We are here to support you#

Sprouts Program. Grist often surprises people with its capabilities. Schedule a free Sprouts call with an expert to see if Grist can address your needs. Learn more.

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.