Hi Gliders, need some help, I have 2 tables, one is used for storing text and images, the other is blank. I need a way to randomly select a row table one and then I’ll use “to new content” add row to add the random selected data to the blank table. What I cant figure out, is how I select a random row, at the moment I can only pick from the top row each time, any ideas? Thank you so much, everyone, 
You can use a collection and the shuffle action!
1 Like
Hi @MaximeBaker thanks so much for the response, I did try that but might be doing something incorrectly, I did (after a long night) manage to make it work using “Make.com” I used the glide module, “Get Rows” to get all the rows in the table, built an array, used a shuffle and then “Get Single row” once I had that row, put that it in the new Table with an “Add Row” and then used a “Delete row” to remove that original row from the original table. I will then use a workflow to time the entries in the new table for one month, and then place all the data back into the original table and start the whole process again for the next month. (I’m trying to display content daily and not repeat the same content on a monthly basis) Now that’s a lot of steps and I also lose the original ID number. So with that in mind, do you know of a more elegant way of doing it natively? I thried using the documentation that I found here, but either it’s old or i’m doing something incorrectly because mine does not display like this https://www.glideapps.com/docs/automation/actions/shuffle-orderThanks again as always, you guys rock
I would use shuffle in a collection limited to one, with a filter conditions based on another table (the table you add rows to). In that condition (from a query column), there would be a date condition to show or not the element in the query.
Thank you so much for the comment:)
@MaximeBaker Thank you so much, WOW, I really went the long way around didn’t I haha. Your suggestion makes perfect sense now, I was getting so hung up about shifting data around different tables that I kinda lost the point of applying conditions to the table I already had. I think that is the biggest trap for low coders, we get stuck in a literal way of trying to complete the tasks rather than the most efficient way of doing things. Plus it doesn’t help when you’re on a client deadline and you start to panic hahaha. That’s why I can’t thank you and the other Gliders on this board enough for all the help, My wife and Kids thank you for bringing my stress levels down to a reasonable level 
2 Likes
I feel you! Thanks for the nice message! I appreciate!
Anytime!
This is commonly known as the XY Problem. Anyone that’s spent any significant amount of time providing tech support knows only too well about it 
3 Likes