Expand my Community achievements bar.

SOLVED

"Enable if" function - Update activity

Avatar

Level 3

Hi all,

we’d like to use on Campaign Standard the “enabled if” function in the update activities (tab. Fields to update).

How does this “enabled if” function work and behave with operation type INSERT OR UPDATE?

Thanks in advance

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @giuliap42357798,

 

It's working if i do the same thing with below,

SatheeskannaK_0-1659072619783.png

On the reconciliation activity, i have enabled link to profile resource using email field to know whether customer id exists or not on the profile.

SatheeskannaK_1-1659072751141.png

Update activity will have following,

SatheeskannaK_2-1659072849359.png

Try this and let me know if it works.

 

Thanks!

 

Thanks, Sathees

View solution in original post

4 Replies

Avatar

Community Advisor

Hi @giuliap42357798,

 

Take a look at below example screenshot where i used enabled if condition when email address IS NOT NULL then it will insert/update customer id in ACS.

SatheeskannaK_0-1658753428079.png

Thanks!

Thanks, Sathees

Avatar

Level 3

Hi @SatheeskannaK 
this is the status I have on Campaign:

Email

CustomerID

Title

test@gmail.com

01

 

test@gmail.com

 

 

 

I’d like to update just the row already present on Campaign with CustomerID field empty (the second row), in order to insert a valued title.

On the import file there are the email and title fields.
Trying to loading this file, reconciliating it through the email field, once that I set the update activity with operation type INSERT OR UPDATE and the Enable if condition on the Title field like this:

([target/@cusCustomerID] IS NULL OR [target/@cusCustomerID] = '')

The result I get is:

Email

CustomerID

Title

test@gmail.com

01

Mr

test@gmail.com

 

Mr

 

How should I do to update only the row with CustomerID empty?

Avatar

Correct answer by
Community Advisor

Hi @giuliap42357798,

 

It's working if i do the same thing with below,

SatheeskannaK_0-1659072619783.png

On the reconciliation activity, i have enabled link to profile resource using email field to know whether customer id exists or not on the profile.

SatheeskannaK_1-1659072751141.png

Update activity will have following,

SatheeskannaK_2-1659072849359.png

Try this and let me know if it works.

 

Thanks!

 

Thanks, Sathees