Read the values ​​of the previous or next record

AppSheet AppSheet Q&A
1

Hi,
I am in a View Detail… I am trying to set some actions that will affect the values ​​of the previous or next record of the current one…
I need to retrieve the value [_RowNumber] of adjacent records, is it possible?

Thanks for your attention…

2

Immediate preceding _RowNumber:

MAX(
  SELECT(
    Table[_RowNumber],
    ([_THISROW].[_RowNumber] > [_RowNumber])
  )
)

Immediate following _RowNumber:

MIN(
  SELECT(
    Table[_RowNumber],
    ([_THISROW].[_RowNumber] < [_RowNumber])
  )
)
3 Likes
3

I hadn’t even thought of that… it’s easier than I thought… perfect…
Thanks…

1 Like