Slideshow not traversing displayed rows in order with Grouping and Sort applied

[WillowMobileSys]

I have a view of records that are Grouped by Date. When accessing a row and using the Slideshow Mode, the app will traverse the rows in the order they appear in the view.

However, I want the rows sorted by a DateTime column (a completely different column) in descending order so the most recent row is at the top of the group. Applying the sort works just fine as expected.

HOWEVER, the Slideshow feature no longer traverses the rows in the presented order. In fact, it will skip around to rows in completely different Groups.

I don’t recall this being a problem in the past and it has been a long while since I’ve played with Slideshow Mode.

Am I missing something? Surely I don’t need to extract the Time separately…do I?

EDITED: I tried using just the Time as the sort…no difference. If I remove the sorting altogether, the Slideshow traverses the rows in their displayed order.

[Steve]

Turn off all preview features. Is it working as expected now? If yes, report the bug to Support, otherwise continue…

The order of the rows in slideshow mode should be determined by the order of the data set used by the view. If you navigate into a slideshow view from an existing view using the built-in “view details” action, AppSheet should apply the slideshow view to the data set of the existing view in its same order. If, however, you use a custom action using a LINKTO() function, the data set and its order is determined strictly by the view referenced in the function itself.

[WillowMobileSys]

Thanks Steve!

@Steve

Turn off all preview features.

Its off. I never have Preview options on in production apps.

@Steve

should be determined by the order of the data set used by the view.

NOTE: That if the table view if filtered, the Slideshow will only show those filtered rows - under normal circumstances. So it would seem the intent is to use the order of the presented rows.

And indeed if I use a Grouping, which alters the order of the data set from its original state, the Slideshow feature works as expected. Grouping obviously implies a sort has been applied.

But if I apply an additional Sort, the order is completely different.

For example, I am Grouping by Date in Descending order. With just the Grouping, the Slideshow follows the order of the rows down the list perfectly from Date to Descending Date.

As soon as I apply a additional Sort, the Slideshow jumps around, seemingly at random, from one Date to another DAte and then back again.

At the very least I would think it would keep the order of the Grouping. The fact that it doesn’t suggests that maybe AppSheet is trying to re-order the rows for the Slideshow and failing.

@Steve

If, however, you use a custom action using a LINKTO() function, the data set and its order is determined strictly by the view referenced in the function itself.

I have failed to mention that the table view is based on a Slice. I am using a LINKTO…() to a common Detail View. But recognizing your point here, I had previously attempted to create a dedicated Detail View based on the Slice. It made no difference.

I have NOT tried allowing the Table View to use its default process to the default Detail View. I’ll try that next.

BOTTOM LINE: It seems the intent is for the Slideshow feature to follow the presented order of rows in the Table View. But applying a Sort interrupts that.

I think its a bug but…I am getting older (by the minute it seems - LOL)!!

[Steve]

I recommend using LINKTOFILTEREDVIEW() to choose the data set and the detail view, and &ROW= to target a specific row.

META POST: Deep Links & URL Parameters

META POST: Deep Links & URL Parameters This post is a collection of other posts and AppSheet support docs relating to Deep Links and URL Parameters. Please feel free to post links to additional tips below and I will add them to the main post.## Deep Link vs Deep Link Expression Deep Link: Link to a specific app view. Can be to a single row, full table, filtered-set of rows, pre-filled form, etc. Deep Link Expression: Formula that takes one or more inputs, and outputs a Deep Link. [3X_5_b_5…

[WillowMobileSys]

@Steve

I recommend using LINKTOFILTEREDVIEW() to choose the data set and the detail view, and &ROW= to target a specific row.

Understood. It’s not conducive the current app design.

I did, however, confirm that allowing the Table View to flow naturally to its default detail view does indeed allow the Slideshow to travers the rows in the presented Sorted order.

I was trying to avoid re-implementing the same exact Detail View format. I guess I can’t.

So it must be that when using a LINKTO…() function to a specified view, the sort order is not carried over for the Slideshow feature…but the Grouping is? I don’t know, it still feels something is wrong.

But at least I have an option to implement what’s needed!!!