The problem with this kind of โlate-boundโ expression is that the validity of the expression (eg: type checking) cannot be done until runtime. So it is tougher to be sure the app is correct and will run correctly. Many scripting languages are like this โ they are late-bound and so you get more flexibility but you also get fewer errors identified at compile-time.
In AppSheetโs case, we try really hard to check everything upfront (at โcompile-timeโ) because we do not want the app end-users having to decipher any errors, if they are avoidable. The downside is that we lose the flexibility of having loose column types and late-bound expressions.
LinkedIn
Twitter
