Brian Dunning's FileMaker Custom Functions

Toggle ( state )

Simple toggle function, if the value passed is 1 the result is 0 and vice-versa

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

Ofir Gal   Ofir Gal - Show more from this author
Gal Consultancy

Share on Facebook Share on Twitter

  Sample input:
Toggle ( 1 )
  Sample output:

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

Simple switch toggle function, if the value passed is 1 the result is 0 and vice-versa. Doesn't use an if statement so should be faster. The only possible input and output values are 0 or 1.



Bob   Bob
Jan 14, 2010
How does this work, Is "State" a new FileMaker command I am not aware of yet?
Jonathan Mickelson   Jonathan Mickelson
Jan 14, 2010
Another pretty common way would be to use "not", ie:

not State

... kudos for working xor into a Filemaker Calc!!!


To answer Bob: State is just the author's parameter naming. It could also have been written like:

Toggle ( boolean ) = where "boolean" is a boolean number, 0/1.
Ofir Gal   Ofir Gal, Gal Consultancy
Jan 15, 2010
Jonathan - I like your way even better. I guess 'xor 1' and 'not' are the same thing if effect.

Sorry if me calling the parameter 'state' is confusing. Maybe I should change it to 'switch' instead?
john R   john R, birmingham UK
Jan 29, 2010
Interesting method
I use Abs ( state - 1 )
to do the same thing...

Presumably no real efficiency differences.

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: