zuzannamj’s gists

zuzannamj / ampscript-loop.html

Last active December 2, 2019 09:35

	<html>
	<body>
	Dear Customer,<br>
	Here are the details of your order:<br>

	%%[ var @rows, @row, @rowCount, @subKey, @counter, @orderItem

	set @subKey = _subscriberkey
	set @rows = LookupRows("Orders","CustomerId", @subKey)
	set @rowCount = rowcount(@rows)

zuzannamj / lookup-loop.amp

Created December 1, 2019 19:15

	%%[ var @rows, @row, @rowCount, @subKey, @counter, @orderItem

	set @subKey = _subscriberkey
	set @rows = LookupRows("Orders","CustomerId", @subKey)
	set @rowCount = rowcount(@rows)

	for @counter = 1 to @rowCount do /* repeat in a loop for as many times as defined in rowCount */
	set @row = row(@rows, @counter) /* get row based on counter */
	set @orderItem = field(@row,"OrderItem")
	]%%

zuzannamj / lookup-orderItems.amp

Last active December 2, 2019 11:33

	var @rows, @row, @rowCount, @subKey

	set @subKey = _subscriberkey
	set @rows = LookupRows("Orders","CustomerId", @subKey)
	set @rowCount = rowcount(@rows)

zuzannamj / apex-trigger

Last active November 25, 2019 11:33

	trigger Trig_CampaignMember on CampaignMember (after insert, after update)
	{ et4ae5.triggerUtility.automate('CampaignMember'); }

zuzannamj / triggered-send-wsproxy-personalized.html

Last active December 3, 2020 07:55

	<script runat="server">
	Platform.Load("Core", "1")
	var prox = new Script.Util.WSProxy();
	var tsExKey = '12345'; //pass Triggered Send External Key
	var EmailAddress = '[email protected]'; //pass Email Address
	var SubscriberKey = '[email protected]'; //pass Subscriber Key
	var firstName = 'Zuzanna'; //pass First Name

	var tsDef = {
	TriggeredSendDefinition: {

zuzannamj / triggered-send-ampscript-with-output.html

Created November 24, 2019 19:36

	%%[
	VAR @ts, @tsDef, @ts_extkey, @ts_email, @ts_sub, @ts_statusCode, @ts_statusMsg, @errorCode
	SET @ts = CreateObject("TriggeredSend")
	SET @tsDef = CreateObject("TriggeredSendDefinition")
	SET @ts_extkey = "ExternalKey" /* use the external key of the interaction for example SET @ts_extkey = "49078" */
	SET @ts_email = "[email protected]" /* provide recipient's email address */

	SetObjectProperty(@tsDef, "CustomerKey", @ts_extkey)
	SetObjectProperty(@ts, "TriggeredSendDefinition", @tsDef)

zuzannamj / WSProxy-updateBatch-regular-DEs-to-sendable.html

Created November 15, 2019 17:51

	<script runat="server">
	Platform.Load("core","1.1.5");
	try{

	var prox = new Script.Util.WSProxy();

	var de1 = {
	"CustomerKey":"xxxx-xxxx-xxxx-xxxx-xxxx-xxxx",
	"IsSendable":"true",
	"SendableDataExtensionField":

zuzannamj / WSProxy-batch-update-regular-DEs-to-sendable-same-structure.html

Last active November 15, 2019 19:19

	<script runat="server">
	Platform.Load("core","1.1.5");
	try{

	var prox = new Script.Util.WSProxy();
	var CustomerKey = []; //Create an array withh DE External Keys
	var IsSendable = "true",
	SendableDataExtensionField = {"Name": "email", "DataType": "EmailAddress"}, //Provide the name of the field used to establish a data relationship (SendableDataExtensionField relates to subscribers on SendableSubscriberField)
	SendableSubscriberField = {"Name": "Subscriber Key"}; //Use "Subscriber Key" or "Email Address" depending on whether the SUBSCRIBER_KEY business rule has been turned on.

zuzannamj / WSProxy-update-regular-de-to-sendable.html

Last active November 15, 2019 19:18

	<script runat="server">
	Platform.Load("core","1.1.5");
	try{
	var prox = new Script.Util.WSProxy();

	var CustomerKey = "xxxxx-xxxx-xxxx-xxxx", //Insert DE External Key
	IsSendable = "true",
	SendableDataExtensionField = {"Name": "email", "DataType": "EmailAddress"}, //Provide the name of the field used to establish a data relationship (SendableDataExtensionField relates to subscribers on SendableSubscriberField)
	SendableSubscriberField = {"Name": "Subscriber Key"}; //Use "Subscriber Key" or "Email Address" depending on whether the SUBSCRIBER_KEY business rule has been turned on.

zuzannamj / form-triggered-send-email.html

Created November 12, 2019 10:53

	<form class="smartcapture-content-wrapper fuelux" role="form" action="%%=RequestParameter('PAGEURL')=%%" method="GET">
	<span>
	<label for="email">Email:</label>
	<input type="email" class="form-control" id="email" name="email" value="%%=v(@email)=%%" required="">
	</span>
	<button class="sc-button" type="submit" name="Submit" id="Submit" value="Success">Submit</button>
	</form>

	%%[
	SET @email = RequestParameter("email")

Zuzanna Jarczynska zuzannamj