Random image - corresponding text

Question

Is there a way to display text that corresponds to random image in another part of an email? My code so far: VAR @random, @num1, @num3 SET @num1 = 1 SET @num3 = 3 SET @random = random(@num1, @num3) ]%% %%[IF @random == "1" THEN ]%%

%%[ELSEIF @random =="2" THEN ]%%

%%[ELSEIF @random =="3" THEN ]%%

%%[ENDIF]%% Couldnt find what i needed here - unless i missed something Showing random image in email

zuzannamj · Accepted Answer

This will display text under the image: %%[IF @random == "1" THEN ]%%

Some random text related to image 1

%%[ELSEIF @random =="2" THEN ]%%

Some random text related to image 2

%%[ELSEIF @random =="3" THEN ]%%

Some random text related to image 3

%%[ENDIF]%% If you need to display the text in a completely different place, just add it to the main script: %%[ VAR @random, @num1, @num3, @text SET @num1 = 1 SET @num3 = 3 SET @random = random(@num1, @num3) IF @random == "1" THEN set @text = "some text 1" ELSEIF @random =="2" THEN set @text = "some text 2" ELSEIF @random =="3" THEN set @text = "some text 3" ENDIF ]%% %%[IF @random == "1" THEN ]%%

%%[ELSEIF @random =="2" THEN ]%%

%%[ELSEIF @random =="3" THEN ]%%

%%[ENDIF]%% And include %%=v(@text)=%% anywhere where this text should be displayed.

Gortonington · Answer

What I might do to account for potential growth of random information, is to store all the information inside of a data extension.

I would have the following in the DE:

ID   |   ImageURL   |   Text
---------------------------------
1    | myImageURL1  |  Some Text1
2    | myImageURL2  |  Some Text2

Where ID is the primary key of the DE. This would store all the dynamic info you want associated together, so you can add/remove fields as needed.

Then inside the email, I would do the same Random function, but I would also do a LookupRows() and then set the values via ROW() and Field().

See below:

First, you need to get the size of the DE for the @max value using DataExtensionRowCount function:

SET @min = 1
SET @max = DataExtensionRowCount('myDE')

This will set the total number of rows in the DE to the max for the random function.

Second, you will gather the random number via AMPScript:

SET @random = Random(@min,@max)

This will grab a random number between 1 and the row count of your content DE. For the sake of this example, let's say the number is 3.

Next, now that we have the random number, what do we do? We then do a LookupRows() to retrieve the row from your DE.

SET @randRS = LookupRows('myDE',"ID",@random)

Finally, this will then return a rowset of the identified record. You can then use Row() and Field() to gather the info you need.

SET @row = Row(@randRS,1)
SET @image = Field(@row,"ImageURL")
SET @text = Field(@row,"Text")

You then just put the image/text as variable calls. Like so:

<img src="%%=v(@image)=%%" />
<p>%%=v(@text)=%%</p>

no need to use any if statements, etc.

%%=v(@text)=%%

no need to use any if statements, etc.

Random image - corresponding text

2 Answers

Add your own answers!

Ask a Question