New answers tagged

0 votes

Test send in Marketing Cloud does not send email

Pretty sure that files must exist at the root of the Import folder for the AttachFile() function to work. Official docs are here. Update I'd suggest reviewing the NotSent tracking data. The Reason ...
  • 29.3k
0 votes

Email Greeting in Journey Builder giving a Set Script error

Curly brackets won't work in AMPscript syntax. I'd write it like this: %%[ set @firstName = AttributeValue("FirstName") set @LastName= AttributeValue("LastName") IF NOT EMPTY(@...
  • 29.3k
1 vote
Accepted

Struggling to debug AMPscript error

Try this: %%[ var @rowcount, @rowcount2, @rowcountset set @rowCount = DataExtensionRowCount("DE_1") set @rowCount2 = DataExtensionRowCount("DE_2") set @rowCountset = Add(@rowCount, ...
  • 13.7k
0 votes

Troubleshooting simple IF/Then Ampscript Statemend SFMC (Dynamic Header)

Your lookup function is missing an argument. You can read this reference to know how to use it. I don't know your DE construct, so I guess you can change something like this: SET @PropertyName = ...
  • 1,268
1 vote
Accepted

Pass querystring variable from one cloudpage to another

It seems you’re passing https://frefef.sfmc-content.com/xvk53leo4qh?%%=v(@lang)=%% which would resolve to eg. https://frefef.sfmc-content.com/xvk53leo4qh?fr So try adding the actual qs part: https://...
  • 13.7k
1 vote

PrimaryKey Violation - how to display error message on cloudpage

Unfortunately, you cannot "convert" 500 Error to "Phone already exists" message. Since the InsertData function would be already executed and thus always throw an error when the ...
  • 2,449
1 vote

PrimaryKey Violation - how to display error message on cloudpage

You have to use the [UpsertData] function instead of InsertData, you could add a timestamp field on your DE. So in your case, it will be : set @updatedDate = Now() upsertData("unsubs"...
  • 1,505
0 votes

SSJS - Creating HTML table from Lists pulled

the response from Gortonington look great, just one this if if (i = 1) should be if (i == 1) and also (i = allPublicationLists.length) should be (i == allPublicationLists.length) because its doing ...
0 votes

Query to Segment data based on different Category

I think you should pivot the numbered categories and count how many of each there are -- then you can simplify your criteria: CREATE TABLE categories ( [type] varchar(5) , category1 varchar(...
  • 29.3k
0 votes

XSLT error using TransformXML Function

I appreciate this is a very old item but here's a finding: It works if you encode your XML and XSLT with Base64 method. Create two content blocks of type Code Snippet in Content Builder. One is for ...
-3 votes
Accepted

If condition for empty date field

You need to call ENDIF inside the ampscript block and needs to set some value after THEN condition. Try like this %%[ IF NOT EMPTY(@RegistrationDate) THEN set @RegistrationDate=AttributeValue("...
1 vote

If condition for empty date field

You write, that you see the default date in the Ampscript code. Ampscript would never show a default date, if the data extension field and/or the variable is indeed empty. You don't write where or how ...
  • 19.1k
0 votes

How to use Claiming of coupon codes in relation to Triggered Send where claimed coupon code also needs to be passed to Triggered Send Data Extension

There is an AMPScript function to make sure that rows are only claimed once, exactly to prevent the issue you described. Its called ClaimRow. Please take a look. EDIT: If that doesnt resolve the issue ...
  • 536
2 votes

Semi Colon Separated Values into a List - AMP Script

You can do it using the BuildRowsetFromString function: %%[ set @list = "1 Orange;2 Apples;3 Peaches;5 Plums" set @rows = BuildRowsetFromString(@list,";") set @rowCount = ...
  • 13.7k
1 vote
Accepted

Swapping images out using AMPscript

You can simply use if/else statement to display HTML image block based on the Gender attribute value. For example: %%[ set @gender = AttributeValue("Gender") if @gender == "male&...
  • 1,268
1 vote
Accepted

Targeting a nested array with SSJS to use with a for in loop in Marketing Cloud

I believe you would need to parse the JSON first and then use a loop to write keys and values in the nested JSON. Try something like this in the email: (assuming the DE is using as the data source in ...
  • 1,268
1 vote
Accepted

SFMC Programming Language - AMPScript

Here are a few good ones. https://ampscript.guide/ - This is basically a more detailed version of the documentation https://ampscript.xyz/ - This has more specific use cases, but a lot of good ...
1 vote
Accepted

Multiple Filter Conditions on RetrieveSalesforceObjects

Unfortunately you can only match one value per field and there is no OR clause available for use when you add additional fields to match on, so you’d have to use a separate retrieve call for each of ...
  • 13.7k
1 vote

How to limit Send of an email to 1000 subscriber only using ampscript

Would it be easier if you set up a staging data extension and an automation to pull in 1000 users daily to limit the audience size, assuming you're sending the email through a journey? This way you ...
0 votes

Submitting HTML characters to a Data Extension via Landing Page and SSJS

Not sure if you still need this, but see my answer on this post. AMPscript to decode HTML entity in data extension field
0 votes

Pass a value via CloudPageURL that will populate a SmartCapture hidden field

You can supply a query parameter to the hidden field of a Smart Capture form by entering the following into the Hidden Attribute text field in the Salesforce Marketing Cloud editor. In this case 'uuid'...
1 vote

Invalid index (parameter 2) passed to Row function. (boolean values)

Your code won't handle result sets of less than 7 rows. You'll need to check the number of rows returned before you loop. %%[ SET @promo = Attributevalue('Is_promotion') SET @lookOrders = ...
  • 29.3k

Top 50 recent answers are included