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

Updates to customer records in mySQL database not triggering Zap

K

I am trying to trigger an update to my CRM system when a customer’s detail record is updated in the mysql database (i.e. address, phone number, email, etc). The zap doesn’t trigger when it just an update to an existing customer record.    The data is stored across multiple tables (i.e. phone table, email table, etc) and all tied back to the customer ID.

Best answer by SamBBest answer by SamB

Just wanted to follow up here as spotted that our Support Team added @keithw to a bug report where the New or Updated Row trigger defaults to looking out for any changes (new or updates) made to the column that is selected in the Order By field, when the Trigger Column field is left blank. 

We’ll be in touch by email as soon as this bug has been fixed. In the meantime, the workaround suggested by Support was to create copies of the Zap and set them to have different Trigger Columns selected so that each update is seen. Not ideal I know, but should help to ensure that updates aren’t missed! :)

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.

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • August 16, 2021

Hey @keithw,

Thanks for reaching out about this and welcome to the Communty! :)

I can see that you’ve also reached out to our Support Team and they’re helping you with this. If you’re still experiencing issues with your Zap not triggering, I’d recommend continuing to troubleshoot this with them on that Support email thread. They’ll be able to look into the detailed logs and Zap’s setup to investigate further!

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • October 11, 2021

Just wanted to follow up here as spotted that our Support Team added @keithw to a bug report where the New or Updated Row trigger defaults to looking out for any changes (new or updates) made to the column that is selected in the Order By field, when the Trigger Column field is left blank. 

We’ll be in touch by email as soon as this bug has been fixed. In the meantime, the workaround suggested by Support was to create copies of the Zap and set them to have different Trigger Columns selected so that each update is seen. Not ideal I know, but should help to ensure that updates aren’t missed! :)

Terms & Conditions