Gallery
Rows Context (Previous row and next row)
Share
Explore
Pages

icon picker
Row Context Managment

Tips:

Easily manage and make calculations with previous and next rows, on any desired order and partition level.
NextRowCategory: This is about next row by first next date, ascending item name, partitioned by category. You need a good unique value column to order. In this case is the combination of date and item because date is too repetitive and item breaks the order (you end with two dead ends, instead of just one).
Visible Row: You can use a simple lookup like NextRowVisible to get previous visible row if you know the order of the table is set to a column and will never change. (Beware of grouping). I think you could use a column “order”, and use buttons to allow sorting by other columns just changing that column “order” value.
RowId is just used to avoid current row. (The
current row id != this row id
⁠
conditions helps with at much two duplicated item names.)
Random Order just used to demonstrate formula works independent of view.
You should see a pretty straightforward relation in the next row, calling back the present row as previous row.
⁠
image.png
⁠
⁠

Play now:

ThisTable
Category
Subcategory
Item
Date
NextRowCategory
NextRowSubCategory
PreviousRow
Random
Visible Row
NextRowVisible
B
BB
Item 7
2020-02-10
Item 8
Item 17
Item 6
0.013
1
A
AC
Item 13
2020-05-10
Item 14
​
Item 12
0.021
2
A
AA
Item 1
2020-02-10
Item 11
Item 11
Item 5
0.045
3
B
BD
Item 10
2020-03-10
Item 16
​
Item 9
0.059
4
C
CA
Item 25
2020-07-10
​
​
Item 24
0.093
5
B
BB
Item 17
2020-05-10
​
​
Item 16
0.211
6
C
CC
Item 21
2010-03-06
Item 22
Item 22
​
0.251
7
A
AB
Item 12
2020-05-10
Item 13
​
Item 11
0.361
8
C
CA
Item 24
2020-07-10
Item 25
Item 25
Item 23
0.384
9
C
CC
Item 22
2020-07-10
Item 23
Item 23
Item 21
0.400
10
A
AA
Item 11
2020-03-10
Item 12
​
Item 1
0.469
11
B
BD
Item 9
2020-02-10
Item 10
Item 10
Item 8
0.519
12
B
BC
Item 8
2020-02-10
Item 9
​
Item 7
0.550
13
A
AD
Item 4
2020-01-10
Item 5
Item 5
Item 3
0.635
14
B
BA
Item 6
2020-02-10
Item 7
Item 16
Item 20
0.646
15
A
AD
Item 5
2020-01-10
Item 1
Item 14
Item 4
0.653
16
B
BA
Item 16
2020-05-10
Item 17
​
Item 10
0.656
17
B
BD
Item 19
2019-03-06
Item 20
Item 20
Item 18
0.722
18
B
BC
Item 18
2010-03-06
Item 19
Item 8
​
0.724
19
A
AD
Item 14
2020-05-10
Item 15
Item 15
Item 13
0.773
20
A
AB
Item 2
2020-01-10
Item 3
Item 12
​
0.876
21
B
BD
Item 20
2019-03-06
Item 6
Item 9
Item 19
0.954
22
A
AC
Item 3
2020-01-10
Item 4
Item 13
Item 2
0.959
23
A
AD
Item 15
2020-05-10
​
​
Item 14
0.994
24
C
CC
Item 23
2020-07-10
Item 24
​
Item 22
0.994
25
There are no rows in this table
⁠

Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.