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.
As specified in the error, Your SELECT(), used in the way it is used, MUST return a list of REF values - i.e. Row Keys. Think of the Row Key as a "pointer" to the row and in this case a LIST of "pointers". So change "...SELECT(photos[photos]..." to "...SELECT(photos[Row Key]..." where Row Key is the name of the key column in your photos table.
The START/END then loops over each of those rows that meets the criteria of [Ticket] = [_THISROW].[TICKET].
In the body of the START/END, you simply reference the columns normally.
I do wonder how [photos] is defined? Is it a list of photos. I am not certain how that might look.
so the photos is added into a seperate table when they are taken with the ticket number as a ref column
then the ticket table has all the fluff detail in about the ticket i tried using the row ID now and it works but also doesnt XD
the images are not showing up and i did do the while Turn off require image and file URL signing
do you think it might be an issue because the initial table i use is not the main table its because i want it to update when a description is added to this table
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |