Update fields with blank values
We would like to have the functionality for Omatic Cloud to update fields with Blank values in from Luminate --> Salesforce and vice versa from Salesforce --> Luminate. Blank values have meaning in both of our databases so this functionality would be extremely useful.
Megan McMahon
shared this idea
-
Alok Das
commented
There are situations where a particular value needs to be updated to another value for thousands of profiles, so it makes sense to offer the option in Omatic Cloud mapping's transformations option. We can get the same thing done, but going over to Database View > Admin > Global Change
If the move to Webview is to be successful, some of these options need to be ported over, FAST. -
Emelie Scott
commented
Currently we use Mailchimp Integration with Raiser's Edge and while we import addresses as is we like to go in and clean them up. Some of the addresses have funky information in them that shouldn't be there such as "FAKE ADDRESS". While it gets the donation in we don't want that sitting in our DB. It would be nice to have the functionality to have the option to overwrite existing information with blanks. For the most part we appreciate that Omatic doesn't overwrite existing with blank as some of our formulas aren't bringing in that info or donors don't fill it out on each form so it would be beneficial to have the option on which fields to overwrite with blank and when to do that.