Disply images from an enumlist in an email

[mark8adams]

I'm having no luck displaying images in an appsheet email that actually start in a google form.  The form response column adds up to 10 image urls in a comma delimited list.  When appsheet is working with that column of comma-delimited values, I can't seem to extract the individual image URLs and display them as images (or links) in an email.  I either fail with <<start:>><<end>> because the list items are not 'ref', or I get a text value displayed for the URL (not a link or image) in my email.  I've tried all of my available AI tools and they give up and tell me to talk to you. Any suggestions?

[Suvrutt_Gurjar · Accepted solution]

If you could share how the enumlist column populate in the backend sheet, it will help to better suggest.

In general you may want to try

<<INDEX([Image Enumlist Column] ,1 ) >> for the first image 

<<INDEX([Image Enumlist Column] ,2 ) >> for the second image 

and 

<<INDEX([Image Enumlist Column] ,10 ) >> for the tenth image.

@mark8adams wrote:

I've tried all of my available AI tools and they give up and tell me to talk to you. Any suggestions?

---

Just as a side note, this is interesting. It shows A) the widespread use of AI tools in getting solutions B) There seem to be still some areas where human assistance may be required in addition to AI.

We old timers in the community are observing gradually reducing quantity of questions being asked in the community. Of course this is just an observation and not any complaint. We must all keep up with the latest in technology trends. Interesting times ahead with AI tools.

[mark8adams]

I could be wrong, but I don't think the "Action Required" notice applies in my situation: my images are not downloading via a drive.google.com/uc URL, but a drive.google.com/open.  My problem seems to come from the syntax not recognizing the stuff inside the embedded expression due to the quotes.  I also tried a hyperlink function and got the same problem.

<<Hyperlink("INDEX([Images] ,1 )","Photo 1")>>

Adding or removing the first set of quotes either prints the stuff inside at a text string or tells me my function inputs are invalid.  Seems like omitting the first set of quotes would be right, but no.

[mark8adams]

Thanks so much.  This worked to give me lines of links to images in my email, so I thought I'd try to embed those links as images.  I couldn't make that work.  Here's my email with your solution:

When I tried 

<img src="<<INDEX([Images] ,1 ) >>" width="300" height="auto">

I just got a broken image indication in the email.  Am I on the wrong track? Any more suggestions?

As an aside, I've had pretty good luck solving my issues with the 5 AI tools I use, but often (OFTEN) have to give up on a tool and try a different tool when they get in endless loops of invalid syntax.  None of the AI tools recommended index() as a solution.  Sometimes all 5 tools just waste my time.

[Suvrutt_Gurjar]

Thank you. I think you are probably encountering issues in displaying images because of the following announcement post on displaying images from Google drive?

[Action required] Drive download URLs for embedda... - Google Cloud Community

The post is detailed enough to mention the issue of displaying files from Google drive using download URLs and also how AppSheet addresses it.

Thank you for sharing your experience with using AI tools. It is insightful.