Purposely pull up random records in a report?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

First of all, I have QB Essentials.

I don't think this is possible...

I'm creating an app, that has a bank of a 100 test questions. I want to be able to generate a report that randomly pulls up a given number of those questions. Like say, I tell it to take a random 20 of 100 (no repeats) and spit them out on a report.

The workaround I have is just pull them all out and filter by randomly clicking 20 numbers in the filter. Which works just fine, but I was wondering if it could be more automated.

Photo of Tony

Tony

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Click the Button to return 20 random questions without duplicates from the Questions table:

Random Questions - Report Containing 20 Random Questions
https://haversineconsulting.quickbase.com/db/bj9vgmbss?a=td

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=454
Photo of Tony

Tony

  • 0 Points
Thank you very much!

2 questions though......

1. Not sure if I set this up properly. I have a table with the questions so I do I create another table with 2 fields with one field being the JS file and second field is the text-formula with the button formula you provided? And then I create a relationship between the two?

2. I actually have more than one question table. I have one table per course. How does that change things?