conditional for last recent gift online/offline

Options
Nikki Valentine Odens
Nikki Valentine Odens
Ancient Membership 10 Comments Photogenic Facilitator Level 3
in Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions

I sent and email with a conditional for a specific group that said "Thank you for your last gift on <date>!"

The conditional "Last transaction date," I assumed would pull from their record either online or offline gift. We had a donor

that was upset because it pulled his last online gift which was in 2009 and he had given money through mail in May of 2010.

On his constituent360 information is says last external gift was in May 2010. How come the conditional in the WYSIWYG didn't pull that information?

Does anyone know how I can get it to pull "Last external gift"  so it's works for both online/offline donations?

Thanks

Tagged:

Comments

  • Noah Cooper
    Noah Cooper
    Ancient Membership 1000 Comments 100 Likes Photogenic

    Last Transaction Date actually only pertains to online gifts. To display the most recent of Last Transaction Date and External Last Gift Date, you can do something like this:



    ]x]x::
         <!--last_trans_date is null, external_last_gift_date is null-->
    ::
    ]x::
         <!--last_trans_date is null, external_last_gift_date is not null-->
         ]
    ::
    ]x::
         <!--last_trans_date is not null, external_last_gift_date is null-->
         ]
    ::
         <!--last_trans_date is not null, external_last_gift_date is not null-->
         ]:YYYY-MM-dd]] ]:YYYY-MM-dd]] >]]::1::
              <!--external_last_gift_date is more recent than last_trans_date-->
              ]
         ::
              <!--last_trans_date is more recent than external_last_gift_date-->
              ]
         ]]
    ]]]]]]
  • Nikki Valentine Odens
    Nikki Valentine Odens
    Ancient Membership 10 Comments Photogenic Facilitator Level 3
    Noah Cooper:

    Last Transaction Date actually only pertains to online gifts. To display the most recent of Last Transaction Date and External Last Gift Date, you can do something like this:



    ]x]x::
         <!--last_trans_date is null, external_last_gift_date is null-->
    ::
    ]x::
         <!--last_trans_date is null, external_last_gift_date is not null-->
         ]
    ::
    ]x::
         <!--last_trans_date is not null, external_last_gift_date is null-->
         ]
    ::
         <!--last_trans_date is not null, external_last_gift_date is not null-->
         ]:YYYY-MM-dd]] ]:YYYY-MM-dd]] >]]::1::
              <!--external_last_gift_date is more recent than last_trans_date-->
              ]
         ::
              <!--last_trans_date is more recent than external_last_gift_date-->
              ]
         ]]
    ]]]]]]

    Thank you I will try this.

Categories