I have a child table with photos, and a bot to create a PDF template.
This is the expression of the template.
This is the PDF
I want to display photos in 2 columns like this.
How can I do it?
Solved! Go to 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...
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..
I fixed this by adjusting the "Minimum row height" of the table and . . .
applying a formatting rule to the image using the "Workflow template format"
It looks better now 🙂
Is there a way to move the last image to the left?
User | Count |
---|---|
34 | |
8 | |
2 | |
2 | |
2 |