Hey there,
I need to SELECT a signature image in an email template manually from another table like:
<<SELECT(TableName[signature], [id] = [_THISROW].[id])>>
But when the email template is generated, appsheet replaces the select with the image URL instead of the actual png.
What am I doing wrong?
What type is the “signature” column defined as?
Also, are you using the Email body section of your send Email task or are you creating a template document?
Thanks for your reply,
The signature field ist defined as the AppSheet signature type.
I am creating a template document
The SELECT() expression should be wrapped in ANY():
<<ANY(SELECT(TableName[signature], [id] = [_THISROW].[id]))>>