Questions about adding field as a unique constraint | Community
Skip to main content
New Participant
October 16, 2020
Solved

Questions about adding field as a unique constraint

  • October 16, 2020
  • 1 reply
  • 1707 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

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.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
October 18, 2020

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.

Katja_Keesom
Community Manager
October 19, 2020

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.