Brian Dunning's FileMaker Custom Functions

AddressBlock ( com ; cont ; a1 ; a2 ; a3 ; a4 ; c %3

Calculated Address block from separate fields - handles missing elements

  Average rating: 3.9 (36 votes) Log in to vote

Steve Gerow   Steve Gerow
Abrazos Data Consulting, Inc.
http://www.abrazosdata.com

Share on Facebook Share on Twitter

  Sample input:
AddressBlock(
Company;Contact;addLine1;addLine2;addLine3;$null;city;state;zip;Country
)
Note: AddressLine4 is not used, therefore $null placeholder is entered in place in field calc.
  Sample output:
Abrazos, Inc.
Attn: Steve Gerow
123 Main St.
Bldg 123
Mail Stop 123
Pasadena, CA 91105
USA

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Streamlines creation of multiple calculated name-address blocks.
Automatically closes up blank lines.
I've always found it easier to deal with a calculated address block for invoice headers, labels, etc., rather than with groups of individual fields.

Note: non-US addresses may need further development.

 

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.

Under construction. Email me your wish list for improvements.