Download report - Pull from "Salutation" field for "Greet" column
The "Greet" column in a Download report is really handy for the "Dear ___" at the start of a letter. However, it pulls in data from the First Name fields, rather than the Salutation fields.
Also, Download pulls in only one Salutation field per household.
Therefore, we store salutations (Jim instead of James) in the First Name field, instead of the Salutation field, so that the Greet column uses the correct name for a greeting.
This is confusing! -- And worse: When our members make a donation online, they often enter their formal first name in the First Name field (James instead of Jim), because that's what's on their credit card. Since we use the First Name field for Salutations, they end up inadvertently creating a duplicate record for themselves.
Please sign in to leave a comment.