Don't know if anyone can help me with this but when importing is there a way you can tell IOM to not update a virtual field if a different non-virtual field is blank?
For example, in constituent attributes we may want to log the pets people have so on data files there will be a column that contains dog, cat, etc or will be blank if they don't have any. We have then used virtual fields to update the date and comments fields of the attribute but as we have used these it has amended the date and comments for all donors and not just the ones with a completed field. We kind of need something that says only update these virtual fields if column X in the main mapping is not blank.
Oooh that is an idea! Thanks Wayne, i'll give it a go.
Do you have any ideas for a similar issue I am having? We have a field for solicitor names which gets imported only when solicitors are listed. Any gifts that come without a solicitor are thrown out as errors and cannot be processed. Is there a way/rule I can create to enable the gifts without solicitors to be processed as well? Currently, we have to add these manually since they are being thrown out as errors.
Thanks in advance for your help!
What is the error? I would expect that if solicitor is blank then it would just not assign a solicitor.
Is solicitor required in your system?