Hi so I've been struggling with this for a bit now and tried multiple ways i used the add attachment tab by the email and either my app freezes or it only shows one image using [_THISROW].[Ticket] and all the variants you can think of in it
so I decided to use Chatgpt maybe thinking it could help and it suggested using html
<p>Hello,</p>
<p>Here are the images you submitted:</p>
<<Start: SELECT(photos[photos], [Ticket] = [_THISROW].[Ticket])>>
<img src="https://www.appsheet.com/template/gettablefileurl?appName=YOUR_APP_NAME&tableName=photos&fileName=<<[photos]>>" width="300">
<<End>>
this just makes me get a key reference error and im stumped
Task 'Send Notification' Body template. Start expression 'SELECT(photos[photos], [Ticket] = [_THISROW].[Ticket])' should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the 'Key' column of the referenced table.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |