ShowValue ( text ; altText )

Attempts to show a value, if it's empty, shows an alternate value

Average rating: 4.8 (29 votes) Log in to vote

Chad Sager
IT Solutions Consulting, Inc.
http://www.itsolutions-inc.com/Filemaker

Sample input:

ShowValue ( Student::LastName ; "No Last Name" )

Sample output:

No Last Name

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

/*

NAME:	ShowValue ( text; altText )
CREATORNAME:	Chad Sager, IT Solutions Consulting, Inc.
CREATOREMAIL:	chad.sager@itsolutions-inc.com
DATE CREATED:	 2010-02-18
DATE LASTMODIFIED:	 2010-02-18

PURPOSE:	to show a value if it exists and if not, use an alternate. 

PARAMETERS: 
text - the text you want to display
altText - an alternate text to show if the primary text is empty

IMPORTANT NOTES:	remember if you want any or all the parameters to be empty, just use "" (double quotes)


EXAMPLES:

ShowValue ( Student::LastName ; "No Last Name" )

Will return an "No Last Name" When last name is Empty

ShowValue ( Student::LastName ; "No Last Name" )

Will return an "Smith" When last name is "Smith"


*/




Case ( 
	not IsEmpty ( text ) ; text ; 
	altText 
)

PURPOSE: to show a value if it exists and if not, use an alternate.

PARAMETERS:
text - the text you want to display
altText - an alternate text to show if the primary text is empty

IMPORTANT NOTES: remember if you want any or all the parameters to be empty, just use "" (double quotes)

EXAMPLES:

ShowValue ( Student::LastName ; "No Last Name" )

Will return an "No Last Name" When last name is Empty

ShowValue ( Student::LastName ; "No Last Name" )

Will return an "Smith" When last name is "Smith"

Comments

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

ShowValue ( text ; altText )

Comments

Support this website.

Support this website.