SetField ( InValue )

Set field to value, checks for value of "Empty"

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

Richard DeShong - Show more from this author
Logic Tools
http://logictools.com

Sample input:

SetField ( "test" )
Setfield ( "Empty" )

Sample output:

"test"
""

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

Case( InValue = "Empty"; ""; InValue )
/*
  Set Field to given InValue.
  Allows for variable = "Empty", which means <blank>.
  This is complementary to SetVar().
*/

~~~ 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

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

SetField ( InValue )

Comments

Support this website.

Support this website.