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.

I am trying to create a zap from a database.  Right now, I can get the Zap to add an event on the calendar.  but I would like the calendar to update the event when the row is changed.  While i couldnt figure out how to do that, I was trying to 1. create an event, 2. on an edit, delete the past event, 3. create a new event.  I just can’t figure this out.  

Hi @danny0!

So, it sounds like you’re end goal is to a) create a calendar even when a row is added to a database and then b) update that event if the database is updated - is that right? 

You don’t mention which apps you’re using for the calendar or database, so for now I’m going to assume that you’re using the two most common ones (that we see on Zapier) Google Sheets and Google Calendar. 

This is possible, and the first thing that you need to do is to add a column to your Google Sheet, the name of teh column should be ‘event ID’

Zap 1

  1. Google Sheets: New Spreadsheet Row
  2. Google Calendar: Create Detailed Event
  3. Google Sheets: Update Spreadsheet row - For the row to update, select the ‘Custom’ option and use the row ID from the row that triggered the Zap. The Create Detailed event step will give you an event ID, add that ID to the end of the row. 

 

Zap 2

  1. Google Sheets: New or Updated row
  2. Google Calendar: Update event - to select which event to update, choose ‘Custom’ and use the event ID that will be in the row from when the event was created

I hope that all makes sense, if you’re using different apps or if you need some clarification, let me know!

 

 

Yes, that is correct.  I will try this today.  The only difference is my database is in MySql.  Please let me know if that changes any of the Zaps

going through the steps now.  Here is a short video of what I have so far.  It says it can’t send a row to mysql.  

Here is a video so far

 

Hi @danny0 

Sorry we missed your reply! Did you get this sorted or do you still need some help?

Still need help

@danny0 

In that bottom field - it looks like you’re mapping the wrong field - it should be the ‘Row ID” from the trigger.

Can you take a screenshot of that step.

Terms & Conditions