August 2021 Newsletter#
It is now possible to relate a record in one table to multiple records in another table. Choose the Reference List column type to establish a one to many relationship in your document. Learn more.
Have data you want to share on your website? You may now embed Grist pages as view-only data that updates live. Learn how.
You may now import data to Grist with Pabbly! Read more on Pabbly’s website.
The Grist API is now more convenient with row-based (aka record-based) endpoints. Learn more.
Did you sign up for a team plan, but changed your mind on what subdomain name to use for your site? You may now edit your subdomain from your billing page. Click on your profile icon in the top-right to access your billing page.
Need help with formulas? There’s a dedicated category in our community forum where you can find formulas for common use cases, and ask for help.
Large Template Library#
Finding the right template for your project just got easier. Click on(in the left-side panel of your personal or team site dashboard) to find a larger library of templates to choose from.
- Multiple Accounts. You can sign in with multiple emails into Grist to easily switch between accounts. Click on your profile icon in the top-right, then select “Add Account”.
- Finding Duplicates. Find duplicates using the formula:
"DUP" if len(Products.lookupRecords(ProductCode=$ProductCode)) > 1 else ""
For more help, follow this guide.
Color code conditional values. Use a formula and colorful Choice column entries to flag records that need attention. Follow our quick guide.
Keep track of your restaurant inventory and supplier information, and create purchase orders right in Grist.
Restaurant Custom Orders#
Build custom orders, calculate ingredient costs, and generate a bill of materials, all in one document.
Custom Product Builder#
Build custom products and production contracts that add up component costs and add your profit margin to the final cost.