I’d like to create a button that every time you click, brings a randomized row from a particular column in a table. I’m able to create the randomized content, but don’t seem to be able to use the button to initiate the next randomized row. Setting the formula to true, updates anytime the page is edited (not helpful). And setting it to false seems to preclude any more randomization. I’d like to randomize every time the button is clicked.
I was going to take a look at it for you but the permission are set so that the document is view only and set so that users cannot copy the document. Can you change either one of those setting so that the community can assist?
I am curious how get a function properly at work without _Delay()
Over time I tried many simple solution, in the end they all failed due to limitations as described by @Paul_Danyliuk . An elegant one that still stands is one that makes use of two related buttons and a _Delay(). This I have seen at work in a doc from @joost_mineur
Generally speaking, the only bulletproof way to generate X random numbers within the same frame (i.e. not having to rely on doc edit to happen in-between) is to utilize a helper table that will have as many rows as there are numbers required.
The sample below shows that. The button ensures that if there are not enough rows, more are generated, and then uses the numbers that update continuously and are row-specific as a random sequence:
Non-repeating items are also possible but for that you’d have to hook up the DB Names into the Random table itself (so that we could introspect on items that are already used)
Hi Scott, yes I think this is exactly the kind of thing I’m looking to adapt. I only have View access and when I copied the doc, it didn’t bring over the Edit page with the data. Could you add me as a user, so I can look at the structure you’ve created? Thanks so much!