Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 08, 2024 10:40 AM
Hello
I have a lookup field that lists every area code in each time zone. These are listed by zip code within each time zone so there are a ton of repeats. You can see them in the area_codes field:
I've tried to create a formula field (UniqueAreaCodes) to remove all the duplicates but as you can see it is still outputting some duplicates. I have tried ARRAYUNIQUE(area_codes) as well as
Any advice is greatly apprceiated.
Feb 08, 2024 03:44 PM
Hi @Mike_Thorington,
What fields are "area_codes"?
It seems that a single record may contain multiple codes.
If it is one code per record, there should be no problem.
Feb 08, 2024 05:42 PM
The fields that area codes are in are individual zipcodes. Think of the zipcode you live in and all the surronding zip codes. They will all have the same listed area code(s) in that area. Some overlap, some are very large areas with 1 area code. So there will be many area codes of the same number listed per zipcode
For example:
Feb 12, 2024 11:03 AM
It is possible to have more that one code per record to follow up.