I have set up a new instance with formulas enabled for testing. A few initial thoughts as I get going: • I find differentiating between "text" and "single value" value types in the builder rather confusing to start with. • I find the function of

APPEND

versus

CONCAT

confusing. I normally think of appending values to an array, while I think of concatenating strings together, but

APPEND

operates on strings and

CONCAT

operates on arrays. Perhaps

APPEND

could operate on both types, and a combination of them?

APPEND(str, str) => str, APPEND(array,array) => array, APPEND(array, str) => array

• I get why you have to use

OBJECT()

and

ARRAY()

constructors but it feels clunky versus what we'd do in a scripting language. I'd much rather enter

{ "field1": [1,{"fieldA": 7},3] }

than

OBJECT("field1", ARRAY(1,OBJECT("fieldA", 7),3))

With the

assign

tag apparently removed, how do we assign temporary variable values within loops, where that value may change during evaluation, so it can't be put in the

local values

pre-compute section?