|
DonBrown
|
August 7, 2018 at 9:03 am
Hello
I have found that Zapier has a “Trigger App” called MySQL.
Once you connect the MySQL Trigger App to your WordPress MySQL database, you can trigger on an event and ZAP that content to another Zapier App (like Google Contacts, or Google Sheets, or anything else.)
However, to trigger the MySQL App, it asks for several pieces of information which I need help with. They are:
Table/View: (I think I should use: 117_esp_attendee_meta)
Primary Key: ?? what should I use here
Order By: ?? what should I use here
Trigger Column: In my case, I will trigger on ATT_email, because when someone adds a new email to the registration system, I want to Zap their information to my Google Contacts database.
Please help me identify which Database Table Fields I need to use for:
Table/View:
Primary Key:
Order By:
Thanks for your help,
Don
|
|
Josh
|
August 7, 2018 at 9:33 am
Hi Don,
I think you’re correct in that you’d use _esp_attendee_meta table. The Primary Key for that table is the ATTM_ID column.
I do not know what you’d put in for the Order by column, because I’m not sure why it needs something for order by. You could probably put ATTM_ID or ATT_ID in for that one.
|
