1. Insert a summary field to determine how many gifts there are
    • Insert  > Summary
    • Field to summarize: Gf_IDKEY
    • Type of summary: Distinct Count
    • Summary location: Group based on Constituent (ex: GfCnBio_SortKey)
  2. Create a formula for the word "donation"

    if count({Gf_IDKEY}, {GfCnBio_SortKey})=1 then "donation"
    else if count({Gf_IDKEY}, {GfCnBio_SortKey})>1 then "donations"

  • Delete the word "donation" from the text box and insert the formula field