CiviCRM Community Forums (archive)

I work with an organization that sponsors children overseas.  We have created contact records for each child.  We have created contribution pages for supporters/donors to donate to/sponsor that child.  How would I ensure that each donation via that particular child's contribution page is always submitted is in honor of that child's specific contact ID?  If we rely upon the donor typing in the honoree first name, last name, and email address, we get inconsistent results.

Thank you for any direction you can give me.

Paul

Adding to Kurund's post - the custom field should be in a custom data group "Used For" - "Contributions". Then you can easily search / export from Find Contributions "by sponsored child".

Speaking of this feature - is there anyway to NOT have civicrm create contact records for entries in the "in honor of" field? 

Yes.  A lot of people want to put someone in the "in honor of" section for our site.  Most of these for FPWR are kids (and we don't know all of them or have all of them pre-loaded into our system).  The system creates a contact record for "Joey Smith" with an email address for their parent ("Fred Smith"), because that is what people will enter in for the honoree email.  Fred is already in our db, but we get duplicate contacts in the sense that we have 2 records (fred and joey) with the same email.  So we have to clean these out on a weekly basis. 

I think it should be a switch - what do you think?  Or, help me come up with a better idea on how to handle it (perhaps look up the email address used, and log it as an activity on that record or something?)

But can't we link the honor_contact_id to the parent somehow?  That is what I was suggesting. So if we could have the user put in information about the child and the parent (if its a child they are honoring), then that would work?

On another note, it seems odd though that you would require this.  What if it was a donation in honor of someone deceased? Why capture contact information for a deceased person?

The problem we are running into here is that this logic creates a duplicate record every time.  So a user puts in an email address for the parent (who is already in the db), the systems doesn't check to see if that email exists on another record, it just uses it on the new record for the honoree.

We will figure something out.  In the meantime, what portion of the code is adding this record? What I would like to do is have it tag those as "honorees" or something so we can query them and clean them out.

Thanks

Jeff

Reproduced.

Created both a Household record on demo called: Claus
Created an Individual record on demo called: Santa claus

Both have email address for primary of santa@claus.com (it should not let me do this BTW without establishing a relationship between the records, but that is another topic)

Then i did a contribution and set the honoree to be "Fred Claus" with email of santa@claus.com

Demo created a Fred Claus contact with the same email.  So now I have three emails in the db all with the same primary email address.  We consider that to be a duplicate record. 

Jeff

Bingo - that was the issue for the individuals.  However, if there is a household with that email, it doesn't find it.  That is our biggest problem.  We have an admin who is converting our members into household records.  This logic appears to only be matching against individuals?