# Randomly display a record (quote) on a new screen

**URL:** <https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157>\
**Category:** Database\
**Created:** [April 18, 2023, 2:35pm UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157 "2023-04-18T14:35:29Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![hellonewuser](https://avatars.discourse-cdn.com/v4/letter/h/76d3ee/32.png) [@hellonewuser](https://forum.adalo.com/u/hellonewuser)\
**Post date:** [April 18, 2023, 2:35pm UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/1 "2023-04-18T14:35:29Z")

</div>

Hi  
I’ve been trying to set this up myself but nothing seems to work.  
How do I display the next database record every time a button is clicked?  
For example.

A button is clicked on home page, the user is taken to another screen and he sees a quote.  
Every time the user clicks on the button on the home screen he’s shown a new quote. (could be picked randomly from the database collection record)

I created a database collection and added the quotes there.

What would you guys recommend?  
Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [April 18, 2023, 2:47pm UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/2 "2023-04-18T14:47:23Z")

</div>

Hi @hellonewuser,

Welcome to the forum!  
There are few options for this, in particular:

1. you can use “Random Picker” component from the Marketplace (it’s free). You will need to setup this component to connect it to “Quotes” collection, select “Trigger Click Action” (what happens on click) and then add an action to link to another screen. On that screen you will have “Current Quote” available and you can display it.  
Random picker should select a random record from the Quotes collection every time.

2. Another approach will be to use randomly generated numbers. For this you will have to:

- upload the quotes to Quotes collection and make sure you don’t delete any
- as a result you will have list of quotes with incremental IDs (say, from 1 to 10)
- add a property to Users collection, call it a “QuoteID”
- on the Home screen, add a button to go to the next screen
- on this button, add an action to update Logged-in User → QuoteID, make it a function RAND (1,10) - use lowest and highest number from IDs in Quotes collection
- the next action will be to go to another screen
- on this another screen, add a list. Make it a list of Quotes, filtered by ID = Logged in User → QuoteID.  
As a result, this list will display only one quote (the one with ID which is equal to the randomly generated QuoteID).

1. You can use Random number, Adalo API calls with limit and offset, but this is a bit too complicated.

Just in case, there were similar questions before - you can search through the forum.

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![hellonewuser](https://avatars.discourse-cdn.com/v4/letter/h/76d3ee/32.png) [@hellonewuser](https://forum.adalo.com/u/hellonewuser)\
**Post date:** [April 18, 2023, 7:40pm UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/3 "2023-04-18T19:40:02Z")

</div>

THANKS!  
could you please specify here

- add a property to Users collection, call it a “QuoteID”

should it be a text or number?

and I tried the random picker btw, but it doesn’t do the job. the quote is always inside the frame and the text is never displayed correctly.

thanks again

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [April 18, 2023, 10:19pm UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/4 "2023-04-18T22:19:47Z")

</div>

Hi @hellonewuser ,

Adding to the explanation of @Victor ,

I have made an example app here,

> [@Free Template - Komun for Community Support - In Progress](https://forum.adalo.com/t/free-template-komun-for-community-support-in-progress/18793):
>
> Hi All, I am building this cloneable app to extend the free Chat template to include social media functions. This app is about Community Support that its users can see progress of the activities within a project. Project is a mission that a community want to accomplish. Activity is an event to support the project that its participants can comment and reply. It is useful if the activity is happening offline so each users can participate and taking photo and build momentum which later can be …

It is cloneable, so you can see what is inside,

Here is a screenshot related to your asking,

 ![Screen Shot 2023-04-19 at 5.17.09 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/9/3/931870a6f4e11082adfa3b5707f87246d8818170.png)

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [April 19, 2023, 11:07am UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/5 "2023-04-19T11:07:10Z")

</div>

Hello @hellonewuser,

You’re welcome.

Random picker works perfectly, you just didn’t set it up correctly. There is a setting called “Display Text”, by default Random Picker puts the 1st property of the collection inside it. You can replace this setting with anything you want.

In regards to ID - it needs to be numeric. @Yongki has shared the example already 🙂

Best,  
Victor.

---

<div class="post-metadata">

**Author:** ![hellonewuser](https://avatars.discourse-cdn.com/v4/letter/h/76d3ee/32.png) [@hellonewuser](https://forum.adalo.com/u/hellonewuser)\
**Post date:** [April 19, 2023, 1:51pm UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/6 "2023-04-19T13:51:59Z")

</div>

thanks a lot!

---

<div class="post-metadata">

**Author:** ![hellonewuser](https://avatars.discourse-cdn.com/v4/letter/h/76d3ee/32.png) [@hellonewuser](https://forum.adalo.com/u/hellonewuser)\
**Post date:** [April 19, 2023, 2:06pm UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/7 "2023-04-19T14:06:00Z")

</div>

Thanks! it worked!

---

<div class="post-metadata">

**Author:** ![Wiseman](https://avatars.discourse-cdn.com/v4/letter/w/d07c76/32.png) [@Wiseman](https://forum.adalo.com/u/Wiseman)\
**Post date:** [October 14, 2025, 8:15am UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/8 "2025-10-14T08:15:11Z")

</div>

For the first option, what if the user doesn’t interact with the component? “ Picker”

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [October 14, 2025, 2:03pm UTC](https://forum.adalo.com/t/randomly-display-a-record-quote-on-a-new-screen/38157/9 "2025-10-14T14:03:18Z")

</div>

@Wiseman if a user does not interact with the component, nothing will happen.
