SetWindowVar ( keyOrIndexOrPath ; value ; JSONType )

Set a global variable scoped to the current window

Be the first to rate this function Log in to vote

Jason Wood - Show more from this author
Define Database
https://www.definedatabase.com

Sample input:

SetWindowVar ( "hello" ; "world" ; JSONString )

Sample output:

{"Window name will be here":{"hello":"world"}}

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

/*
==================================================================
PURPOSE:
	Set a value to a JSON objet that is scoped to the current window.
       
PARAMETERS:
	keyOrIndexOrPath | string
	value | string
	JSONType | number (or keyword) - same as in JSONSetElement

RETURNS:
	(JSON) Copy of updated $$WINDOWVARS

NOTES & DEPENDENCIES:
	The $$WINDOWVARS will be updated immediately. When using in a script, you could use a "Set Variable" script step and setting to $$WINDOWVARS may aid readability, however this is not necessary and you could set to any variable, such as $blah, and it would still work.

CONTRIBUTORS
	JW / Jason Wood / Define Database / www.definedatabase.com

CHANGELOG
	2020-06-02 JW Created
	2021-03-21 JW Updated to overwrite existing global var if it is an invalid JSON object
==================================================================
*/

Let ([
  $$windowVars = If ( Left ( JSONGetElement ( $$WINDOWVARS ; "xalsdjfaluksdfjlnzvoiysehsz" ) ; 3 ) = "? *" ; "" ; $$WINDOWVARS ) ;
  $$windowVars = JSONSetElement ( $$WINDOWVARS ; Get ( WindowName ) & "." &  keyOrIndexOrPath ; value ; JSONType ) 
]; 
$$WINDOWVARS
)

See also: GetWindowVar() and DeleteWindowVar()

Works like JSONSetElement() but only one key, index, or path can be set at one time. You could chain together multiple SetWindowVar like:

Set Variable [ $blah ; SetWindowVar ( "hello" ; "world" ; JSONString ) & SetWindowVar ( "goodbye" ; "moon" ; JSONString ) ]

...just don't use the output directly from this calculation ($blah) as it will be invalid JSON.

Comments

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

SetWindowVar ( keyOrIndexOrPath ; value ; JSONType )

Comments

Support this website.

Support this website.