Brian Dunning's FileMaker Custom Functions

SetVar ( InValue )

Assign value to a variable, making sure variable exists if value is empty.

  Average rating: 4.9 (14 votes) Log in to vote

Richard DeShong   Richard DeShong
Logic Tools
http://logictools.com

Share on Facebook Share on Twitter

  Sample input:
SetVar ( "test" )
SetVar ( "" )
  Sample output:
"test"
"Empty"

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

~~~ Design Notes ~~~

This is part of a series of SET functions:
SetVar and SetField

These are all designed to work with variables and to
keep the variables from being un-set (removed from memory),
by using the string "Empty" to indicate IsEmpty().

Example:
If a field, MyField, is empty and I use SetVar(),
MyVariable = SetVar( MyField )
Tnen MyVariable is now = "Empty".

These are related to a series of LIST functions.
ListAdd, ListAddUnique, ListExist, ListGet, ListToggle.

Which are designed to work with variables and the "Empty" idea.

~~~

 

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.