Auto-Enter Calculation not working...?
I have a 'Donation Acknowledgement' field that I'm trying to default to the contact's first and last name, but can be overridden, for example if the Donor wishes to be anonymous, or donation is in a company name.
So, I defined an auto-enter calculation:
contacts::donationacknowledgement = contacts::full_name, (checked Do Not replace existing value...) which is in turn a Calculation field, result text, unstored, = contacts::firstname & " " & contacts::lastname
starting a new record, the first name auto-populates into the Donation Acknowledgement field, but not the last, although the field contacts::full_name populates correctly
is it possible that the first name populates, then because I've checked the Do Not Replace tag, having the first name prevents the last name from populating?
further thought - DonAck only populates with the first entered of the two names.