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.