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

Updates to customer records in mySQL database not triggering Zap

  • 11 August 2021
  • 2 replies
  • 239 views
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.

icon

Best answer by SamB 11 October 2021, 15:01

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

SamB
Rank
Userlevel 7
Badge +11

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
Rank
Userlevel 7
Badge +11

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