Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Zapier trigger for updated field, not created.

Topic Labels: Automations
259 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sercle
4 - Data Explorer
4 - Data Explorer

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

2 Replies 2

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

Screenshot 2025-01-21 at 6.10.51 PM.png

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!

ScottWorld
18 - Pluto
18 - Pluto

@Sercle 

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