Update profile checkbox (no longer contact) via Update Data ETL for SMS BlackList

[AndrewKriz]

Hi,

Currently SMS Opt-Out only add mobile to the Address Deny list, which isn't picked up in the individual Profile records and missed on Profile output processes.

I've got a Workflow that queries the Address Resource, Reconciles to Profile records with matching mobile number and a Update node to update the "No longer contact by SMS" checkbox in that profile.

But I'm having a hard time having the update node to actually update that check box.  How do I get the "Fields to update" to actually update that checkbox?

Current logic:

Unsure of the 'mark' checkbox syntax or something missing.

Thanks in advance.

[SatheeskannaK · Accepted solution]

@AndrewKriz The source value of the fields to update section should be 1 and the destination is the field that you want to update. Since it's a boolean field it will accept 1 or 0 values.

[AndrewKriz]

Thanks, that was the solution.