Workflow logic for customers in Recipient table with Birthday date VS blank Birthday date and a different email to be sent. | Community
Skip to main content
M
MarioGlad
Level 2
December 1, 2021
Solved

Workflow logic for customers in Recipient table with Birthday date VS blank Birthday date and a different email to be sent.

  • December 1, 2021
  • 1 reply
  • 752 views

Hello Masters of Adobe,

 

Is it possible? If yes, what would be the logic in the workflow for the following tasks.

 

a) A workflow logic that will check if a customer's Birthday in the recipient table is empty/blank and send an anniversary email - different from Birthday email

b) A workflow logic that will check if a customer's Birthday date is in the recipient table and send a Birthday email - different from Anniversary email

I am aware that there is more than one way of addressing this, but I would appreciate any hints or solutions.

 

Thank you,

    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 ParthaSarathy

    Hi @marioglad ,

    you can achieve your logic in a single workflow using SPLIT activity.

    In Initial Query target your recipients

     

    In Split Activity, in subset tab define a filtering condition as birthdate is not empty (Refer below screenshot)

     

     

    And in General tab, Enable generate complement as below

    Now you can have 'Birthday Email' for 'Recipients with Birthdate' transition and 'Anniversary Email for 'Birthdate is Empty' transition.

    Regards,

    ParthaSarathy S 

     

    1 reply

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity AdvisorAccepted solution
    Community Advisor
    December 1, 2021

    Hi @marioglad ,

    you can achieve your logic in a single workflow using SPLIT activity.

    In Initial Query target your recipients

     

    In Split Activity, in subset tab define a filtering condition as birthdate is not empty (Refer below screenshot)

     

     

    And in General tab, Enable generate complement as below

    Now you can have 'Birthday Email' for 'Recipients with Birthdate' transition and 'Anniversary Email for 'Birthdate is Empty' transition.

    Regards,

    ParthaSarathy S 

     

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      Terms & ConditionsAccessibility statement

      Loading footer...