I’m just getting started with Glide (free version) and trying to do something super simple but just can’t figure out how to do it – what i’m trying to do is have a tab where there is a button, and when tapped, the UI should simply return a random cell from a specific column (or a random row if more than one column) and display it without revealing anything else. Each button tap displays a new random cell. Thanks in advance for any tips you can share!

You can try to use the new reshuffle action item. :twisted_rightwards_arrows: Something random this way comes

thanks robert! mind re-linking – the link you shared says its private or does not exist.

[image] twisted_rightwards_arrows Something random this way comes In staging now…the shuffle action!

ah gotcha, not exactly what im trying to do but ill give it a try!

You need: A column to register an update event (switch). A column that calculates a random number between 0 and max rows in your list. Use this random number to lookup with INDEX() and return a row. If you can show your app, it will help us answer your question better.

Thanks, Amit. app isn’t really functional so not sure if there’s value in sharing. at a high level, trying to create to main pieces of functionality: Data entry screen with 1 to n fields that creates a new row in a spreadsheet A retrieval screen where when the user taps a button, it will randomly return an entire row (or even just a random cell from a specific column). The total number of rows isn’t fixed however, since its dependent on how many things are entered in the first screen. (i’d also be curious on how to delete that row that’s been returned here but I think thats easier based on the features ive played with so far). im gonna play around some more and see if i can figure out how to construct this logic, but if you have pointers, i’d welcome them. Thanks!

New to Glide -- Button that displays random cell?

Ask for Help

Robert_Petitto May 28, 2020, 8:41pm 2

You can try to use the new reshuffle action item.

Something random this way comes

Topic		Replies	Views
Random numbers change in googlesheet but not in Glide Data Report a Bug	10	1584	April 15, 2020
Random button Ask for Help	10	3140	April 6, 2020
Slow Randomization Ask for Help	4	310	November 3, 2022
Select a random row Ask for Help	7	143	March 15, 2025
How to refresh RAND()? Ask for Help	4	687	April 6, 2023

New to Glide -- Button that displays random cell?

Related topics