Obtaining an image from a specific row in a column

Is there a way to put an image from a specific row into a template? I have a situation where I want to load one of 8 different images in a automation email template. The images are chosen from numbered columns but I notice that if I just reference <<image1>> for example, it tries to find that in the current row. As they are the same image every time (1-8) I don't want to have to load them afresh in each row. I just want Appsheet to go and fetch them from the single row where they are stored.

thanks for any help

James

Solved Solved
0 21 828
1 ACCEPTED SOLUTION

There is no need to use slice, just the table name is enough. I made a quick test with your setup, and the image works. I used..
<<Start: SELECT(Data[ID],[ID]=โ€xxxโ€)>>
<<SWITCH([ImageSelection],1,[Image1],2,[Image2],โ€โ€)>>
<<End>>

The structure is like this..

AleksiAlkio_0-1695102421574.png

View solution in original post

21 REPLIES 21
Top Labels in this Space