MOVING THROUGH RECORDS

AppSheet AppSheet Q&A
1

Hi,
is it possible to set actions that move to the first and last record of a selection of records?
Thanks for your attention…

2

Your question is ambiguous. Move what? Which selection?

3

Yes. You would want to use the INDEX() and COUNT() functions. The first record is index of 1. The last record is the COUNT() of the list of records.

ADDITIONALLY, since it cannot be guaranteed what order you might actually receive the records, you would need a way to order the records in the way you expect. Use the ORDERBY() function.

Presume that you want the records in the order they were saved into the system. For that, you should tag each record with a DateTime field and then order the records by that DateTime. The resulting expressions would be :

For the first record...

INDEX(
      ORDERBY(
              SELECT(Table[Row Key], <<some filter criteria>>), 
              [DateTime]),

      1)
)

For the LAST record...

INDEX(
      ORDERBY(
              SELECT(Table[Row Key], <<some filter criteria>>), 
              [DateTime]),

      COUNT(SELECT(Table[Row Key], <<some filter criteria>>)))
)

NOTE: Syntax may not be exactly correct!

If you don’t need filtering, then you can simplify the SELECTs to: Table[Row Key]

I hope this helps!!!

1 Like
4

Thanks to whoever told me how to locate the record row, but I didn’t find in the list of actions a system to maintain the selection and be positioned at the first or last record of it. I see the selection in a View Detail and I would like to have these actions as buttons…

Let me explain better… I would like to have some actions, that allow me in a View Detail that has already set a specific query, to go to the first record or the last record…
Is the question, formulated in this way, more understandable?
(Sorry for my English, but I’m using Google Translate for the translation)