In our business process, we have dividied up the State of Michigan into 9 routes that we service with an internal field staff and one region we service using UPS / FedEx. The 9 routes are not distributed by county but rather by zip codes. I was going to use a formula field to assign the appropriate route to Lead records using the commands IF and CONTAINS (i.e. IF (CONTAINS ( "48114:48116", PostalCode ), "Route-4",). However, using this technique, I will surely exceed the 1300 character limit for formula fields.

 

Considering the formula technique is not an option, I am assuming this function can be accomplished using an S-Control. However, I have no experience creating S-Controls and as such will need (prefer) to outsource this work.

 

If you are interested in creating an S-Control for this function, please contact me directly or by replying to this posting.

 

Thanks.