Google Docs Column Feature

AppSheet AppSheet Q&A
1

Hi all

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.

3X_e_8_e89ff4c9c3b580a01906dee911a4843b8a91e4c2.png
3X_e_8_e89ff4c9c3b580a01906dee911a4843b8a91e4c2.png423×357 19.5 KB

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
Stel

2 Likes
2

I’m curious to see what responses you get. I have been less than impressed with AppSheets “reporting” capabilities.

1 Like
3

Hi all, I ended up with my home-brew 2 cell x 1 row table option.

@Suvrutt_Gurjar, provided the (real) expression to replace my (fake) MIDDLE function here:

[Range of values from a list](https://community.appsheet.com/t/range-of-values-from-a-list/51856) Questions

Hi all, Does anyone know a technique for extracting a range of values from a sorted list of variable length? I can already get the TOP() 10 values, but I need to get the next range. Eg I need to get values 11 to 20. My apologies for asking this twice. -I suspect I tagged and worded my first question poorly. Thanks in advance Stel

In summary, the expression is:

TOP ( [SortedList]- (TOP ( [SortedList] , [From]-1) ), [To] - [From]+1)

Hope this helps anyone else.

Stel

1 Like