I have used =rowID(thisRow) on Table 1 to calculate the S.N. automatically. But how can I reset the numbering for the view of Table 1? I want the numbers to be 1, 2, 3.
How can i do this? The 2nd table is linked to the main table “Table 1”.
The yellow highlighted numbers appear only when i hover my mouse above it. Is there a way to keep it always visible?
Hi @fei there are quite a few posts in the community about how row IDs work. The yellow highlights you see is showing you the ‘rank’ for that view. That is dynamic, since you can sort tables, so it will change depending on the view.
You can also drag and drop the rows to re-order them. The rowID() is a unique identifier for each row. If you are ‘perfect’ when you create a table and never delete or re order them, they will stay sequential, but otherwise they will probably ‘get out of order’.
I don’t think there is a way to ‘reset’ the numbering.
So as on this screenshot above, If i add new row in between 5 and 6, I want ‘6’ to appear on rank instead of 12. (or reset the Rank??).
If there is a way to set “always visible/ON” to the numbers (on the side) that appear only when i hover my mouse, it would solve my problem…
And for the filtered view,
the formula you provided me gave me the same result as of the main Table.
rank_John = rank(thisRow.[rowID_All orders],thisTable.Filter([Only for John]).[rowID_All orders],true)
I believe I have to use filter for thisRow too, but I was not able to figure out the correct formula.
And same applies to this view too, if there is a possibility to make those highlighted number “always appear”, it’ll work for me.
I want each table / view to have a continuous number (1,2, 3, etc for all rows). So that when I share my table or view to someone (my sellers for example) via screenshot or email button, it makes more sense if i say “please check the 3rd row” instead of saying “check the row labeled 12”.
Sorry if I am being silly here. In excel, i would have done something like below (use auto-fill to reset numbering):