I have become aware today that any instances where I have a LOOKUP() inside of another lookup and similarly nested SELECT() statements across multiple apps are producing seemingly random, nonsensical results all of a sudden. Is this a known issue support is working on?
It seems Appsheet’s parser has begun having trouble with nested lookups() unless [_thisrow]. is appended in front of the lookup values, according to support. That seems to have fixed my issues.
You really should always use `[_THISROW]', for this very reason.