November 2020 Newsletter#
Open Source Announcement#
We are happy to announce the beta release of the open source version of Grist! As a modern, powerful spreadsheet, Grist fits well into the open-source ecosystem, and is as friendly to hacker-developers as to hacker-users.
This will interest technically-minded users who’d like to extend Grist, or those with unusual requirements. Meanwhile, the service you know and love remains the best supported and cost-efficient option, and will benefit from the increased confidence in Grist source code.
Add a Record. Some of the simplest shortcuts are the most useful. To add a record, press
Ctrl + =(Windows) or
⌘ =(Mac). Press
Shiftat the same time to insert the record above the cursor rather than below.
Cook up a Unique Identifier. Let’s say you’d like to refer to records in a table, but don’t have a column that identifies each record uniquely. Perhaps you have people with
Last_Name, or sessions with
Date. To use such tables as a destination of a Reference column, you’ll need a unique identifier.
You can create one using a formula that stitches together the fields that identify a record uniquely. For example, create a column
Full_Namewith the formula
$Last_Name + ", " + $First_Name
or a column
Session_Namewith the formula
"[%s] %s" % ($Date, $Program_Name)
The latter is Python syntax for formatting strings: each occurrence of
%sin the quoted string is replaced by a value from the list in parentheses.
Improved Attachments. The preview of attachments has been vastly improved, and supports showing PDF, video, and audio files. Simply double-click a cell with attachments to preview its content:
View Differences. You can now view differences between a copy of a document you make using “Work on a Copy” and the original, as well as what changed since a backup snapshot in the document’s history. Find the “Compare” menu item in the Share menu:
This feature is experimental for now, but is already quite useful:
This supports the workflow of trying out changes, which should be familiar to users of version control systems such as Git. One of its benefits is allowing view-only users to propose changes, even though they cannot edit the document directly.
Treasure Hunt: Even better than using Grist for work is using Grist for fun! Check out this template that helps you plan a treasure hunt without losing track. Conspire with relatives or friends online to create a trail of clues, then watch and laugh as the rest of your household flails their way through it.
Get started quickly with basic Grist concepts by watching this playlist of a few very short introductory videos: Grist Video Series.
Each of our featured Examples & Templates has a related tutorial that shows step-by-step how to build it from scratch. Read through one to gain a deeper understanding of how various features play together.
Visit our Help Center to find all of the above, along with the full product documentation.
Questions or suggestions? Click the firstname.lastname@example.org near the bottom left in the Grist application, or simply email