ShowValue ( text ; altText ) ( )
Function stats
Function overview
Prototype
Parameters
Description
Tags: Text Parsing
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"
Examples
Sample input
Sample output
Function code
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
*/
Case (
not IsEmpty ( text ) ; text;
altText
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/248
Prototype: ShowValue ( text ; altText )( text; altText )
Function Author: Chad S. (http://www.fmfunctions.com/mid/234)
Last updated: 19 February 2010
Version: 1
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
