Having a Last Modified field sounds quite unimportant - but when combined with tools like Integromat it becomes very powerful - and this on top of the new Airtable / Integromat ‘app’ which makes Integromat so much more useful to us!
I’ve written a blog post about this which will show how to use this new field type to drive processes - and it’s the first post which I’ve initially published on my new Blog / Forum site - Online Database Experts. This is a site aimed at users of Airtable and other similar platforms and all are welcome to join and collaborate about Airtable and other tools like Integromat. Here’s a link to the post:
Integromat just updated its Airtable “Watch Records” trigger and you can now pick up in the trigger field your “Last Modified Time” column!
Now, Integromat offers two different triggers for Airtable:
Best update so far done by Integromat :thumbs_up:
Sure, why not :slightly_smiling_face:
You can add a “Last Modified Time” column and set it up to watch only the changes made in your “Comments” column. Every time you update a cell in your “Comments” column, “Last Modified Time” will be updated, meaning you can trigger any action you want (like an outbound email).
Hi all, having a problem that might be along the lines of this thread so didn’t want to make a whole new one.
I use a formula field in Airtable that results in “Yes” if its between 9am and 5pm and 2 days before a clients appointment. This then appears in a view called “sending” that Integromat watches for new records in a view and triggers Clicksend to send a reminder sms, then checks a field called “Sent”, removing it from my airtable view “sending”
The problem is that because I use a formula to work out when to send the reminder text it doesn’t update the Last Modified Time as this only updates when editable fields change, not formula fields. Therefore Integromat doesn’t recognize it as a changed/updated/new record and doesn’t trigger and I end up with many records in my “Sending” view.
Any ideas on how to get integromat to trigger on the view? I know i can schedule the texts directly in Clicksend but then if i cancel or change an appointment in airtable it won’t update the sms in Clicksend.
thank you in advance!
Here is your solution:
Currently, you are starting your Integromat scenario with the “Watch Records” module.
But — you can actually START your Integromat scenario with the “Search Records” module instead!
So delete your “Watch Records” module and replace it with the “Search Records” module. You can start your entire scenario with that module.
Even though Integromat doesn’t list “Search Records” as a trigger, it can actually be used as your very first module.
Once you make “Search Records” your very first module, then you can simply schedule it to run on a schedule. Depending on what Integromat pricing plan you’re on, you can schedule it to run every 1 minute, every 5 minutes, or every 15 minutes. (Free plans are restricted to running every 15 minutes.)
Even better: Integromat lets you schedule which hours of the day, which days of the week, and which months of the year you want your search to run! So, you can even tell Integromat to only run your scenario on weekdays between 9am and 5pm!
You simply need to setup your “Search Records” module to perform whatever search you want it to perform! So, in your case, you would just tell it to search for any records that are currently set to “Sending”, and Integromat will always return your desired records — regardless of whether or not those records have their “last modified date” updated in Airtable.
From that point forward, every 15 minutes (or whatever interval you choose), Integromat will continue to perform that search! :slightly_smiling_face:
Integromat is pretty amazing!
Ah excellent suggestions :slightly_smiling_face: can’t tell you how grateful I am to find a clean solution to this and you have explained it so clearly.
I see the scheduling part in Airtable is just about redundant now, it was left over from when we used Zapier (don’t think scheduling is available in Zapier)
Glad I could help! :slightly_smiling_face:
Yes, that scheduling trick you were doing in Airtable is redundant.
And yeah, Zapier has very limited scheduling capabilities, although there is a sneaky little “scheduling hack” that you can do In Zapier which requires a paid Zapier plan:
But overall, Integromat is vastly superior than Zapier 95% of the time. The only real downside to Integromat is that if you rename a field in Airtable that Integromat uses, Integromat will no longer recognize that field and your scenario will fail. So just be sure to not rename your fields in Airtable, if those fields are used by Integromat.