When CiviCRM sends an email Recurring Donation Receipt below the Zip Code field there is a Comment field. What mySqlTable stores the string that shows in the Comment associated with a recurring donation?

  • Can you be specific when do you get these emails? Civi send different message template for different occasion, are you referring to email when a recurring donation is created or whensomeone updates the donation? – Pradeep Nayak Apr 2 at 15:02
  • When somebody makes a donation, or civi issues a recurring donation, both the donor and the administrator gets an email beginning text like: Contribution Information Item Qty Each Total Contribution Amount 1 $ 50.00 $ 50.00 Total Amount $ 50.00 Date March 30th, 2020 8:15 PM – Ben Bachrach Apr 2 at 18:16
  • So I assume it is made by: Contributions - Invoice That can be modified from Administer | Communications | Message Templates | but I cannot tell where it gets the text string to put in the comment line of the message. – Ben Bachrach Apr 2 at 18:18

By downloading the database as one file, and searching with notepad++ I found the comment in table: civicrm_note

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.