Listing credited solicitors in a daily gift digest

Sam Lucchese

Hi,

Does anyone know how to go about adding the field in a daily gift digest that will show all the credited solicitors on a gift? We're trying to add the solicitor name to a table using the "append to array variable" action.

Alex Wong

here are the outlined flow on how to do it:

• init variable type array for Gift Digest info
• init variable type array for Gift Fundraiser (fundraiser = solicitor in the world of webview)
• list gift
• apply to each gift in list gift
  • apply to each fundraiser in the fundraiser array (list) within a gift
    • get a constituent for the constituent id of the fundraiser
    • append to array variable of Gift Fundraiser the name dynamic content from the get a constituent action
  • ……do other stuff…..
  • append to array variable of Gift Digest with information you want to show
    • for Fundraiser, you will use the join(variables('Gift Fundraiser'), '<br>') if you are going to show the table directly in email and want each name to be on its own line
  • set var Gift Fundraiser variable to empty array to reset it for next gift
• create html table
• send email