I'm creating an import profile for a file which contains just the appeal ID of a gift (i.e. not campaign and fund), and am mapping it to the Master ID gift field, so that the default campaign and fund can be picked up.
However, I would like to conditionally add a constituent code based on the campaign ID of the gift. Obviously this field is not present in the file - I'm wondering whether there is a nice way to do this by using the Master ID in the API somehow?
If not, I guess I could create a dictionary of appeals and campaign codes, and then use a virtual field for campaign ID. In fact, if I leave the Function blank, I guess this could be step 1, and then step 2 would be referring to that virtual field in the API to create the cons code.
Thoughts on any other ideas/potential pitfalls gratefully received!