What I want to happen is if any of the leads that come in with these said zip codes I mark a checkbox stating that this is a hot lead.
Can this be done? I am very new to Validation rules or if this needs to be a trigger, please let me know
14 Antworten
Can you try this?
OR(
CASE(
LEFT( zipcode field name, 5),
33128, TRUE,
33129, TRUE,
33130, TRUE,
33131, TRUE,
33132, TRUE,
33126, TRUE,
33133, TRUE,
33134, TRUE,
33135, TRUE,
33126, TRUE,
33145, TRUE,
33146, TRUE,
92604, TRUE,
92648, TRUE,
92656, TRUE,
92663, TRUE,
92691, TRUE,
92525, TRUE,
85008, TRUE,
85014, TRUE,
85016, TRUE,
85018, TRUE,
85253, TRUE,
22030, TRUE,
22180, TRUE,
22046, TRUE,
22102, TRUE,
22101, TRUE,
20190, TRUE,
20170, TRUE, FALSE
),
CASE(
LEFT( zipcode field name, 3),
750, TRUE,751, TRUE,752, TRUE,753, TRUE,754, TRUE,770, TRUE,774, TRUE,775, TRUE,779, TRUE,785, TRUE,765, TRUE,767, TRUE,786, TRUE,787, TRUE,789, TRUE,900, TRUE,901, TRUE,902, TRUE,904, TRUE,800, TRUE,803, TRUE,806, TRUE,808, TRUE,810, TRUE,940, TRUE,943, TRUE,944, TRUE,950, TRUE,951, TRUE,919, TRUE,920, TRUE,921, TRUE,275, TRUE,276, TRUE,281, TRUE,282, TRUE,913, TRUE,922, TRUE,923, TRUE,924, TRUE,925, TRUE,940, TRUE,941, TRUE,945, TRUE,946, TRUE,949, TRUE,100, TRUE,112, TRUE,111, TRUE,104, TRUE,103, TRUE,079, TRUE,088, TRUE,071, TRUE,073, TRUE,021, TRUE,020, TRUE,022, TRUE,024, TRUE,211, TRUE,212, TRUE,210, TRUE,200, TRUE,208, TRUE,222, TRUE,191, TRUE,080, TRUE,190, TRUE,198, TRUE,194, TRUE,085, TRUE,086, TRUE,088, TRUE,189, TRUE,089, TRUE,070, TRUE,078, TRUE,074, TRUE,075, TRUE,076, TRUE,110, TRUE,113, TRUE,114, TRUE,115, TRUE,116, TRUE,117, TRUE,118, TRUE,105, TRUE,106, TRUE,107, TRUE,108, TRUE,068, TRUE,069, TRUE,066, TRUE,601, TRUE,602, TRUE,603, TRUE,604, TRUE,605, TRUE,607, TRUE,608, TRUE,611, TRUE,654, TRUE,530, TRUE,531, TRUE,532, TRUE,534, TRUE,535, TRUE,537, TRUE,538, TRUE,539, TRUE,540, TRUE,541, TRUE,542, TRUE,543, TRUE,544, TRUE,545, TRUE,546, TRUE,547, TRUE,548, TRUE,549, TRUE,550, TRUE,551, TRUE,553, TRUE,554, TRUE,450, TRUE,451, TRUE,452, TRUE,453, TRUE,454, TRUE,410, TRUE,470, TRUE,471, TRUE,472, TRUE,473, TRUE,483, TRUE,481, TRUE,482, TRUE,480, TRUE, FALSE
)
)
