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 - Show more from this author
Abrazos Data Consulting
http://www.abrazosdata.com

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)

//AddressBlock [params: com,cont,a1,a2,a3,a4,c,s,z,ctry] =

//conditional company & contact lines:

TextStyleRemove (
Case ( not IsEmpty ( com ) and not IsEmpty ( cont ) ; Trim ( com ) & "¶Attn: " & Trim ( cont ) ;
Case ( not IsEmpty ( com ) and  IsEmpty ( cont ) ; Trim ( com ) ;
Case ( IsEmpty ( com ) and not IsEmpty ( cont ) ; Trim ( cont ))))
; AllStyles )

& "¶" &

//address lines:

TextStyleRemove (
Case ( not IsEmpty ( a1 ) ; Trim ( a1 ) & "¶" ) & 
Case ( not IsEmpty ( a2 ) ; Trim ( a2 ) & "¶" ) &
Case ( not IsEmpty ( a3 ) ; Trim ( a3 ) & "¶" ) &
Case ( not IsEmpty ( a4 ) ; Trim ( a4 ) & "¶" ) &
Trim ( c ) & 
If ( IsEmpty ( ctry ) ; ", " ; " " ) &                                    //non-US cities don't have comma after City
Case ( not IsEmpty ( s ) ; Trim ( s ) & " " ) & 
Case ( not IsEmpty ( z ) ; Trim ( z ) ) & 
Case ( not IsEmpty ( ctry ) ; "¶" & Trim ( ctry ))
; AllStyles )

//--Steve B. Gerow, Abrazos, Inc. 5/2007

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

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

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

Comments

Support this website.

Support this website.