We have 300 or so contributions that are missing a custom field. We want to manually update those records. We are running a search for contributions that have a custom field but are missing the custom field we want. We run a search builder.
- Contribution - Custom Field 1 - = - Attribute
- Contribution - Custom Field 2 - Is Empty
- Contribution - Date Received - > - ##/##/####
- Contribution - Amount - > - 1
I run the search and I find the 300 or so contributions. I can only update each record by clicking on the contact, going to their contributions, finding the contribution, edit the custom fields. If I try to update multiple records - I can only update the contacts - not the contributions. So I add them to a group - run a contribution search for the date range and limit to only the group. Now I have over 700 contributions as those contacts may have given multiple times. I can bulk update the contributions now with a profile - but I now have to sift through half the contributions that do have the correct custom field chosen and find only those that are blank.
Is there a better way to do this?
Export/Import is not a good solution.