I am sending an email for a couple of agents and my DE contains subscriberkey,emailaddress,agentemailaddress. I have a landing page where client's need to book an appointment with their respective agent.
I want to trigger an email to the agent with all the details of client's appointment as soon as they submit and the data inserted in DE.
Is there any way to do this?
Have you considered using Journey builder?
You can follow below steps to send an email to a contact
System will automatically trigger an email, as soon as a contact is updated in DE.
If you are familiar with AMPscript, this page has a great starting point: https://help.marketingcloud.com/en/documentation/ampscript/using_ampscript_with_the_web_service_api/create_a_triggered_send_using_ampscript_and_the_soap_web_service_api/
This page also has a breakdown of the code: https://etsalesforce.wordpress.com/triggered/
You can setup a smart capture form, and as soon as someone fills up the form, triggered email can be sent out to respective agent.
Please see below link on the form: https://help.marketingcloud.com/en/documentation/exacttarget/subscribers/smart_capture/
Thanks
If you already have a Landing Page, then the only way you have is to use AMPScript and Soap Webservice (as suggested by @eduardo)
Else, you can also use a SmartCapture form or CloudPages which will give you a direct option to send an email as soon as a record is entered into a DE
Lot's of ideas here, and unless you want to fire the event via the API there's really only one way I've found:
1) Upon form submit, use a triggered send definition to send the email
2) If there are journey requirements then use ampscript in the email in step one to insert a row into the entry DE
3) If there are engagement split requirements for the first email, you can overcome this with SQL Query and a tracking DE.
