Allow Entry If No Calculation

July 7, 200619 yr

I have a nested case set in my address book that returns one of three counties if the zip code falls in certain ranges. If the zip code does not match any of the ranges I set up in my calculation, is there a way to let the user input the county himself? I guess I'm asking how one could enter text into a calculation field, or if that's possible.

Here's my calculation, FWIW:

Case (Student Zip ≥ 98130 and Student Zip ≤ 98288; "King";

Student Zip ≥ 95602 and Student Zip ≤ 98293;"Snohomish";

Student Zip ≥ 98329 and Student Zip ≤ 98499; "Pierce")

The problem with this method is that zip codes don't exactly line up with counties, and we may have a student with an outside zip. So can I make the field ultimately completely modifiable by the user?

July 7, 200619 yr

Have you tried using an auto-enter calculation so the calculated value can overridden?

July 7, 200619 yr

Author

That seems like a good idea, but when I try to do it, the whole thing is borked. For some reason, using the exact same calculation as an autoenter for a field makes it so that it doesn't work (every county is returned as King). Do calculations work differently when used as auto-enter?

Thanks so much -

Daniel

July 7, 200619 yr

1) be sure to uncheck the box: "Do not replace existing..."

2) the calc must be so modified, assuming that the name of this field is "CALCULATION":

Case(

Student Zip ≥ 98130 and Student Zip ≤ 98288; "King";

Student Zip ≥ 95602 and Student Zip ≤ 98293;"Snohomish";

Student Zip ≥ 98329 and Student Zip ≤ 98499; "Pierce";

CALCULATION

)

July 8, 200619 yr

The second point is not a good idea, IMHO. There are 3 counties with known zip codes. Suppose a student has the zip code "98130", which returns "King". Now the student moves to another county, and the new zip code is "99999". Entering a new zip code with no match should leave the County field empty, ready to be filled manually. The suggested formula would re-enter "King".