My “little” appsheet project is starting to become bigger than Ben-Hur.
I have an appsheet table with many rows, but only a few columns which I need to print.
To avoid spanning too many pages, I was hoping to take advantage of the Column feature in Google Docs. To avoid confusion with this feature name, I have included a screenshot below.
Frustratingly, this feature doesn’t seem to work with apphsheet.
My workaround is to create a 2 cell x 1 row table in Google Docs and then put my appsheet table within each cell of the Google Docs table.
I’ve worked out that I have room for 29 rows. This means I can use TOP(MyListExpression, 29) for the left cell.
The right cell has me stumped. -I wish there was a Middle function, like MIDDLE(MyListExpression, 30, 58).
Can anyone think of a way to display the next 29 rows (30 to 58) from a list?
I’m open to other solutions/workarounds. -Ideally, if someone knows of a way to make the Google Docs Column feature work with appsheet, that would be awesome. Or perhaps some other workaround that I haven’t thought of.
Thanks in advance