Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Counting Blank Recipient Fields

Avatar

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidl14970702
Level 4

20-06-2018

We want to do conditional content based on if the recipient has "full" or "incomplete" data on their recipient profile. If recipient has fields that contain data and the count of those fields are >= 6, than the recipient has "full" data. Else if recipient has "incomplete" data.

So if testRecipeint1 has a firstName and lastName, and no other data points the count would be 2, and set the flag to "incomplete".

Most of the fields are from our custom recipient table. A few from our incoming form table and a few from the location table.

How can I count the fields that contain data and use that number to set a flag of "full" or "incomplete".

Two ways I am approaching it are:

1. JS activity in workflow, that uses queryDef to look up the fields and count them then write it to an empty enrichment. I just don't know what that query would look like.

2. Updating my custom Recipient table to add this field, and having the shema do the calculation, which I'm still lost.

Replies

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

27-11-2018

Hi David,

You can ask if a value IS NULL and much more like this: Adobe Campaign Help | Advanced expression editing

I hope this helps!

All the best,

Pablo