Create a Random sort based on the Record ID#
I have a table which will have 40,000 records loaded and flushed out each day. So it will have a high number with 6 or 7 digits for the [Record ID#] in a few days once we go live. Is there an easy...
Forum Discussion
If you records are getting populated steadily throughout the day and not all at once, you could sort on a text field with a formula something like this:
var TimeofDay DT = ToTimeOfDay([Date Created]);
Second($DT)
&"."&
Minute($DT)
&"."&
Hour($DT)
var TimeofDay DT = ToTimeOfDay([Date Created]);
Second($DT)
&"."&
Minute($DT)
&"."&
Hour($DT)