Boolean | “from [null] to [true]” or “from [false] to [true]” | Community
Skip to main content
Dennis_Thomsen
Dennis_Thomsen
Level 2
November 10, 2021
Solved

Boolean | “from [null] to [true]” or “from [false] to [true]”

  • November 10, 2021
  • 1 reply
  • 4208 views

Hello,

 

Can someone explain the logic behind this Marketo Boolean Field / Activity log behaviour.

 

Depending on what changes the value of the field (form fill or smart campaign) for the very first time to [true] the Activity log will show different “Previous Values”.

 

If value is set to [true] via 

 

1) A form fill (Field Type: Checkbox) … then activity log will state that value was changed “from [null] to [true]”

2) A Smart Campaign with flow step “Change Data Value” to “true” … then activity log will state that value was changed “from [false] to [true]”

 

Why is that?

 

I currently have a triggered SC: Data value changes on the boolean field with 2 constraints:

 

1) New value: true

2) Previous value: false

 

The different behaviour has caused problems since the form fills does not result in the triggered SC being fired. It’s probably safe to just remove constraint 2 since it seems redundant but I just want to be sure and understand what is going on with this behaviour?

 

Thanks

Dennis

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

A Marketo Boolean field is nullable. That is, it has 3 values: true, false, and the special value null, as in JSON null or SQL NULL.

 

And different Marketo layers have different ways of serializing user input into final Boolean values. For example, form fields always start as Strings (just as with native HTML forms), while the REST API supports, but does not require, Boolean true/false/null from the start.

 

So what you’re seeing is an artifact of how each layer (though not entirely accurately) represents the original value. As you said, you can just leave out the Old Value constraint.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
November 10, 2021

A Marketo Boolean field is nullable. That is, it has 3 values: true, false, and the special value null, as in JSON null or SQL NULL.

 

And different Marketo layers have different ways of serializing user input into final Boolean values. For example, form fields always start as Strings (just as with native HTML forms), while the REST API supports, but does not require, Boolean true/false/null from the start.

 

So what you’re seeing is an artifact of how each layer (though not entirely accurately) represents the original value. As you said, you can just leave out the Old Value constraint.

Dennis_Thomsen
Dennis_ThomsenAuthor
Level 2
November 10, 2021

Thanks for answering Mr. Whiteman. 

 

I find it rather confusing that a previous data value will be logged differently depending on the source of the value change. Another one of those "you just need to know" Marketo quirks I guess.

 

At least now I know 🤷🏻‍♂

 

🙏 Thanks again

Terms & ConditionsAccessibility statement

Loading footer...