SuiteNumber ( Address1 )
Checks for Suite Number in Address Field
Be the first to rate this function Log in to vote
|Bradley B - Show more from this author|
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This custom function checks for various suite or apartment labels in an address field.
UPS and FedEx will allow shipments with Suite/Apartment numbers in the Address1 field, but have been fining us when we do so. They prefer suite numbers and apartment numbers in the Address2 field.
We made this function to try to help minimize the occurrence of suite or apartment numbers ending up in the Address1 field when we're drop-shipping thousands of shipments from Filemaker via NRGShip.
We use this custom function to flag possible offenders and request eyes-on review from staff, but we don't fully prevent shipments that meet this condition, because there are exceptions we've found that are still valid in FedEx/UPS.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.