Sorry for the delay. Finally got some free time to work on this.
First of all, Robert had reported to Glide that there is in fact an issue with the Shuffle action, so I’m thinking that will be fixed sometime this week. However, I don’t think that would be a great way to ensure that each of the questions are unique to each other. Because of that, I threw together a quick sample app with javascript to randomize the questions while keeping them unique, so there shouldn’t ever be duplicates when they are reshuffled. Also, instead of a shuffle action, instead I’m still setting a unique ID. That unique ID is passed into the javascript column, but the ID is not used for anything. It’s just there to retrigger the javascript, which will return new random questions.
Copy the app, have a look at it, and see if you have any questions.
If anybody has better code, feel free to share. This was just something I threw together quickly. Essentially it gets a random question from an IN array, adds it to an OUT array, and removes that question from the IN array, so the next random won’t grab a question that’s already been selected.
Side note, if Glide fixes the shuffle issue, then there may be a possible chance that we could eliminate the unique ID and go back to using the shuffle action. Something to keep it mind as it may save on update counts.