+Praveen Seshadri [AppSheet] +Adam Stone [App...

expressions
(Levent KULAÇOĞLU) #1

@praveen @Adam_Stone_AppSheet @Philip_Garrett_Appsh @Aleksi_Alkio

Could there be a bug or issue with both the AS Editor and the Expression Builder today? I’m seeing some weird behaviours since you have announced the CONTEXT(“View”) and CONTEXT(“ViewType”) features. For example: Please take a look to the attached image. This is a simple LOOKUP expression which checks the USEREMAIL() value and return the value of a Virtual Column in the same table. Though there should be a value (because the USEREMAIL() is my own email), it’s returning an empty result.

If re-write the expression with “First Name” it correctly returns my name, however it does not return the _ComputedName value which is messing up my whole expression and returning incorrect results.

Appreciate if you can check this behaviour.

(Praveen Seshadri (AppSheet)) #2

Hi @Levent_KULACOGLU, could you give me a repro case in a specific app — I will investigate. The changes to add CONTEXT() functions does not have any impact on the rest of the expression system. So if there is a problem here, it is independent.