Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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 doesn't recognize the column trigger

S
Forum|alt.badge.img

Hi Zapier community,

 

I am using mysql as a trigger (new or updated row), to catch if a status column is updated. 

I only want to trigger the zap if THIS ONE column has an updated value, but Zapier triggers if any column value is updated. This not only has caused a huge mess of emails being wrongly sent (they come as follow up actions) but has also cost me thousands of dollars in Zap actions being triggered for no reason.

 

I believe to be have set up the trigger column correctly. Is this a bug from Zapier?

 

Thanks

Elsa 

 

 

 

Best answer by Danvers

Hi @stylebase I can see that you continued your conversation with our Support Team and found that the likely culprit here is the way that the MySQL app recognises new and updated rows. 

For other users, if you’re seeing that a Zap using the MySQL trigger New or Updated Row is triggering on Rows that you don’t think it should, it’s likely that the issue is the way that the Zap is ‘deduplicating’ the data. Deduplication is how a Zap knows whether or not it’s seen a piece of information before, you can read more about how deduplication works in this help guide.

In the case of MySQL, Zapier only ‘sees’ the first 50 rows in the database so if the data is re-ordered or if the primary key/s are changed, Zapier will think that the data in the table is new and a ‘new item’ Zap will trigger. This help doc has more information on how deduplication works in MySQL, and how that can affect your Zap. 

To help with deduplication in MySQL, we strongly recommend using the ‘Order by’ field - generally you’ll want to use something that will order the data in reverse chronological order (newest to oldest), something like ‘created on’

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @stylebase 

Good question.

The MySQL New OR Updated Row will trigger under these conditions.

  1. Any NEW Row
  2. Any UPDATED Row for the designated Trigger column.

The Zap trigger is essentially a dual option, which is likely why your Zap did not execute as you expected.

To prevent NEW rows from executing in the Zap, you likely need to add a Filter as step 2 to detect NEW VS UPDATED rows.

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Forum|alt.badge.img
  • stylebaseBeginner
  • Author
  • Beginner
  • 8 replies
  • July 2, 2022

Hi Troy, 

 

Thanks for your answer. Unfortunately, this is not the behaviour I am noticing from Zapier. I am not adding any new rows but just modifying another column and the zap still gets triggered. 

 

I can see that in this one example below. It got triggered whereas I just modifying the column “main_photo”. Actually this line in SQL was created weeks ago. 

 

I’m pretty used to using the same functionality with google sheet and columns triggers don’t seem to behave accordingly here.

 

Any idea?

Thanks again

Elsa

 

 

Troy Tessalone
Forum|alt.badge.img+14

@stylebase 

Probably best to open a ticket with Zapier Support: https://zapier.com/app/get-help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
christina.d
Forum|alt.badge.img+9
  • christina.dZapier Staff
  • Zapier Staff
  • 2653 replies
  • July 11, 2022

Hey there, @stylebase! I can see you were able to open a ticket with support - which is perfect. Please continue to keep us in the loop with any solutions ya’ll are able to surface. We’d love to know! 

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • Answer
  • July 27, 2022

Hi @stylebase I can see that you continued your conversation with our Support Team and found that the likely culprit here is the way that the MySQL app recognises new and updated rows. 

For other users, if you’re seeing that a Zap using the MySQL trigger New or Updated Row is triggering on Rows that you don’t think it should, it’s likely that the issue is the way that the Zap is ‘deduplicating’ the data. Deduplication is how a Zap knows whether or not it’s seen a piece of information before, you can read more about how deduplication works in this help guide.

In the case of MySQL, Zapier only ‘sees’ the first 50 rows in the database so if the data is re-ordered or if the primary key/s are changed, Zapier will think that the data in the table is new and a ‘new item’ Zap will trigger. This help doc has more information on how deduplication works in MySQL, and how that can affect your Zap. 

To help with deduplication in MySQL, we strongly recommend using the ‘Order by’ field - generally you’ll want to use something that will order the data in reverse chronological order (newest to oldest), something like ‘created on’

 

Terms & Conditions