I have solved the slowness of my app. I had a problem with the fact that there were so many detail views that all had to be edited with “columns to include” everytime on of them was changed to make them all look the same.
I posted about this and someone suggested making an a action that takes the user to one detail view. Then make that action the event on row selection for all of the views. Problem solved - the user is always takent to the same detail view no matter what view they are accessing the dat from.
This is where the slowness problem came in. The single detail view that I randomly chose to be the one used for everything was “For This Data” set to a slice of the main table not just the main table itself.
The Slice happened to have this expression used for a running sheet where the length of it and delay isn’t a big issue as it’s used infrequently. This was slowing down the app as it was calculating this slice each time.
ISNOTBLANK( FILTER( “Orders”, AND( ([Outlet No] = [_THISROW].[Outlet No]), ( [Delivery Date] = LOOKUP(
[Unique ID], “Running Sheet 2”, “Unique ID”, “Delivery Date” ) ), [Order Status Calc]=“Open”,
IN([Route] ,(LOOKUP( [Unique ID], “Running Sheet 2”, “Unique ID”, “Route” )))
) ) )
This is also relevant to some other posts I made regarding speed, mutiple detail views and how to slim down to one.