Your comparison is being treated as string (instead of number). You need to use "FormatNumber" function to treat the values as numbers.
IF @SalesTarget < @TotalSales condition can be rewritten as
IF FormatNumber(@SalesTarget,"G") <= FormatNumber(@TotalSales, "G") ...
Also, note that I have changed the operator from "...
Instead of passing a direct link, use the CloudPagesURL() function to redirect to the second CloudPage:
@FormURL = CloudPagesURL(123,”Id”,@contactID)
Above will append an encrypted query string to the url.
Read more here: https://ampscript.guide/cloudpagesurl/
I suspect the errors are in the format functions, not the lookup.
At least for the prices, I think I might have a suitable explanation as the problem pattern seems to be with German formatting:
In German, ',' not "." is the decimal separator in a number.
I think what you are seeing is numbers being rounded up when enforcing "whole numbers in ...
IF your URL will be
To use a metaphor, you are using a Hammer for driving in a screw. While sure this can be solved in pure AMPScript, it will get pretty ugly. The real recommendation is split your process in two parts: 1 = pre-process your data with SQL and work with a better data extension, simplifying step 2 = what's left in AMPscript.
So really, you have an SQL question ...
Forwards are a general topic that you cannot stop from happening, as FTAF (a specific function served by SFMC) is not the only way to forward an email. In fact, it is probably a rare exception, if implemented. If an FTAF link is implemented, you can do something, see end of post.
Most people simply press "forward" in their email client (...
I am always wary of processes that are meant to surface data on Cloudpages.
E.g. The email with your unique link could be forwarded by mistake (or found in a compromised inbox), exposing data - and worse, your smart capture in this case enables data changes for anyone who has the link, to anything they want.
This could be a severe security vulnerability, as ...
You might be able to use something like this. It basically sets a subject line when current date falls within a specific date range (holiday event etc) and then falls back on a default subject line for all other dates outside that range. I hope this helps in some way :)
* Current Date Logic
* Setting date variables to use in our ...
It is possible to get it working with AES too
The trick is block size 16, key size 32, pbkdf2 with 1000 iterations and padding pkcs7
from pprint import pprint
from Cryptodome.Cipher import AES
from Cryptodome.Protocol.KDF import PBKDF2
from Cryptodome.Util.Padding import pad
data = b'Example'
password = b'password'
salt = bytes.fromhex('...
Hope below is what you are trying to achieve!
Set @month = DatePart(NOW(), 'month')
SET @day = Datepart(Now(),'day')
IF (@month == 11 AND @day > 1) or (@month == 11 AND @day < 31)
SET @Subject= Concat('Test 1 ',@month,' ABC')
SET @Subject= Concat('Test 2 ',@month,' DEF')
%%=v(@Subject)=%% \\Test 1 ...
You basically have everything to achieve the desired result. Since you already have the English date version, then that is how the FormatDate function would look for the French version, you just change the 4th and last argument to the ISO locale code -
/* I gave a new name for French variables */
SET @EB1_End_Date_Formated_FR = FormatDate(@EB1_End_Date, &...
Change your function to UpsertData, UpsertDE only works in emails:
Capture Mobile Number of Customer who Reply STOP
Debug that with hardcoded values instead of variables to eliminate errors in empty vars, the function or the matching to the data extension.
If it works with hardcoded data, start making the variables @id , @email, @phone dynamic again one by ...
Your AMPscript code looks correct except the beginning where I am not sure why you are trimming JobID, ListID, and BatchID system strings when they are always going to be a numeric identifier without the leading and trailing spaces by default.
Answering your question, it seems that you have not quite fully understood how UnsubEvent logging works. What you ...
I'm finally able to achieve this through below solution.
Method : POST
If you take the /i/ url from your recommendation this will provide your with the product code being recommended
11965 is the product code. If you go to reporting >> admin tools you can search for ...
You need to understand how Claimrow function selects and claims rows. The lookup is based on the last pairs of variables you provide in the function call. If a row already exists with this data, it will be selected. Otherwise a new row will be claimed.
In your example, you are only sending the email address: