here’s a tip to calculate visual position of the row in table -(if rowid, rank does not work for your case AND if you dont have ‘SORT’ applied)
as you can see in image, visual position always updates based on position of the record.
Formula here is
Schedule.FormulaMap(if(CurrentValue = thisRow, 1, 0)).Find(1, 0) - it enumerates through each record in table, assigns
1 for the thisRow and then tries to find position of 1 in list.
EDIT: - some of my colleagues pointed out that the above formula relies on the FormulaMap’s order of execution - and that could change in future. suggestion was to use
Schedule.Find(thisRow) - we know that it shows error in formula builder - but you can ignore the formula builder error for now - it does not affect the result. We intend to support this scenario more directly in future and when we do, this approach might break.
Hope this helps.
Engineer - Coda