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