# Text updates every 8 seconds

**URL:** <https://community.glideapps.com/t/text-updates-every-8-seconds/80910>\
**Category:** Ask for Help\
**Created:** [March 23, 2025, 1:59am UTC](https://community.glideapps.com/t/text-updates-every-8-seconds/80910 "2025-03-23T01:59:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Masters\_Pool](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/masters_pool/32/84458_2.png) [@Masters\_Pool](https://community.glideapps.com/u/Masters_Pool)\
**Post date:** [March 23, 2025, 1:59am UTC](https://community.glideapps.com/t/text-updates-every-8-seconds/80910/1 "2025-03-23T01:59:48Z")

</div>

I’m trying to cycle through 50 different quotes so they each show up for a few seconds each. Aesthetically I have an image on top of the screen and a simple text component below. I can get the spreadsheet to renew the text as often as I’d like but the app only updates from the spreadsheet every few minutes. I’m a total hack at this and everything’s been trial and error up to this point but I cannot figure this one out. Any help would be greatly appreciated.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 23, 2025, 7:02am UTC](https://community.glideapps.com/t/text-updates-every-8-seconds/80910/2 "2025-03-23T07:02:12Z")

</div>

Are these quotes actual documents, or just blocks of text?  
You talk about a spreadsheet - does that mean you’re using an external data source?  
I’d recommend using native tables, then you don’t have sync delays to deal with.  
You can probably do something with a bit of date/time math, but it would be useful to understand how your data is structured. Can you provide a screen shot or two?

---

<div class="post-metadata">

**Author:** ![Masters\_Pool](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/masters_pool/32/84458_2.png) [@Masters\_Pool](https://community.glideapps.com/u/Masters_Pool)\
**Post date:** [March 23, 2025, 2:20pm UTC](https://community.glideapps.com/t/text-updates-every-8-seconds/80910/3 "2025-03-23T14:20:10Z")

</div>

Hi Derren,

Appreciate the speedy responses. I’m using google sheets as the data source. Each quote(block of text) is in its own cell. See attachments.(side note, I run a masters pool and try to entertain the participants a bit…this section is AI generated quips about the players) I haven’t used native tables yet but I’ll take a look now. I’m not at all a programmer so could definitely use some direction if the solution calls for some code.

 ![Screen Shot 2025-03-23 at 10.02.53 AM.png](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/5/755101f7b726d97a4114f22cb537cbc56622ddb6.jpeg)  
 ![Screen Shot 2025-03-23 at 10.02.14 AM.png](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3abf16313e605de7bdb8aa18bc9f4d53d65a5956.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 25, 2025, 12:08am UTC](https://community.glideapps.com/t/text-updates-every-8-seconds/80910/4 "2025-03-25T00:08:08Z")

</div>

Legend says that @Darren_Murphy responds in seconds if the post is related to golf.

For your case, I would try a custom component with an approach like this.

- Create a JSON object in your ParBot table, with one for the quote, one for the player, maybe one for an image as well if you have it.
- In your Users table, create a joined list targetting the JSON object above, joining them by a comma and a new line character.
- In your Users table, add a template column with the template being this:

```auto
[
J
]

```

Replace the J by the result of the joined list column above. Now you have a valid JSON structure to work with.

Add a custom component to your screen, add the final JSON as data, with the variable name being quotesJSON and prompt it like this:

```auto
Here's a sample from my quotesJSON input:

{
"quote": "Quote here",
"player": "Player name here",
"image": "Image here"
}

Please create a card component that cycles through each element every 8 seconds.

```

Then adjust it as needed through more prompting. You might want to add the cycleDuration as a variable and change it from 8 to whatever number you want.
