SOLVED

Questions about adding field as a unique constraint

Go to solution
Highlighted
Level 1

Questions about adding field as a unique constraint

Hi, I was wondering about this situation and I found the answer in this post: https://nation.marketo.com/t5/Product-Discussions/Add-Field-to-Unique-Constraint/m-p/171236#M121709

but I also wanted to know if we were to change the unique constraint to be email AND first and last name, what would happen if the name fields were blank ? Would it input as null? would it input as empty string? or would it just outright fail to process?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Level 10 - Community Moderator

Re: Questions about adding field as a unique constraint

In practice, when it comes to String fields on the Person/Lead in Marketo, there is no difference between null and the empty string. (This is not the case for Custom Object fields, where true null-ness can be differentiated from empty-ness.)

 

The lead will be considered to have empty LastName/FirstName and a form post will still be processed, not rejected.

 

I would be extremely wary of using a compound dedupe key, especially this one.  It's a recipe for dirty data.

View solution in original post

2 REPLIES 2
Highlighted
Level 10 - Community Moderator

Re: Questions about adding field as a unique constraint

In practice, when it comes to String fields on the Person/Lead in Marketo, there is no difference between null and the empty string. (This is not the case for Custom Object fields, where true null-ness can be differentiated from empty-ness.)

 

The lead will be considered to have empty LastName/FirstName and a form post will still be processed, not rejected.

 

I would be extremely wary of using a compound dedupe key, especially this one.  It's a recipe for dirty data.

View solution in original post

Highlighted
Level 3

Re: Questions about adding field as a unique constraint

I couldn't agree more. So far in situations I have seen where compound dedupe keys were allowed based on a specific use case, a lot of unwanted and unanticipated dupes were introduced as well. It becomes pretty messy to control.