You could maybe structure your sheet with 2 extra columns. One for previous date and one for next date. As long as your sheet is sorted by date, then you could use some sort of formula to fill the Previous and Next columns by offsetting the result you put in the column. For example if the date column is D, the Previous column is E and the Next column is F, on row 3 you would fill the Previous cell with D2 and the Next cell with D4. This would allow you too create relation columns that link the Previous and Next columns to the Date column in the same sheet. Then you can create a Previous inline list and a Next inline list. Buttons would be ideal, but I don’t think they allow you to use a relation on them.
Maybe you could get creative by filling the detail and caption part of the list with empty rows to get the list image on the right side, the use some sort of left and right arrow image to make it appear like a button, or use the tiles style for the lists to get a button look.
Sorry, my mistake. I should have said empty columns instead of rows. Since you have Title and Details filled on the list, what I meant was to create an empty column to use for the Caption of the list. Or you could fill the Title, Detail and Caption with empty columns, so you would only see the image. Filling the Caption with something will move the images to the right side of the screen and the little right arrows goes away for a little cleaner look. What you have looks great! It’s awesome to see it working. I suppose if you had other tabs, then you could double tap the tab to reset the view back to the list, but it’s obviously a concept app! Nice work!
Ok, I made a copy and I’m playing with it. I guess tiles won’t work side by side since they are separate lists. If you change the relations to multiple, that allows you to use an inline list, which gives you the caption option. Unfortunately inline lists have a horizontal line between list items, so it kind of looks bad. I wish we could turn that line on or off. Here’s a couple examples of what I’m thinking. This is after selecting Multiple in the relation. The Previous button is an Inline List with Title, Detail, and Caption filled. The Next button is an inline list in compact view.
@Jeff_Hager - I know this is an older post - but did something today that made me think of this … thought you may want to see something similar I did (on a much SMALLER scale)
In this app, on the front page … scroll all the way down to the bottom
You may remember (see below) that The front page is always ZERO day, so yesterday is -1 and tomorrow is +1
So I did a tiles and filtered all days OUT but -1 and +1
So it gives me two little navigation buttons to go backward and forward ONE day.
(In this particular app, I do not want the user to go more than one day back and forward, so that is where I stopped the buttons.)
and it sorta goes along with our discussion on this post
Hmm, that gets my wheels turning. I’m trying to think of a way to apply this method to any list. Maybe two columns set up as an array column with one column showing the prior record id, the second column showing the next record id. Then creating a relation off of that array column. Not very far off from what we set up with before. Just a single relation instead of two. I may have to try to come up with a demo in the concepts app.