# \[Solved\] How to Choose random User from database (For giveaway) **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** firebase, database, solved, help\ **Created:** [November 15, 2019, 7:25pm UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285 "2019-11-15T19:25:06Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![pingostudios](https://avatars.discourse-cdn.com/v4/letter/p/e9bcb4/32.png) [@pingostudios](https://community.thunkable.com/u/pingostudios)\ **Post date:** [November 15, 2019, 7:25pm UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/1 "2019-11-15T19:25:06Z")
Guys iam doin a giveaway app and the entrys are assigned to the database so i wanna choose a random entry from the data base. what blocks should i use to random choose a TEXT from database. Thanks.😍 ---
**Author:** ![Sofia](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sofia/32/50160_2.png) [@Sofia](https://community.thunkable.com/u/Sofia)\ **Post date:** [November 15, 2019, 8:04pm UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/2 "2019-11-15T20:04:12Z")
Here is one solution to your problem: Use the random integer from x to y… so you modify it to be from 1 to (total entries of the giveaway) There is also ‘random item’ from the list sections you could use 🙂 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/6/46c28b82a69f407985f07eabae22204ea08ebba9.png) Good luck! @pingostudios ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [November 16, 2019, 3:06am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/3 "2019-11-16T03:06:45Z")
Hi, @pingostudios! 👋 > [@pingostudios](#): > > from the data base Which database are you using? If you are using AirTable, you need to get a Column/All Rows (or whatever format you have) and attach this block to them - (as @Sofia said) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/b/cb231a6b0fb9c1532486f28698992af40cf04c70.png) Hope I helped you! 😄 Thanks! 😊 ---
**Author:** ![pingostudios](https://avatars.discourse-cdn.com/v4/letter/p/e9bcb4/32.png) [@pingostudios](https://community.thunkable.com/u/pingostudios)\ **Post date:** [November 16, 2019, 8:06am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/4 "2019-11-16T08:06:07Z")
Thanks for helping but I meant firebase database. But that would help in another project.👍🙂 Thanks​:heart:🧡💛💚💙💜 ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [November 16, 2019, 8:06am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/5 "2019-11-16T08:06:38Z")
So, your Problem is solved or not? ---
**Author:** ![pingostudios](https://avatars.discourse-cdn.com/v4/letter/p/e9bcb4/32.png) [@pingostudios](https://community.thunkable.com/u/pingostudios)\ **Post date:** [November 16, 2019, 8:15am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/6 "2019-11-16T08:15:35Z")
Yeah by @Sofia ---
**Author:** ![pingostudios](https://avatars.discourse-cdn.com/v4/letter/p/e9bcb4/32.png) [@pingostudios](https://community.thunkable.com/u/pingostudios)\ **Post date:** [November 16, 2019, 8:17am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/7 "2019-11-16T08:17:01Z")
Thanks @Sofia 😁 You solved my problem. 👍❤ ---
**Author:** ![suko1857r6rth](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@suko1857r6rth](https://community.thunkable.com/u/suko1857r6rth)\ **Post date:** [January 4, 2022, 3:33am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/8 "2022-01-04T03:33:38Z")
When the screen is opened among the data from 1 to 100, / it is hoped that ‘one data (1 to 100) will be automatically selected and output randomly’. I’m trying with a spreadsheet, but it doesn’t work. Help me. > [@\[Solved\] How to Choose random User from database (For giveaway)](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/6): > > Yeah by @Sofia I’m referring to this, but there’s no " in Local\_DB1 call GetCell ~~" ---
**Author:** ![suko1857r6rth](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@suko1857r6rth](https://community.thunkable.com/u/suko1857r6rth)\ **Post date:** [January 4, 2022, 7:23am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/9 "2022-01-04T07:23:25Z")
WHERE IS BLOCK (you told : in ~~call~~ column ~)? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 4, 2022, 7:38am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/10 "2022-01-04T07:38:05Z")
It’s a Data Source block. See this: > **[Data Sources](https://docs.thunkable.com/data-sources#read)** > > The Data Sources blocks allow you work with the information that you have stored in your connected Airtable Bases, Google Sheets or Local Tables. It’s going to look a little different because this topic is two years old and some of the blocks have changed. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 11:46am UTC](https://community.thunkable.com/t/solved-how-to-choose-random-user-from-database-for-giveaway/322285/11 "2024-11-08T11:46:38Z")