Jan 19, 2017 07:09 AM
Is there a way to sort the records randomly (not alphabetically)? Say I have a table of students and I want them to be randomly ordered for a presentation or something?
Jan 20, 2017 01:16 PM
I have the same question, thanks!
Mar 17, 2017 10:44 AM
I also want to be able to do a Random SORT.
Oct 03, 2020 07:35 AM
Same here! Random sort please?!
Oct 03, 2020 08:34 AM
Back when this question was first asked, this was not possible. It is now possible with scripting. Setup a new number field. Then use scripting to insert a random number in the number field of every record. Finally, sort on the number field.
Feb 11, 2021 05:43 AM
Scripting? What would that look like? Random sort is incredibly valuable for memorizing/studying things, but many of us are not computer science people
Feb 11, 2021 09:41 AM
Welcome to the Airtable community!
Scripting app is an app for Pro plans that lets you run custom JavaScript.
To have a random sort, use a script to fill in a number field with a random number. Then sort on that number field. When you want a new random sort, run the script again.
Feb 11, 2021 09:58 AM
Thank you for that explanation. It does sound too complicated for the average user when Airtable could easily add this feature to the “sort” menu or something. I’m imagining the student who wants to review their vocabulary each day. It seems cumbersome to ask them to create a new field and fill it with random numbers and then sort–all before they can start a review of their material. I’ve shared this with the Airtable team, so hopefully they will consider it soon.
Dec 27, 2021 10:35 PM
I have been a pro user for quite a long time and it saddends me to realize that a tool I paid for havent the minimum ability to listen to users when regarding to their requests. The solution using “scripting” is not adequate as it requires knowledge from the user and to run the aforementined scripting everytime one needs to list data. So if I have 1000 record that would be 1000 writes and 1000 reads just to get that listing. This could easily be achieved by adding this functionality in the core of the API in the SORT parameter, setting it to “rand” (instead of “asc” or “desc”). Why not prioritize someting that it is in the backlog for FOUR YEARS?
Dec 28, 2021 01:10 PM
Welcome to the Airtable community.
You can also use the Batch Update app to set a number field to a random number. Then sort according to that random number. No scripting required.
Airtable tends to not publish why it chooses to not implement the requested feature, but I’m sure they have their reasons. Often something that seems simple from a user point of view is actually fairly complex to implement in the backend at scale.