# Pick random record solution

**URL:** <https://community.glideapps.com/t/pick-random-record-solution/79774>\
**Category:** General\
**Tags:** actions\
**Created:** [February 4, 2025, 6:24pm UTC](https://community.glideapps.com/t/pick-random-record-solution/79774 "2025-02-04T18:24:11Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexey\_Khrolovich](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_khrolovich/32/37980_2.png) [@Alexey\_Khrolovich](https://community.glideapps.com/u/Alexey_Khrolovich)\
**Post date:** [February 4, 2025, 6:24pm UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/1 "2025-02-04T18:24:11Z")

</div>

Hi All!  
I want do demonstrate different phrases to user after actions in app.  
So i generate few variants of short phrases with Ai and make separate table with them.

But how to randomize choise of row to show notification?

what i did looks for me not so best solution. Maybe i can have good advise.

Here is my solution:  
I add table with columns - “phrase” and “nr” with 60 variants of fhrases and numbers 0-59

In user table i add columns:  
1️⃣"current second" - math column with formula Second(now)  
so it shows different values from 0 to 59 each second.  
2️⃣rel\_Phrase - relation “current second” → “nr” from phrases table (1 value)

3️⃣lookup\_phrase - lookup from rel\_Phrase which gives different text each second.

And so in all action workflows i add action “show notification” from user profile column lookup\_phrase.

Now any time users do actions they receive different variants of praise phrases.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 5, 2025, 12:47am UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/2 "2025-02-05T00:47:22Z")

</div>

> [@Alexey\_Khrolovich](#):
>
> But how to randomize choise of row to show notification?

There is an action called shuffle order. Did you try that?

Else, you could use the single value column and get a random value.

---

<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:** [February 5, 2025, 3:20am UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/3 "2025-02-05T03:20:48Z")

</div>

> [@MaximeBaker](#):
>
> Else, you could use the single value column and get a random value.

I can’t recall when the random value would get “recalculated” using that method. I’m thinking of using Roll Dice with the seed being the current time.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 5, 2025, 3:26am UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/4 "2025-02-05T03:26:20Z")

</div>

You are right.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 5, 2025, 3:29am UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/5 "2025-02-05T03:29:46Z")

</div>

Actually no you are not. I was able to refresh single value random by using the shuffle order action 😃 niiice

---

<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:** [February 5, 2025, 3:31am UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/6 "2025-02-05T03:31:21Z")

</div>

I mean I don’t recall when it would be “recalculated”, not stating a fact.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 5, 2025, 10:34am UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/7 "2025-02-05T10:34:59Z")

</div>

> [@ThinhDinh](#):
>
> I mean I don’t recall when it would be “recalculated”, not stating a fact

Oh okay sorry!

---

<div class="post-metadata">

**Author:** ![Alexey\_Khrolovich](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_khrolovich/32/37980_2.png) [@Alexey\_Khrolovich](https://community.glideapps.com/u/Alexey_Khrolovich)\
**Post date:** [February 5, 2025, 12:00pm UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/8 "2025-02-05T12:00:21Z")

</div>

looks like my solution is best one, except i add roll dice column based on time column so i can have more numbers than 60

---

<div class="post-metadata">

**Author:** ![Alexey\_Khrolovich](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_khrolovich/32/37980_2.png) [@Alexey\_Khrolovich](https://community.glideapps.com/u/Alexey_Khrolovich)\
**Post date:** [February 5, 2025, 12:02pm UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/9 "2025-02-05T12:02:23Z")

</div>

oh no, roll dice have same outputs with same seed values… need more random

---

<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:** [February 5, 2025, 2:19pm UTC](https://community.glideapps.com/t/pick-random-record-solution/79774/10 "2025-02-05T14:19:38Z")

</div>

Add a template combining the current time with the rowID, I think.
