Solved: Save a logsheet file with multiple rows - Page 2

Fred_Worrell · 06-02-2020 06:33 AM

I’m trying to save a file from appsheet that includes multiple rows of a table. The rows are all from that day. How would I accomplish this?

Steve

Nope. MINROW() produces a row key, not a number, so you cant just add one to it (unless the key is a number).

If your log sheet has a fixed number of rows, and all rows are replaced every day (or however often the log sheet is regenerated), such that you will always know how many rows the spreadsheet will have and what the spreadsheet row numbers will be, you can use the spreadsheet row numbers:

<<LOOKUP(2, "My Table", "_ROWNUMBER", "Data Column")>>
<<LOOKUP(3, "My Table", "_ROWNUMBER", "Data Column")>>
<<LOOKUP(4, "My Table", "_ROWNUMBER", "Data Column")>>
...

where 2, 3, and 4 are the actual spreadsheet row numbers, and _ROWNUMBER is that literal text (_ROWNUMBER is the name of a column in the AppSheet table that contains the spreadsheet row number).

View solution in original post