Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 11, 2018 01:10 PM
We have MySql tables full of attributes, inventory, etc and want to sync this with Airtable multiple times a day. Not only new record additions, but also changes to data in existing rows.
If you have the skills to accomplish a sync of record updates and row additions, please message me or provide contact details and work reference.
Thanks!
Jun 11, 2018 01:34 PM
Hi Danny, we can help with this.
Ping me via email at dan@openside.com and I can provide more details.
Dan
Jun 11, 2018 03:11 PM
Sent you a message. Look forward to discussing.
Thanks!
Jun 12, 2018 06:11 AM
Hi Danny,
This is something that is well within my area of expertise and I would be glad to help you out.
You can reach me on andrewjohnson56782@gmail.com
Best Wishes,
Andrew
Jun 19, 2018 10:26 PM
Hey Danny,
I just finished building an application that does this. I can probably offer a solid solution with a custom Laravel App.
My application does the following currently:
Creates new records from mysql to airtable and it updates records every X minutes/hours.
It also has a link to execute updates on specific rows instantly
It also allows updating the database records from Airtable and a record of the changes made is kept on a separate Airtable for security reasons.
It’s pretty neat and something that is not possible to do with tools such as Zapier. You can reach me via contact%(at)%danielfarina.com
Cheers
May 24, 2023 07:51 AM
Leaving this here for anyone who comes across this in the future. There are some ETL solutions out there that solve this (workflow automation tools like Zapier don't suit this use case well).
Tools like Bracket track updates to existing cells, new rows, and even deleted content in both sources. So changes in Airtable are reflected in mySQL and vice-versa. You can also set changes to sync in only one direction if that fits your use case better too.