Hello, not sure I’m in the right place to ask this but I’m wondering if anyone has achieved the below using MySQL tables and Zapier
I have 2 connected tables, customers & leads with a column named cust__id.
When a client books a call externally via our website it contains fields from both tables.
What I need to do is, first insert the customer table fields (creating the cust_id), then insert the lead fields linking the cust_id.
So, when a booking is made online, a new customer and lead is created in Noloco linked by the cust_id.
If not, could I insert the booking form data into a Noloco temporary table, then run a workflow to achieve the same thing?
Thanks for reading