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?
+17Here 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.
+20You 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.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.