function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Julien CampJulien Camp 

Zip Code Ranges in Process Builder Formula

Hello,

We're assigning California zip code ranges to certain Internal User Contact records and wish to do ranges of zip codes. I know how to write  <= zip code value, but how does one do a range in a Process Builder formula? Example: 

Currently, assigning all zip codes less that 96199 to a certain Contact record:

IF(AND(90000 <= VALUE([Lead].PostalCode ), (VALUE([Lead].PostalCode) <= 96100)), 
"00550000003UwhH",

... but want to change this and assign this Contact record the following California Zip ranges instead:

90000 – 90899, 91000 – 92899, and 93000 – 93599

Anyone have an idea how to do this?

Thanks!
Julien
Alain CabonAlain Cabon
IF(
  OR(
   AND(90000 <= VALUE([Lead].PostalCode ), (VALUE([Lead].PostalCode) <= 90899)), 
   AND(91000 <= VALUE([Lead].PostalCode ), (VALUE([Lead].PostalCode) <= 92899)), 
   AND(93000 <= VALUE([Lead].PostalCode ), (VALUE([Lead].PostalCode) <= 93599)), 
​  )
   "00550000003UwhH",
Julien CampJulien Camp
Thanks so much - will try this!
Alain CabonAlain Cabon
IF(
  OR(
   AND(90000 <= VALUE([Lead].PostalCode ), (VALUE([Lead].PostalCode) <= 90899)), 
   AND(91000 <= VALUE([Lead].PostalCode ), (VALUE([Lead].PostalCode) <= 92899)), 
   AND(93000 <= VALUE([Lead].PostalCode ), (VALUE([Lead].PostalCode) <= 93599))
​  )
   "00550000003UwhH",

There was an useless comma after  93599))
Karan K 15Karan K 15

Thank you so much, above scenario gave me a solution
Was building an assignment scenario of Account owner based on state and zip code in process builder

Task was 
>=90001 & <=92327 Southern CA - Sheila 
 >=92329 & <=92382 Southern CA - Sheila 
 >=92385 & <=92386 Southern CA - Sheila 
 >=92391 & <=93199 Southern CA - Sheila 
 >=93205 & <=93206 Southern CA - Sheila 
 >=93215 & <=93216 Southern CA - Sheila 
 >=93224 & <=93226 Southern CA - Sheila 
 >=93240 & <=93241 Southern CA - Sheila 
 >=93249 & <=93255 Southern CA - Sheila 
 >=93285 & <=93286 Southern CA - Sheila 
 >=93301 & <=93424 Southern CA - Sheila 
 >=93427 & <=93449 Southern CA - Sheila 
 >=93451 & <=93510 Southern CA - Sheila 
 >=93518 & <=93519 Southern CA - Sheila 
 >=93523 & <=93524 Southern CA - Sheila 
 >=93527 & <=93528 Southern CA - Sheila 
 >=93531 & <=93539 Southern CA - Sheila 
 >=93543 & <=93544 Southern CA - Sheila 
 >=93550 & <=93599 Southern CA  - Sheila 
 =93203,93220,93222,93238,93243,93263,93268,93276,93280,93287,93516 Southern CA -Sheila 

Solution i prepared because of above discusion 
( ((90001 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 92327 )) ||
   ((92329 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 92382 )) ||
   ((92385 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 92386 )) ||
   ((92391 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93199 )) ||
   ((93205 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93206 )) ||
   ((93215 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93216 )) ||
   ((93224 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93226 )) ||
   ((93240 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93241 )) ||
   ((93249 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93255 )) ||
   ((93285 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93286 )) ||
   ((93301 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93424 )) ||
   ((93427 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93449 )) ||
   ((93451 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93510 )) ||
   ((93518 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93519 )) ||
   ((93523 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93524 )) ||
   ((93527 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93528 )) ||
   ((93531 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93539 )) ||
   ((93543 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93544 )) ||
   ((93550 <= VALUE([Account].BillingPostalCode ))  && ( VALUE([Account].BillingPostalCode ) <= 93599 )) ||
    CONTAINS([Account].BillingPostalCode , '93203') ||
    CONTAINS([Account].BillingPostalCode , '93220') ||
    CONTAINS([Account].BillingPostalCode , '93222') ||
    CONTAINS([Account].BillingPostalCode , '93238') ||
    CONTAINS([Account].BillingPostalCode , '93243') ||
    CONTAINS([Account].BillingPostalCode , '93263') ||
    CONTAINS([Account].BillingPostalCode , '93268') ||
    CONTAINS([Account].BillingPostalCode , '93276') ||
    CONTAINS([Account].BillingPostalCode , '93280') ||
    CONTAINS([Account].BillingPostalCode , '93287') ||
    CONTAINS([Account].BillingPostalCode , '93516') )
 

 

THIS WORK FOR ME 
Cheers to you guys