This comparison tells us if Zapier processed the latest update to a given record. If it does not, or if the Zapped field is empty, the formula will return a no. If it does, the formula will return a yes. The formula does nothing other than check if the Zapped field has anything in it and, if it does, see if the Zapped and Last update field contain the same date and time. If not, it should work without any changes. If you changed the names of any of the fields we’ve created you’ll need to alter this formula accordingly. If you pick something else, just make sure to update the formula accordingly once we get to it.) (You can choose another name, but you might want to stick with it for now because we’ll use it in a formula later. Later, we’ll provide Zapier with that view in order to create a daily digest that will round up every update and send them to you in one, concise summary that you design.įirst things first, create a new field and choose Last modified time as its type. Because the last modified time field updates automatically, we can use some simple logic to create a view that tracks daily updates. You can also build on top of it to create other useful tools, like the daily digest we’re learning to make right now. This can come in handy in Airtable, all by itself, to help you sort and group records based on most recent activity. You can even tell it to only update when certain fields have changed. Build the foundation of your daily digestĪirtable’s last modified time field will automatically mark the date (and time) of the most recent change to a record. With Airtable's last modified time field and an integration built with third-party tool Zapier, you can create a custom email digest to put those updates directly in your inbox. Whether you're working with a team on a large-scale project, or tracking changes across hundreds of records every day, you may want a quick way to see what's most recently been updated. Ready to supercharge your workflows with Airtable and Relay? Try Relay for free and experience the power of seamless collaboration between Airtable, other SaaS products, and AI models.Here's how to use Zapier to automatically generate a daily digest of what's changed in Airtable. This ensures that your teams are always on the same page and eliminates manual data entry. For example, you can automatically create a task in your project management tool whenever a new record is added to Airtable. Whether it's connecting Airtable with your CRM, marketing automation tool, or project management system, Relay allows you to automate the transfer of data between these apps. Integrating Airtable with Relay opens up a world of possibilities for syncing data across multiple SaaS products. This means you can send targeted and personalized messages to your customers, increasing engagement and driving conversions. AI autofill can help you dynamically fill in customer information or generate personalized content using AI models like GPT. By integrating Airtable with Relay, you can create personalized email campaigns based on customer data stored in Airtable. With the double check automations and AI autofill features of Relay, you can take your customer communication to the next level. This ensures that everyone on the team stays informed and can easily track project milestones. For example, you can create an automation that updates the project status to 'completed' when all the tasks in a checklist are marked as done. By connecting Airtable with Relay, you can automatically update project status based on specific actions or triggers. Streamline Project ManagementĪirtable's flexible structure makes it ideal for tracking project progress. By integrating Airtable with Relay, you can supercharge your workflows and automate repetitive tasks. With its user-friendly interface, Airtable allows teams to organize and manage data in a highly customizable way. Airtable is a powerful collaboration platform that combines the functionality of a spreadsheet with the power of a database.