Running into an issue with automations. The command is if zip code contains x then update Region to x (Ex: If zip code contains "77033" then update Region field to say "Region 7") . Some zip codes overlap multiple regions. I set the Region field to allow multiple values thinking that would resolve any overlap issues. The problem is if I have 77033 in both Region 7 and Region 8, then I want the Region field to reflect both 7 and 8. As you can see in the screenshot I have created 7 total automations for each region and have listed the zipcodes for each of the 7 regions under each command. The command is failing for zip codes that are under multiple regions.
Overlapping automations- need them to add two values to target field.
+1
+17- Employee
- 275 replies
@bryceran , from your use case, it sounds like the mapping of zip code to Region(s) is fixed. Have you considered using a linked record, where the region is a multi-select. Then when a new constituent zip code comes in, the region is looked up vs. calculated in an automation?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.