Deck View record count

[Norman1]

Is it possible to display the number of records displayed in deck view and which one is selected to view ie ‘65 records’ or ‘record 23 or 65’ of something similar?

[WillowMobileSys]

There are a few ways:

1. You can modify the view name at the top to include a count of the rows using the COUNT() function

2. You could Group the Deck view and use COUNT as the group aggregate. This will give you a Grouping header within the view with the Count displayed.

3. Use the Summary field in the Deck view to show an “n of X” value. This will take some customization to create the proper expression that creates the display value. You may be able to get away with using INDEX() to get the “n” value and then, of course, COUNT() for the “X” value. CAUTION: the Summary field has a limit on its width. If the numbers are large, the display value could become truncated.

Which option appeals to you most? Then we can help you build it!

[Norman1]

Option 3 sounds good, can’t see total records going over 9999 or is that too high?

[WillowMobileSys]

You can test it by creating a Virtual Column, assigning it a value of “9999 of 9999” and see how it displays. Not sure if that’s too wide or not. You could shorten it a bit like “9999/9999”.

If you like how this looks in the Deck View, then you can modify the Virtual column expression to build the actual display values. To help, we would need to more details about how you are deriving the rows to be displayed in order to help Index and Count them.

[Norman1]

“To help, we would need to more details about how you are deriving the rows to be displayed in order to help Index and Count them.” Not sure what you are asking there but does this help.

From an eight column GoogleSheet where each row is a seperate record.

Displayed in ‘Deck’ view

similar to that or even just the total (169) and if record 27 was selected to show the detail then the 27 or 168 displayed.

[Norman1]

I suppose I could add the record number in to a column on the sheet and add it to the deck display then only total needed.

[WillowMobileSys]

Norman:

Not sure what you are asking there but does this help.

I was referring to how you select the rows to show in the Deck view. There are several ways you could go about obtaining the rows to display - table, slice, filtered view, etc.

For precise help it would be good to know. Sometimes trying to be generic ends up causing confusion.

Norman:

I suppose I could add the record number in to a column on the sheet and add it to the deck display then only total needed.

Yes you could. However, If you allow Deletes or have several people adding rows at the same time from different devices, you may find it difficult to maintain the number sequence correctly.

[Norman1]

Having played about with it and had more thought on the matter I have decided only the total count would be of any use if at all.

Been trying to add a filter but even inserting the column to search it reports column not found. doing something wrong there as well.