Dereference in a lookup in a template

[Stephen_Monagha]

Hello,

I am trying to put a dereferenced field in a lookup in a template and it doesn’t seem to work.

Does anybody know if this is supported? I know it’s generally supported, so maybe it’s just in templates it’s not supported.

e.g. <<LOOKUP([id].[name], Employee, Name, Address)>>

Note I’m doing it this way as a workaround for Double Dereference Expressions instead of creating the virtual column as detailed here https://help.appsheet.com/en/articles/1090811-dereference-expressions

Thanks
Stephen

[Aleksi · Accepted solution]

@Stephen_Monaghan I’m afraid it won’t work because you should actually write the formula like <<LOOKUP([_THISROW].[id].[name], Employee, Name, Address)>> and unfortunately that is not supported.

[Stephen_Monagha]

Thanks @Aleksi

Ok, I’ll go with suggested workaround with the virtual column.

[Aleksi]

Without knowing your table structure, it could be a normal column as well.