Is it possible to update a boolean field within a data extension when an email is sent?

2018-02-06 03:45:44

I'm trying to update a boolean field in the sending data extension from false to true when an email is sent to a subscriber. Could I use AMPscript to achieve this?

You can achieve this using the AMPscript function UpdateDE(1,2,3,4,5,6). You can find the full documentation including an example in the marketing cloud documentation on UpdateDE

Example:

UpdateDE("YourDataExtension",1,"_SubscriberKey",_SubscriberKey,"YourBoolean", "True")

  • You can achieve this using the AMPscript function UpdateDE(1,2,3,4,5,6). You can find the full documentation including an example in the marketing cloud documentation on UpdateDE

    Example:

    UpdateDE("YourDataExtension",1,"_SubscriberKey",_SubscriberKey,"YourBoolean", "True")

    2018-02-06 05:31:46