Using Airtable’s new Last Modified Fields with Integromat

In this post we are going to look at using Airtable’s new Last Modified field to drive processes in Integromat. This is really a game changer for Airtable - making it possible to do so much more with Integromat and Zapier…

To show the principles of this, I am going to keep the scenario quite simple - lets assume that we want to be sent an email whenever the status of an entry in our Company table changes.

The Airtable Base

In Airtable, we need a Company table with a Status field with suitable options (say Lead, Prospect, Client and Lost). We can then create a new field which we’ll call Status Last Changed:

Depending on when we want to receive our email this may be all we need - for example, an Integromat scenario could be triggered by the Status Last Updated field.

Setting up this Simple Scenario

This is going to be a simple 2 step Integromat scenario - first a Watch Records step and then a send email:

and

So there we have it - a process to send an email whenever the status of a record changes - really simple now with the latest changes to Integromat and Airtable!