Brian Dunning's FileMaker Custom Functions

SetVariableƒ ( _variableName ; _value )

Assign a value to a dynamically named global variable.

  Average rating: 3.7 (3 votes) Log in to vote

Michael Rhodes   Michael Rhodes
Allied Data Service
http://allieddataservice.com

Share on Facebook Share on Twitter

  Sample input:
SetVariableƒ ( "customerID" ; 14 )
  Sample output:
14 // and sets $$customerID to 14

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

Assign a value to a dynamically named global variable. Replicate this function and remove 1 $ sign to make it declare a local variable. Does not return a value.

 

Comments

19752   19752, Japan
Mar 20, 2017
This retuns _value, and raise error if _value contains "
 
Michael Rhodes   Michael Rhodes, Colorado Springs, USA
Mar 20, 2017
Not any more. Also, it now validates the variable name.
 
19752   19752, Japan
Mar 21, 2017
So now you use Quote(), then don't need Substitute()
 
Michael Rhodes   Michael Rhodes, Colorado Springs, USA
Mar 21, 2017
Thanks for pointing that out.
 

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.