Gift Notification - I would like to add the following columns - Acknowledgement Letters and Fundraisers

Jundino Ugo

Hi there,

I'm trying to add the following columns in my gift notifications:

1. Acknowledgement Letter
2. Fundraiser Names

I used the same method I used to show Appeals and Funds using a String Variable. Should I be using array variables? I loop through each gift?

I searched the forums and I haven't been successful in finding a solution for both. Please help and thanks in advance.

Alex Wong

@Jundino Ugo
Acknowledgement letter inside an array call “Acknowledgements”, which is odd, b/c ONE gift should ONLY have ONE acknowledgement information, but that's a Blackbaud API definition issue, not for here.

You can use a string variable for acknowledgement letter as there will only be ONE. (use set variable action on the string variable and you won't need to reset the variable to “blank”).

Since the data structure for acknowledgement is an array, if you directly assign acknowledgements letter dynamic content to the variable, it WILL put the set variable action into a for each loop, which is OK, unless you want to deal with using first() expression to bring out the acknowledgements letter from first element of the array.

As for fundraiser name, are you talking about “gift solicitor/fundraiser” or are you talking about constituent fundraiser relationship

Jundino Ugo

@Alex Wong, thank you so much it worked! The letters are now showing in the column and I appreciated the explanation.

I'm looking for the Constituent Fundraiser. I'm able to grab the gift solicitor but I'm having trouble getting the Constituent Fundraiser. If I use the Fundraiser ID but there are three Fundraiser's assign can I filter the Fundraiser type and how?

Alex Wong

@Jundino Ugo
which action are you using to get constituent fundraiser?

you can always use the filter array action to filter the resulting fundraisers by the type.

Jundino Ugo

@Alex Wong Unfortunately, the screenshot below outputs all the Assigned Fundraisers. I do have to filter by Funrdaiser Type.

Alex Wong

@Jundino Ugo
yes, you can use filter array on the list of constituent fundraiser to filter on type that you want.

if you know that you can have multiple fundraiserw of the same type, then you will want to use an array variable (that will need to be “cleared” at the end (or beginning) of the outer for each loop that loop each gift) and append to the array varaible the name of the fundraiser (after using get constituent info on each fundraiser).

Jundino Ugo

@Alex Wong, Thank you so much! It's working! I really appreciate you taking the time to answer my questions!