How can I get a single random result returned from a database rather than the whole list?
I’m looking to create a simple page with a button that, when pressed, returns a random entry from a database. I have managed to get it to return all results from the database or the 1st result but can’t get it to return just a single random entry.
I see there is a filter field in the Entry Variables which is what I think I need to use but can’t work it out. I’ve tried adding an additional step to generate a random number which would then lookup against the database but can’t work out how to use this as an Entry Var for the Get Database Data action.
I’m not sure if it’s beyond my abilities or I’m missing the obvious. Any help would be massively appreciated!!