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.