Next and previous item function

[davidstone]

I've seen various workarounds to approximate this behaviour, but it would be much better to have a proper function for it.

What we want is an ability to know the position of a row of data within the sequence of data in our data source, and be able to have a function that allows us to move to the next record, or the previous record.

I've seen some solutions that use ID, and increment the ID to move to the next record, but that's no good if someone deletes a record and your IDs aren't sequential. There's another method that uses the first or last record with a higher or lower ID than the current one - that 'works', but it feels a bit iffy, and restricts me to only being able to browse in the sort-order of my ID column.

[davidstone]

Another reason we need a specific function for this is that the workaround doesn't work for delegation.

[Johann_CHARB]

It's a very good idea. 

For me, i see something like ThisItem.title to know for example value inside Title field, but for the next or previous item :

NextItem.xxxx and PreviousItem.xxx

We could make visual effect with this tool. Like a background color to group differents items together or more.. Thx for watching.