I had written the following article for the commuity but it was recently deleted: Boolean checkbox fields actually store the value 0 when unchecked (false) and 1 when checked (true).
Boolean fields are available to be used as tokens in emails and landing pages but by default they will just return 0 or 1 depending on whether or not the value is checked. This may not be very presentable to your leads, for example if you use a subscription centre where newsletters are checkboxes and you might want to send an email to subscribers showing them what they have and have not subscribed to. If you just use the token that represents the standard boolean field then the check mark you see in the above email will be a the number 1. In Admin go to field management click on New Custom field and you can create a new Marketo only field of type formula. You will add an if choice and specify the name of the boolean field like below This formula field looks at the boolean field and displays ✓ if the real checkbox field has been checked (True), if not it displays the default value ✘. So you would just need to replace the symbols with TRUE/FALSE.
This does not seem to work anymore as I can't see how to create a Marketo field only in the Field Management. Has anyone any other way to do this?
Nevermind. I'm dumb.
Retrieving data ...