May 2022 Newsletter#
Welcome to our monthly newsletter of updates and tips for Grist users.
|
-
Raw Data Page!
-
Link Related Data to Summary Tables
When linking summary tables and other widgets, you can now link on reference columns too.
-
Webinar: Expense Tracking in Grist v. Excel
How to build efficient workflows in Grist.
-
Shortcut to Duplicate Rows
Ctrl + Shift + Don Windows, or⌘ ⇧ Don Mac. -
2 New Templates
Hurricane preparedness and gig staffing.
What’s New#
Raw Data Tables#
Introducing the raw data page, a special page that lists all data tables in your document, making it easier for you to find and browse all your data. Learn more.
Raw Data has been a long time in coming! In Grist, there has always been a conceptual separation between views and underlying data. As a Grist creator, you have probably found yourself in the shoes of an application developer: at one time thinking about relationships in the data, and separately designing how to present this data in convenient productive views.
Raw data makes the separation explicit. It’s a place where you can always find the underlying data, and its structure.
When creating pages, your page list can now be limited to only the most useful views, without the clutter of helper tables. Those are still available any time in the raw data view.
Linking Referenced Data to Summary Tables#
Tables that reference a summary table’s underlying data may now be linked to the summary table itself.
API Endpoint GET /attachments#
New API endpoint. /attachments will return list of all attachment metadata. Learn more.
Access Details and Leave a Document#
Non-owners of documents may now view their access details and leave a document if they wish. Click on the share icon in the top-right, then “Access Details.” From the access details pop up, you may click the trash icon to leave a document.
New Keyboard Shortcut#
New keyboard shortcut for duplicating selected record(s)! Ctrl + Shift + D on Windows, or ⌘ ⇧ D on Mac.
Learning Grist#
Webinar: Expense Tracking in Grist v Excel#
Tracking expenses in a spreadsheet can be convenient, but traditional spreadsheets require a lot of maintenance — especially with formulas. Grist can make expense tracking easier. Join us to learn how.
Thursday June 16th at 3:00pm US Eastern Time.
In May we went back to basics. Natalie took a data workflow in Google Sheets and transformed it into a productive dashboard in Grist.
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#
-
Sequential numbers using formulas. Check out this thread with a few examples on how to get sequential numbers in Grist.
-
Concatenating data in columns of different types. Concatenating text is simple, but what if you want to concatenate different types of data, such as text, reference columns, and dates? Learn how.
-
Numbers that begin with zero. Natalie shares two methods.
New Templates#
Hurricane Preparedness#
Do you live on the coast? Don’t stress! Use this template to ensure you have everything you need in the event of a hurricane.
Gig Staffing#
Easily manage staffing for gigs and track employee timesheets. This sample data is focused on staffing for shows at a theater, but the template can be modified for catering, event staffing, and more.
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! 🙏
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.