I have found a way to do this without code. Sharing it in case anyone is interested.
So my aim was to press a button resulting in the next page showing randomized user details.
Breaking down that into logic is to generate a random object Id, and pass it on to the next page as page parameter, which the formulas could use to get other details of this specific objectId.
In my generate random button’s logic flow, formula for that GET RECORD was LOOKUP(PICK_ITEM(data.userUpdates1, RANDOM_INTEGER_BETWEEN(0, COUNT(data.userUpdates1)-1)), ‘objectId’)
Explaining this logic:
First, a random integer between the first row and the last row of objects will be generated.
With PICK_ITEM, that row will be picked within your database. Mine was called userUpdates1
With LOOKUP, the objectId of that specific row will be picked up and placed into the response of GET RECORD.
The logic flow continues with a Open Page component, with the value of it being the response of the GET RECORD.
This then passes the randomized objectId to the next page.
And in the page I’m opening, all fields to be populated with data related to this objectId passed over has similar formula structure to data.userUpdates1.username
You could replace username with whatever column you want to depict data from.