October 2021 Newsletter#
You can now edit existing choice values and apply those edits to your data automatically!
Text fields now automatically convert URLs into hyperlinks, including in cells that contain both plaintext and URLs.
Preview Changes in Incremental Imports#
When importing additional data to an existing table, and using a merge key to match duplicate records, you can now preview changes to your data before committing to the import. Learn more.
Build with Grist Webinar#
Sign up for November’s Webinar
Join Grist experts on a live webinar to learn Grist best practices. Half the webinar is dedicated to a live Q&A where you can get answers to your questions. 💡
The webinar will go live on Thursday, November 18th at 12:00pm US Eastern Time (New York).
Watch October’s Webinar Recording
On October 18th we held our first Build with Grist webinar, focused on best practices to get the most out of Grist.
Grist CEO Dmitry Sagalovskiy shared tips on adapting data from a spreadsheet to a database using the DRY principle, and building dashboards using linked widgets.
Other topics covered include finding the most recent value from a list of historical records, filtering by several fields, understanding the lookup function and reference lookups, and more.
Access Rules Video#
Limiting access for team members
Access rules are a beta feature of Grist which make it possible to limit access to parts of your data based on custom rules. The rules can be very granular and grant view or edit permissions based on a number of variables.
The most common use of access rules is for teams who want to limit which records team members can see. For example, it is often desirable for sales representatives to only see records related to their owns sales, while their manager can see all records. We cover how to set up those rules in a 5 minute video.
Overtime Calculator. Automatically calculate and keep track of weekly overtime rates.
Calculating terms. Suppose you sell memberships that last 12 months and want to automatically calculate membership expiration dates. Learn how to calculate future dates.
Account-based Sales Team#
Track your sales team’s accounts, contacts, and deals. Access rules limit sales reps access to viewing and editing only their deals, contacts, and accounts.
Time Tracking & Invoicing#
Quickly record time spent on projects, summarize it, and create invoices.
Expert Witness Database#
Create a simple database of expert witnesses that may be called to testify on the stand.
Keep track of shareholders, issued shares and options, and percentage ownership.
Manage your daycare business in one place.
Roman Emperor Julius Ceasar used the Ceasar Cipher to encrypt messages. Write a message to encrypt it with this ancient method.
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! 🙏