Allow 'Replace' transformation option to include operators for 'greater than', 'less than' and 'between'
It would be great to be able to specify a range in order to have more conditional behavior within the 'Replace' transformation. For example, if I want to assign the gift letter code or acknowledgement status based on the gift amount.
-
Kim Leblanc commented
Currently there is no way to use transform to check numeric fields for specific content. For example, if I want to check a gift amount field to see if it is eligible for a receipt or if I want to check to see if a gift date is greater than a specific date - I can't currently do that. This feature would meet some very basic needs in transformations.
-
Megan Gartner commented
Transformation logic around comparison values (greater than, less than, in-between, etc.) would be great. In one scenario this could be used if you're assigning Con Codes to constituents based on a specific gift amount (< 50 would be a "Low Donor Amount")