Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

How to create a table with 2 or more columns of related photos in a PDF template

I have a child table with photos, and a bot to create a PDF template.

This is the expression of the template.

maretec_2-1729024220601.png

 

This is the PDF

maretec_1-1729024132726.png

 

I want to display photos in 2 columns like this.

maretec_3-1729024329871.png

How can I do it?

 

Solved Solved
0 6 343
1 ACCEPTED SOLUTION

There is not a feature provided to do this.  It can be, and has been, done but will require creating your own template format to make it happen.  Basically, it requires setting up in the template, side by side template tables.  The first template table processes half of the list.  The second template table processes the second half of the list.  

I believe there is a post in the Community (created by @AleksiAlkio  I think)  with more details on how to set this up.  Search there and I will also try to see if I can find it.

EDITED:

I found this post.  It describes 4 columns but the same principle can be used for 2.  The key is that it uses the MOD() function to split the list.

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

 



 

View solution in original post

6 REPLIES 6

There is not a feature provided to do this.  It can be, and has been, done but will require creating your own template format to make it happen.  Basically, it requires setting up in the template, side by side template tables.  The first template table processes half of the list.  The second template table processes the second half of the list.  

I believe there is a post in the Community (created by @AleksiAlkio  I think)  with more details on how to set this up.  Search there and I will also try to see if I can find it.

EDITED:

I found this post.  It describes 4 columns but the same principle can be used for 2.  The key is that it uses the MOD() function to split the list.

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

 



 

I found another post that mentions the use of MOD.()

Let me check the post you sent me.

 

This seems to be what I need. I'll look into it in more detail.

I was trying to use MOD() on a virtual column and <<If>> <<EndIf>> as explained here:
https://support.google.com/appsheet/answer/11568425?hl=en

Yep, that was the post 🙂

At first, the height of the cells was different, depending on the size of the image..maretec_0-1729095442953.png

I fixed this by adjusting the "Minimum row height" of the table and . . .

maretec_1-1729095864843.png

applying a formatting rule to the image using the "Workflow template format"

maretec_2-1729095917133.png

It looks better now 🙂

maretec_3-1729096307107.png

 

 

 

Is there a way to move the last image to the left?

maretec_5-1729096721391.png

Top Labels in this Space