Battery Recall FileMaker Calculation -
2006-10-19 11:41 AM
I’ve come up with a quick FileMaker calculation to determine whether or not a 15” PowerBook battery is affected by the
recent recall:
Let([batBegin = Left(Battery Serial;2); batMiddle = GetAsNumber(Middle(Battery Serial;3;3)); batEnd = Right(Battery Serial; 4)];
If((Battery Model = "A1078") or (Battery Model = "A1148");
If((batBegin = "3K") and ((batMiddle ≤ 601) and (batMiddle ≥ 425)); "affected";
If((batBegin = "6N"); If((((BatEnd = "THTA") or (batEnd = "THTB") or (batEnd = "THTC")) and ((batMiddle ≤ 551) and (batMiddle ≥ 530)));"affected";If((batMiddle = 601) and (batEnd = "THTC");"affected";"")); "")))
)
If the battery is affected, this will display “affected” in the field. All you need are two fields: Battery Serial and Battery Model.
