Hi,

As a workaround to the issue of Insert scripts not triggering Zapier actions, I'm trying to update a form with data from another form via email as suggested by Damien in this post:

https://help.zoho.com/portal/community/topic/trigger-zapier-on-deluge-insert-into-function

but unfortunately I can't seem to get a syntax that Deluge likes.  I've checked the form email address and template I'm using and both look ok.  Here's the Insert function I currently use that works (but doesn't trigger Zapier) and the Sendmail function I'm trying to replace it with:

replacing the "insert into ...." with:

There are multiple records I need to process at a time and I currently trigger the Insert function from a Custom Action in a report.  I'm using C5 and have tried following the methods described in these links (they relate to pre-C5 but the functionality/syntax seems the same) but still no joy when I try to save either in a workflow or as a function:

https://www.zoho.com/creator/help/forms/email-data.html

https://www.zoho.com/creator/help/script/custom-actions.html

Can anyone shed any light on what I'm doing wrong or missing maybe?

Cheers,

Rob