Hey,
I need to write an IF statement for is the record is the last one in the (multi record) table.
However, something based on the record num (i.e. IF num = totalRecords) doesn't work as I need it based on the table order rather than num.
For example
2: Hi
3: Hello
4: Bye
1: Goodbye
I need Goodbye to be recognised as the last, even though it's num = 1, it is last as per order.
Note, the table is ordered by another field, DATE (which is date format), not DragSortOrder if that matters.
Cheers in advance
Rob