Mautic Community Forums

Multiple unique key fields

Hello

I have a doubt regarding unique key fields in Mautic. By default, “email” field is set as unique. If I add a custom field (for example “brand”) and set as unique, then will Mautic add separate contacts if any of these keys has a different value? I use tracking pixel for adding contacts.



Let me state an example here. Here both “email” & “brand” fields are set as unique



Scenario 1:

First added a contact with email as "xyz@xyz.com" and brand as “XYZ”

Then add a contact with email as "xyz@xyz.com" and brand as “ABC” (same email, but different brand)

Here will mautic add two separate contact details, or will merge it and set the “brand” field as “ABC”?



Scenario 2:

First added a contact with email as "xyz@xyz.com" and brand as “XYZ”

Then add a contact with email as "abc@abc.com" and brand as “XYZ” (same brand, but different email)

Here will mautic add two separate contact details, or will merge it and set the “email” field as "abc@abc.com"?



Can anybody provide any information on this? What I understand is that unique key is same as primary key. Please correct me if I am wrong.



Thanks & Regards

Sujith

Hello
I have a doubt regarding unique key fields in Mautic. By default, “email” field is set as unique. If I add a custom field (for example “brand”) and set as unique, then will Mautic add separate contacts if any of these keys has a different value? I use tracking pixel for adding contacts.

Let me state an example here. Here both “email” & “brand” fields are set as unique

Scenario 1:
First added a contact with email as "xyz@xyz.com" and brand as “XYZ”
Then add a contact with email as "xyz@xyz.com" and brand as “ABC” (same email, but different brand)
Here will mautic add two separate contact details, or will merge it and set the “brand” field as “ABC”?

Scenario 2:
First added a contact with email as "xyz@xyz.com" and brand as “XYZ”
Then add a contact with email as "abc@abc.com" and brand as “XYZ” (same brand, but different email)
Here will mautic add two separate contact details, or will merge it and set the “email” field as "abc@abc.com"?

Can anybody provide any information on this? What I understand is that unique key is same as primary key. Please correct me if I am wrong.

Thanks & Regards
Sujith