I thought I had discovered a bug with JSON, but it turns out that I was wrong. I have a script like this: Set Variable $N = ValueCount(...) // $N = 44 [... do some calculations ...] Set Field Table::Foobar // Suddenly, $N = 2 What's going on is that this table has a calculated field: Ta…

Further testing suggests it's a very simple issue - in a script, if something (such as a Set Field step) causes another calculated field to update, any $variables used in the calculated field's calculation will be in the same scope as $variables used in the script. It doesn't require repeating …

You should note that $var variables are scoped to scripts. You can define a $var variable in a let statement in a field calculation, however when a script runs with the same $var variable and the table is in context, both are one and the same.

[image] xochi: when editing scripts, the Set Variable script step automatically adds $ to variable names -- if you enter 'N' you get '$N' The set variable step always adds a $ character to the variable name. That's the recommended scope. You are able to add a second $ character to create a gl…

@Malcolm - thanks! Here's my project file: variable_scope.fmp12 (368 KB) [image] Malcolm: This seems like a nasty bug to me. Will you report it? I'm still unsure about this - the behavior is really unexpected to me, but maybe everyone knows that's how it is supposed to work? I appreciate…

This is a bug that could have serious consequences. No-one wants to have values from field calculations bubbling up into their scripts. It is an excellent reason to ensure that you limit the scope of your variables as tightly as possible. In your case, the variable $N can be more tightly scoped by…

reminds me of this thread: [image] Local variables defined in layout objects live long and travel widely Lounge (Discussions) The FileMaker documentation says : When you define a variable, you can specify its scope by adding a prefix before the variable name. Scope P…

FMScript handles scope not the same way other known languages like C, C++, C#, Swift, Java etc. do. The scope of a $-scoped variable is the executed script, that of a $$-scoped variable the executed file and variables declared in functions that have no $ or $$ scope designator have the function as …

This can also happen when using the Data Viewer: Overriding Variables using the Data Viewer And applies to Custom Functions as well. hey @MonkeybreadSoftware - would it be possible to create a feature to audit our calc fields and scripts? Warning: Table::FIeld is a calculated field which uses…

if you see a custom function with a local variable assigned or embedded in a statement / expression within then run as fast as you can!

Scope of $variable in Let statement in Calculated Field

Questions

harvest October 20, 2022, 4:45am 10

reminds me of this thread:

3 Likes

Topic		Replies	Views
Local variables defined in layout objects live long and travel widely Lounge (Discussions) security , layout , variables	27	1197	May 15, 2022
Is this possible Questions community	16	419	August 30, 2020
Code formatting question Questions scripting	22	746	January 5, 2024
Local $variable inside a Single Step button calculation Questions calculations	7	193	February 18, 2024
Check Variables for Let MBS Plugins plugin , variables , mbs	3	232	November 4, 2023

Scope of $variable in Let statement in Calculated Field

Related topics