We want to run a SQL automation immediately upon a new visitor filling out a web form and being newly added to a data extension. How could we achieve this? It seems that automations can only be triggered by file drops, or schedules to run hourly at best.
답변 3개
You can for sure also trigger an automation using the API. Knowing this, enables you to work with Ampscript/SSJS to trigger the automation immediately upon form submit.
However you must be cautious with building complex automations, as you can't start an automation which is already running. Here is a good article, explaining such a solution in a quite comprehensive way: https://ampscript.xyz/how-tos/how-to-start-status-of-automation-from-marketingcloud-form/