Grist is hiring!
Come work with us and help make Grist even better. Note: both applications involve puzzles.
What’s New
This month we’ve seen a huge increase in community activity, which is incredibly exciting. We can’t say enough about how motivating it is to see users on Discord or the Community Forum create cool and useful things in Grist. But we can’t let you have all the fun – we’ve been very busy behind the scenes. Here are a few things that shipped last month, but keep your eyes open for more in the near future.
Misc. improvements
-
Calendar events now open in record cards on double-click
-
The image viewer custom widget can now display a carousel if multiple URLs are detected
-
🫨 The Markdown widget saves by default when you lose focus
-
Grist’s AI Formula Assistant can now handle larger documents
-
Custom widgets now show a nicer warning when required columns aren’t mapped
Community highlights
FOSDEM lighting talk
Grist contributor and ANCT member Florent gave a great lightning talk at this year’s FOSDEM conference.
Tree visualizer widget
The inimitable jperon (who will be showing up again) shared a very neat widget to visualize hierarchical data (like an org chart, for example). It even has bidirectional cursor linking! Check it out!
DOCX report printing
Using docxtemplater, TomNit has shared an updated widget that lets Grist process templated .docx files, essentially allowing you to drive document generation using data in Grist.
Check out the full source code on GitHub.
Signature widget
Thanks once again to jperon (and of course the other open-source JS devs who make these experiments possible), we saw a proof-of-concept signature collection widget that is too much fun.
Dynamic reference drop-downs in Grist
Rogerio_Penna penned a detailed walkthrough on the Community Forum describing his solution to having filtered/dynamic drop-downs. Have you ever wanted a reference column’s options to be filtered by another reference column? It’s not an uncommon use-case, and Rogerio found a way to do it with the action button custom widget (which the community has also been working on).
Simple menu navigation with hyperlinks
Peter_P_Breithaupt, partially inspired by Grist’s powerful SELF_HYPERLINK()
function, created an in-depth exploration of the benefits of using navigation hyperlinks on large flat tables. Most importantly, how you can keep the same active record when switching between pages!
Working on something cool with Grist? Let us know by posting in the Showcase forum!
Learning Grist
Webinar: Controlling spreadsheet chaos
In March, we’ll see how Grist can contain the spreadsheet sprawl. Similar to our previous Grist/Excel webinar, we’ll see how Grist is designed to avoid many of the very familiar problems associated with spreadsheet workflows, such as merging and normalizing.
Thursday March 21 at 3:00pm US Eastern Time.
Forms!
In February, we celebrated our love of forms! We learned how to create a beautiful form and collect data that will populate a Grist data table upon submission.