How to verify if a user is already in our DB and avoid to register him twice ?

Avatar

Avatar

gaëlm35210402

Avatar

gaëlm35210402

gaëlm35210402

03-12-2018

Hi everyone,

Could you help me with a basic option (I think). In fact I have a landing page where you could add your name, LN, email adresse and company name.
After that you are just registered in our database.

I would like to avoid duplicate users (based on their email adress, first and lastname).

1638023_pastedImage_1.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

06-12-2018

Hello Gael,

In that case , simply select  the operation as INSERT in the Update data activity (Database /newcomers for you) .

1640345_pastedImage_0.png

If you try to enter a email ID already present , it would throw an error .

Regards,
Adhiyan

Answers (4)

Answers (4)

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

05-12-2018

Hi Gael,

You can add a deduplication before you upload the data.

The workflow should look like this.

1639641_pastedImage_0.png

Inside the deduplication , you choose the columns where you want to deduplicate

1639652_pastedImage_2.png

Regards,
Adhiyan

Avatar

Avatar

gaëlm35210402

Avatar

gaëlm35210402

gaëlm35210402

05-12-2018

Hi Adhiyan ,

The think is this workflow is in a Web Application so I'm not able to use the "deduplication"

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

04-12-2018

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

03-12-2018

Hi Gael,

Good question! Moving this to the Adobe Campaign Classic forum for follow up since this forum is for Campaign Standard only.

All the best,

Pablo