Is it possible to call a column name in an expression? I need to Lookup in another table with the same column name for many columns.
For ex LOOKUP([_THISROW], table, column, [_THISCOLNAME])
Iโm afraid thatโs not possible.
Might have been great for dynamisim!
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.
Sure, I understand the point.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |