September 2023 Newsletter#
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)
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. 🤠
See here for the complete API documentation.
- @jperon’s found a way to create an advanced search widget using Python’s
evalmethod. 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!
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.
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.
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.
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!
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!
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.