SetVariable ( varName ; varValue )

Use when you want to set a variable with a variable name or not in a script.

Be the first to rate this function Log in to vote

Paul - Show more from this author
Peak 14 LLC
http://www.peak14.solutions

Sample input:

SetVariable ( "foo" ; "bar" )
SetVariable ( "$foo" ; "bar" )
SetVariable ( "$$foo" ; "bar" )

Sample output:

1
1
1

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

/*
 *  CUSTOM FUNCTION
 *    SetVariable ( varName ; varValue )
 *
 *  DESCRIPTION
 *    Use when you want to set a variable via a custom function
 *    Make sure to check FileMaker for valid variables names: https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help%2Fnaming-fields.html%23wwconnect_header
 *
 *  PARAMS
 *    varName: The name of the var to set
 *    varValue: The value of the var to set
 *
 *  RETURNS
 *    True
 *
 *  DEPENDENCIES
 *    --NONE--
 *
 *  CHANGELOG
 *    2020-03-04: Paul McCudden (paul@peak14.solutions): Created
*/

Let (
  [
    ~varName = If ( Left ( varName ; 1 ) <> "$" ; varName ; "$" & varName );
    ~letStatement = Evaluate ( "Let(["&~varName&"="&Quote(varValue)&"];1)" )
  ];

not IsEmpty ( Evaluate ( ~varName ) )

)

If you exclude a "$" at the start of the varName, it will create a local variable. If you want to make a global variable, add "$$" to the start of varName.

Comments

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

SetVariable ( varName ; varValue )

Comments

Support this website.

Support this website.