Differences between rows

Table Order vs Entry Order vs Sorted Order

Sorted Order is the easiest concept, it simply means that the table has been sorted according to sort instructions.
Entry Order is also relatively simple. It is the sequence, based on time, in which the rows were added to the table. There is a column type and property called RowId(). You can choose it as a column type, or simply add the formula
image.png
to a column. In the table below, you can see that the row “One” was created last.
Table order is slightly more nebulous. It is basically the unsorted table. The sequence of rows in “table Order” can be manipulated by inserting rows in specific positions. Although “One” was created last, it was created by inserting a row above row “Two” which was the first row created.
In the Lookup table, the number column is a lookup, and its Sort setting has been set to Table Order.
See screenshot
image.png
Note:
Formulas working with the position of items in a list of rows in a table, works using the Table Order by default.
Looking for the first item will return
@Two
image.png
You can modify the sequence by making use of the sort function.
Looking for the first item in alphabetical sequence:
@Four
image.png
Table Order vs Entry Order
0
Search
1
2
3
4
Name
Sequence of entry
Name
Sequence of entry
Two
1
Three
2
Four
3
One
4
There are no rows in this table
Lookup table
0
Search
1
2
3
Number
Number
Three
There are no rows in this table
A practical example is a priority list. You start out with 3 options Low, Medium, High. You soon realise that an uneven number of options, leads to people choosing the middle one too often. So you change Medium to Medium Low, add Medium High by inserting a row below, and your lookup dropdown automatically will adjust and show them in the correct sequence.
Priority List
0
Search
1
2
3
4
Name
Name
Low
Medium Low
Medium High
High
There are no rows in this table
Priority lookup
0
Search
1
2
3
4
Priority
Action
Formula
Priority
Action
Formula
Medium High
Exercise
Medium Low
Eat
Low
Swim
High
Sleep
There are no rows in this table

In the example below, the lookup column in the custom lookup table has been given a custom sort sequence based on the sequence in the column “lookup sequence”.
Custom Sequence
0
Search
1
2
3
4
Name
Number
Lookup sequence
Name
Number
Lookup sequence
One
1
4
Six
6
2
Eight
8
3
Four
4
1
There are no rows in this table
Custom lookup
0
Search
1
2
3
4
Name
Lookup sequence
Name
Lookup sequence
Four
1
Six
2
Eight
3
One
4
There are no rows in this table


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.