If I understood you correctly you can do it this way using loop
var @rows, @row, @rowCount, @counter, @5thMonth
set @rows = LookupRows("DE_name", "return", "1")
set @rowCount = rowcount(@rows)
for @counter = 1 to @rowCount do
set @row = row(@rows, @counter)
if @counter == 5 then
set @5thMonth = field(@row, "...
I'm not a fan of denormalizing product data into numbered columns. It makes everything more difficult, especially in SFMC where there are limited options for pivoting the data.
Tall and skinny tables are better than short and fat ones.
If you're only limited to 3 products, then you could do something like this:
Your request is understandable and requires several things:
Firstly, it is was not specified whether your form is actually a SmartCapture form of the custom one. For your case, it would be easier to create a CloudPage with a form that would be tweaked based on your needs.
Your case presumes dynamic validation of the input data into the form. In other words, ...
I'd recommend adding an AMPscript block at beginning of your email body and setting the subject there:
set @idCommanda = AttributeValue("idCommanda") /* check if this send context attribute has a value */
if not empty(@idCommanda) then
set @subject = concat("Comanda ta #", @idCommanda, " fost ...
Assuming you are using the new Web Studio that's based on content builder, then you don't want to use InsertData, instead you need to use InsertDE, then should fix the 500 error it is experiencing right now.
So, from my understanding Snapshotting is done in multiple different ways depending on context.
In Journeys, there is the snapshot of the data at entry for 'Journey Data'
In User Initiated Emails and Email Wizard sends, once the job is scheduled, it will run through all the relevant content blocks and functions to preprocess as much as it can ...
It’s easier if you just put this into one block:
if @HasOptedOutOfEmail == "on" then
If your field is a checkbox, use the condition if @HasOptedOutOfEmail == "on" because that’s the value that a checkbox will evaluate to. If it’s a different kind ...
You cannot trigger an email from within another email.
I’d suggest pointing the button to a CloudPage first. On the CloudPage include the script to trigger the notification email and at the end include a Redirect function to take the subscriber to the desired website:
The whole thing might take a split second ...
Not sure if what you’re asking is possible, but you might consider attaching the file instead using the AttachFile AMPscript function:
This function attaches the specified file to the outbound message or
displays a link to the file when included in a landing page. This
function returns no output.
Here’s an example of it’s usage from the ampscript.guide:
Your function AMPscript function - InsertData has 3 issues:
You did not set a variable for it;
At the very end you have double-quotes after the @age variable;
Also at the very end, after the @age variable you have a comma but there are no more additional attributes and values specified.
Thus, your function should look like this -
SET @insertData = ...
You can see different examples of having a button with a link in Email (will not allow to properly preview Button #4) or CloudPage and only Button #2 and #6 are not working, other variants should be sufficient for you to use:
%%[ SET @link = Lookup("DE_Name", "URL", "Field_identifier", "Value_identifier") ]%%
The fourth argument is like the field name for the first condition of a where-clause in a SQL statement. You could write your lookup in pseudocode like this:
Retrieve FIRST NAME from DE__Test where EMAIL = EMAIL
Also, you don't need to use a lookup if DE__Test is the sending data extension.
You can reference the send context column names directly or ...
The UpsertDE method can be used in sendable contexts, such as email messages.
UpsertData should be used in non-sendable contexts, such as landing pages.
"Updates or inserts information into a data extension as indicated by the array containing the listed column name and value pairs. This method adds the information if the data extension ...
I think the issue is in your CloudPage output as @Niko and @Gortonington have suggested.
It's worth mentioning that that are some subtle differences between the functions to pass values from an email to a CloudPage.
If I use the following link to test the methods for passing parameter values
-- where test and triggeredDate are columns in my sending data ...
This issue got resolved as soon as I added the line "account_id: MID" in the Auth Request. In my case the MID here belonged to a child Business Unit.
Not sure why this was required as the Installed App created was only suppose to interact with this Child Business Unit.
First of all, you can always troubleshoot your AMPscript in either email when you are previewing it or wrap the code with try-catch SSJS block and put error text into the Data Extension. Read more here.
Your script is correct from a syntax point of view (as long as you are filtering by correct ID value and the field names are correct), however, in February ...
If you’re using the new transacional API, then you shoudl be calling this route:
Here’s an example request:
Authorization: Bearer YOUR_ACCESS_TOKEN
Here are the reasons I can think of for your 404 response
Incorrect External Key
Incorrect route, is this a legacy triggered send or a new transactional messaging triggeredsend
Auth token is in the context of a different BU (IE token is for EID. TS is in CHILD BU)
You aren't making a POST but a PUT/PATCH
Your TSE endpoint is incorrect for the BU that has ...
This is a known issue with the CloudPagesURL function:
In your Email you want to redirect a Subscriber to a specific
CloudPage of your choice after clicking on a Button.
When you configure a Button within your Email, you have the option to
select the CloudPage directly. After selecting the CloudPage, the
Editor will automatically add the CloudPageURL ...
Where you have this row of code (just before the outputting HTML part) -
IF (@matchMindful == 1 OR @matchCruise == 1 OR @matchOutdoors == 1 OR @matchCityBreak == 1 OR @matchRomantic == 1) THEN ]%%
Change it to this -
IF (@matchMindful == 1 OR @matchCruise == 1 OR @matchOutdoors == 1 OR @matchCityBreak == 1 OR @matchRomantic == 1) THEN
SET @rowCounts = @...