How to display a list of images into 2 columns or 3 columns when creating pdf by automation

[kvngo94]

Hi everyone, 

I have a list of images, and want to show it in columns (2, 3 or more.. which is displayed as same as gallery view ), been trying out but can not achieve it, only can show it row by row by <<start:>> and <<end>> expressions.

For example, I have list of {image 1, image 2, image 3, image 4}, I want to show as below when creating pdf by automation. If anyone has experience with this kind of display, please kindly advise. Thank you.

[Suvrutt_Gurjar]

Please post such queries in "Q&A" section.

Could you update if those images are from the same record or multiple records of a table?

or are those images (one per record ) from a child table?

Also if possible, could you share your existing template expression?

[kvngo94]

Hi Suvrutt, 

Sorry I didn't notice the Q&A box...

Those images are multiple records of a table ( each row has 1 image ).

The example data would be as below for Table named "Bag" :

ID	Image	Bag Name
1	Image 1	Name 1
2	Image 2	Name 2
3	Image 3	Name 3

My template expression : 

Image

<<START: Bag[ID]>> <<[Image]>> <<[Bag Name]>><<END>>

Result (not as expected)

Image

Image 1 Name 1

Image 2 Name 2

Image 3 Name 3

What I'm trying to achieve is : 

Image 1 Name 1

Image 2 Name 2

Image 3 Name 3

[Suvrutt_Gurjar]

Thank you. Please try something like below. Not very elegant but will work.

The below will work for up to six images. You may want to suitably adjust /add columns /rows, expressions.

<<START: LIST(INDEX(Bag[ID],1))>> <<[Image]>> <<[Bag Name]>><<END>>	<<START: LIST(INDEX(Bag[ID],2))>> <<[Image]>> <<[Bag Name]>><<END>>	<<START: LIST(INDEX(Bag[ID],3))>> <<[Image]>> <<[Bag Name]>><<END>>
<<START: LIST(INDEX(Bag[ID],4))>> <<[Image]>> <<[Bag Name]>><<END>>	<<START: LIST(INDEX(Bag[ID],5))>> <<[Image]>> <<[Bag Name]>><<END>>	<<START: LIST(INDEX(Bag[ID],6))>> <<[Image]>> <<[Bag Name]>><<END>>

[kvngo94]

Hi Suvrutt, 

What if I have like n images, not just 6 ? 

[Suvrutt_Gurjar]

Then I believe you should use Aleksi's nice solution as it already caters to n number of images.

[kvngo94]

Hi Suvrutt, noted and thank you for your help

[AleksiAlkio · Accepted solution]

One workaround is to use this method we discussed few years ago 🙂

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Create-a-Workflow-Template-using-a-quot-start-q...

[kvngo94]

Thanks Aleksi, I'm also asking another Aleksi for more details hhh, guess it's you ^^

[AleksiAlkio]

Probably 🙂