Ordering data on a table

Hello guys,

I´ve a situation that was not expected. The thing is that I´ve a Repeating Group where I show the user´s invoices. In that RG invoices are shown by date of the invoice and date of creation.

The problem happens when I´ve invoices created in the same day since they´re not ordered well. Invoice 1, 2 and 3 could be ordered like 2, 3 and 1.

I think this happens because I´ve a workflow to save the date = date input + 60 seconds so every invoice time is 12:01.

Is there anyway someone knows how to fix it? My first thought is to create an incremental ID whenever a user creates an invoice so then it can be ordered by that ID number.

I’ve done the incremental ID in the past. I think we used something like “count +1” for the items to keep them nice and sorted

Thanks a lot Andrew. That should work :wink:

1 Like