Full disclosure I am dummy when it comes to REGex. I know how to program, but REGEx escapes me.
I am working on an export and I want to look at an attribute field and if it's blank, replace it with the Raiser's Edge ID. If its not blank, replace it with blank. I am guessing the logic would be to create two virtual fields, one chaining off the other.
Normally, I would do this through the API, but we are hosted, no api!
Any ideas anyone.
We are moving to EveryAction and I am trying to set up integration. So for an example, I want to be able to look at a field in Raiser's Edge called EveryAction and if it's blank populate the first name field. I think I have figured out just like you it's not possible.
I have another question though: I have three fields; Do Not Contact, Requests No Email, and Do Not Email. If I use a dictionary to convert each value to NO, is there a way to combine these fields so they end up as one in the export?