Questions about adding field as a unique constraint | Community
Skip to main content
jlee-4
Level 1
Oct 16, 2020 11:46 PM UTC
Solved

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
Oct 18, 2020 6:38 AM UTC

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 reply

2 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
Oct 18, 2020 6:38 AM UTC

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.

Translate
    Katja_Keesom
    Katja_Keesom
    Community Manager
    Oct 19, 2020 5:51 AM UTC

    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.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...