Is it possible to display a random, filtered, value from a Local Table for my Movie Game App

[iamadamlongbqexdv]

I am building a simple game where players enter data (actor names) and ‘shuffle’ the list so a random name appears. I’m using a simple local table with two columns (Player Name) and (Entry 1) That functionality is working great.

I wanted to add some complexity and display the name of the person who submitted the actor (also working) and the name of ANY OTHER player besides the one who submitted the selected entry - they would be responsible for choosing the movie.

So basically on this page I’d like to display three items:

1. The text in the Entry 1 column from a random row of the local table “Movie Bowl Table” (working)
2. The text in the Player name column from the same row as item 1 (working)
3. Text from any other row of the local table “Movie Bowl Table” where Player Name is NOT equal to the text displayed in item 2. (Not Working)

Here is a screenshot of what I’ve built. When I test it is displaying items 1 and 2 correctly. Item 3 is displaying as “abc” which I know is because I have my list-building and filtering blocks wrong. Can anyone help?

[tatiang]

Have you tried putting the variable j in the spot where “abc” is shown? So that block would read as insert at last as j.

[iamadamlongbqexdv]

Thank you! If I just replace “abc” with “j” it just shows “j” on the results screen. BUT if I put in the variable “j” it appears to be pulling from the database (progress!)

However, it is allowing duplicate values. The names in the red boxes (previously just saying “abc” or “j” at the top of the screen) shouldn’t ever be the same name. Screenshots added.

[tatiang]

Can you share a link to the project?

[iamadamlongbqexdv]

I’m new to Thunkable - so if I didn’ share correctly let me know: Thunkable

[tatiang]

You did it correctly.

[tatiang]

Every time I preview it, I get Steve and Chris or Chris and Steve. No duplicates. Are you testing this in a browser or in Thunkable Live on a mobile device?

One thing to try is to add a wait block to your loop:

Wait 0 seconds is still a very slight delay in the code. Sometimes that can be enough to fix loop issues.

Edit: When I view this in Thunkable Live on an iPhone 13 Pro and display the list of values in Player Name in a label, it’s blank:

I don’t know why it’s not able to get the local data source values. This displays 6 in the browser but only 1 on my phone:

Edit #2: Okay, it has to do with the data source being a stored data source. When I change it to an app data source, it works as expected. I’m not sure why the stored version is getting deleted.

[iamadamlongbqexdv]

Thank you. I will test this later this evening. We are currently testing this on Thunkable’s live on my laptop.

[tatiang]

@iamadamlongbqexdv

We are currently testing this on Thunkable’s live on my laptop.

The two ways to test a project (without downloading or publishing it) are:

1. In a desktop/laptop browser such as Chrome using the Preview button:
   

   

2. On a mobile device in the Thunkable Live app using the Live Test on Device button.

It’s not possible to use Thunkable Live on a laptop so I assume you’re previewing it in a browser on your laptop (#1).

[iamadamlongbqexdv]

I installed the Thunkable Live App and it appears to be working on my iPhone 15 - I’ve cycled through about 15 rounds with 9 entries (3 players) and there have been no duplicates!

Thank you for your help! It may seem silly since it’s just a game but really feels awesome to build something from scratch - hopefully first of many things.