- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 09:16 PM
Hello,
I would like to create a Zapier automation to notify us when a client changes details of a field in our shared Airtable.
As we use forms, it seems to set the "Last Modified Time" aswell as the "Created" time, so I cannot just create a simple view to show me only records that have a "Last Modified Time".
Is there a workaround in Zapier? or is there a formula I could use to say "If last modified time is greater than created time etc etc"
Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 21, 2025 02:12 AM
Hmm, could you talk more about the business logic and how edits are made? Do clients have access to an Interface or something?
In this screenshot, I've got the 'Last modified' field pointing at the 'Name' field, and the formula is:
{Name - Last Modified} > Created
And so any modifications to the 'Name' field directly would cause the formula to update. This would only work the first time an edit was made though, so if your business logic requires multiple updates and notifications we'll need to think of something else
You also mentioned that you're using forms? Not really following that bit though, sorry!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 21, 2025 03:50 AM - edited ‎Jan 21, 2025 03:50 AM
You said that your users are making changes through an Airtable form? There is actually a much better way of doing what you’re trying to do.
The best and easiest and quickest way to make record updates through a form is to use Fillout’s advanced forms for Airtable.
Fillout is 100% free and offers HUNDREDS of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form.
Then, you can simply use Fillout’s Workflows to alert you every time an update was submitted. This is also 100% free.
You would never need to use Zapier at all. However, for future reference, I should alert you that the Airtable community has mostly moved away from Zapier to Make’s advanced automations.
Make is INFINITELY more powerful & customizable than Zapier, yet it is SIGNIFICANTLY CHEAPER than Zapier. I wrote an entire post here comparing Make vs. Zapier.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
