Is it possible to call a column name in an ex...

(Benoit Gramond) #1

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])

(Aleksi Alkio) #2

I’m afraid that’s not possible.

(Benoit Gramond) #3

Might have been great for dynamisim!

(Praveen Seshadri (AppSheet)) #4

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.

(Benoit Gramond) #5


Sure, I understand the point.