Brian Dunning's FileMaker Custom Functions

SuiteNumber ( Address1 )

Checks for Suite Number in Address Field

  Be the first to rate this function Log in to vote

Bradley B   Bradley B - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
SuiteNumber (Address1)
  Sample output:
1

  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.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.