
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2020 01:31 PM
I’ve seen this question asked a few times but still no solution. I would like to use airtable as the database for my trivia app. I need a way to randomly select row/record which will have the question, and then display the contents. The part I havent seen a solution to yet is how to select a random row/record from only the populated rows. Any ideas?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2020 02:42 PM
Here is one possible method:
- Create a new field for a random value.
- Set the random value either using the Batch update block or Scripting block.
- Sort according to the random value field and take the first record in the view.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2020 06:58 PM
You might love using Airtable’s Flashcard Block. It randomly goes through your records and does exactly what you have requested — it randomly pulls the questions & answers from your base.
