About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Zapier Triggers before "Last modified Time" Airtable

  • 17 February 2023
  • 5 replies
  • 201 views
R
Userlevel 1
Badge

I have a few Zaps that run on “last Modified Time” within Airtable when a new record or updated record is created. 

problem is two are triggering before the “last modified time” is activated - so its causing a duplication of automations and burning my zap counts for the month.

My air-table is set up to first check mark what automations i need that will then filter the records into new views and then once in the view i check mark the automation to run which corresponds with the “last modified time” as described in my zap

Ive tried limiting the view but that triggers when the records enters that view

ive included a screen shot incase anyone can help but wanted to see fi any users have a similar problem with “last modified time” not actually working the way it should 


 

icon

Best answer by Troy Tessalone 17 February 2023, 03:48

View original

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Rlaurence83 

Good question.

You may need to adjust your View Filter conditions to prevent new/existing record from both triggering the Zap.

 

Also, you can further control your Last Modified field by limiting it to watch specific fields.

 

Otherwise, you can use Airtable Automations to have more control over trigger the Zap:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
nicksimard
Userlevel 7
Badge +11

Hey @Rlaurence83!

EDIT: Troy got to it just before me and offers some great tips :)

I’m not 100% sure I’m following what your Airtable workflow is. Could you clarify what the desired outcome is and how you’ve got Airtable set up?

Is the column you’re using for “last modified time” do you have it set up for all editable fields or specific fields?

Thanks!

R
Userlevel 1
Badge

Hey nick its set for a specific field.



I have a “all production” view that acts as the main source for all records. When i check mark “description needed” it will then filter into the next view. I am then checking “transcribe to text” which triggers the automation. It works well every time 

 

The issue is the zap will trigger when the record enters the view and again i checked the “transcribe to text” which is the last modified time for my zap. so thats why im confused.

its not a big deal but does use double the zaps intended for the automation as its ran twice. The first zap gives me different result as i require other process to happen first before i trigger the transcribe to text.

 

Hope this make sense - ive included some screen shots 

 

 

 

2 Attachments
Troy Tessalone
Userlevel 7
Badge +14

@Rlaurence83 

Try changing the View used in the Zap trigger to have Filter conditions that match for the records you want to trigger the Zap. (e.g. Text to Transcribe = checked)

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
R
Userlevel 1
Badge

thanks troy - ill work on this now - legend as always :) 

Reply


Terms & Conditions