How to Create Personalization Points and Conditionally Run the Third One?

Let's say I have three personalisation points and I want the third one to run only if one of the columns from the first and two is empty How can I do it?

✅1

30 comments

Clay Team
APP
·
·
Let me check
Rohan J.
·
·
https://app.clay.com/workspaces/133851/tables/t_JkYly3oK1xSZ/views/gv_ZIuWzwqhFWDG
Rohan J.
·
·
In the Rohan Web description one
Rohan J.
·
·
I want that too run only if any from the previous 2 personalisation factor haven't got any results
Clay Team
APP
·
·
I see that you already used conditional formulas in the AI columns
Clay Team
APP
·
·
isn't that what you are looking for?
Rohan J.
·
·
Nope it's running in the whole column
Rohan J.
·
·
It should tell that run condition not met
Clay Team
APP
·
·

3d4a4edd-f3a1-4ddd-b8e3-5acd6606a2b2.png(41 kB)
Clay Team
APP
·
·

330fb72b-846e-41b7-9c9f-20428edb044e.png(70 kB)
Clay Team
APP
·
·
now its fine, you entered a double negative in the prompt
Rohan J.
·
·
Wait
Rohan J.
·
·
you did that in subject line one?
Rohan J.
·
·
No the subject line was good
Rohan J.
·
·
Please reverse it back
Rohan J.
·
·
I am talking about this Juan P.
Clay Team
APP
·
·
ok let me check
Clay Team
APP
·
·
reversed
Clay Team
APP
·
·
let me fix this claygent
Rohan J.
·
·
Thanks
Clay Team
APP
·
·
so if the 2 previous personalizations are blank and we have an email the claygent should run no'
Clay Team
APP
·
·
?
Clay Team
APP
·
·
currently says if personalization1 or personalization2 is blank run
Clay Team
APP
·
·
so if 1 is blank and 2 has data is running
Clay Team
APP
·
·
This should be the right formula:
0405b8c5-9cba-4c55-af31-5d5f57a6a97f.png(46 kB)
Rohan J.
·
·
Yeah so basically there are two personalisation trigger Let's say 1st got the data and 2nd didn't then it should run And if both data are present then it should not run
Clay Team
APP
·
·
Enter this prompt: If "email" is not blank AND "personalization1" is not blank AND "personalization2" is blank OR If "email" is not blank AND "personalization1" is blank AND "personalization2" is NOT blank
Clay Team
APP
·
·
map the variables and it should work
Rohan J.
·
·
Cool let me do that
Rohan J.
·
·
It worked Juan P. - thanks a lot

How to Create Personalization Points and Conditionally Run the Third One? | Clay