# Alarm app with multiple recorded sounds **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [July 10, 2021, 8:10am UTC](https://community.thunkable.com/t/alarm-app-with-multiple-recorded-sounds/1388609 "2021-07-10T08:10:14Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![takehiko\_nakamura](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/takehiko_nakamura/32/110308_2.png) [@takehiko\_nakamura](https://community.thunkable.com/u/takehiko_nakamura)\ **Post date:** [July 10, 2021, 8:10am UTC](https://community.thunkable.com/t/alarm-app-with-multiple-recorded-sounds/1388609/1 "2021-07-10T08:10:14Z")
Hi Thunkers, This is my second try asking all of your help and knowledge for the same issue which has not been solved for more than a half a year. I have been trying to create an app that you can record multiple sounds and make each recorded sound to be used for alarm clock for each different time set. But, I have a trouble using multiple recorded sounds. Note: I know that Thunkable does not run in the background and the alarm will only sounds if and when the app is awake and active. I thought that I should use Vlookup method introduced in this community, but what needs to be found is row id for “j”. I want to know how I can get the row id for “j”. > [@Performing a VLOOKUP in LocalDB](https://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057): > > One of the most powerful features in Thunkable is the new [LocalDB](https://docs.thunkable.com/thunkable-cross-platform/create/components/data/local-db) component, which allows you to insert a mini-spreadsheet directly into your app. This might be the first of a larger series of tutorials mimicking features found in other spreadsheets, but for now let’s get started with VLOOKUP. question What is VLOOKUP? A [VLOOKUP](https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1), or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row art Design Let’s start… Below screen shot is what I have done so far. ![スクリーンショット 2021-07-03 18.25.51](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/a/0af69a730433e84dc2cc10061d341bb12e005d5a.png) I created an app where a recorded sound can be set at a time for an alarm. For example, I am able to set it at 7:00am to sound a recorded sound, and it works. [Thunkable](https://x.thunkable.com/copy/5881a8770de765fb728a9f1fe47cb949) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 10, 2021, 9:54am UTC](https://community.thunkable.com/t/alarm-app-with-multiple-recorded-sounds/1388609/2 "2021-07-10T09:54:21Z")
The row id can be found by using `list of values` just as you did but the column name should be “ID”. This is a reserved column name that stores the `row ID` for each row in the table. Happy Thunking! ---
**Author:** ![takehiko\_nakamura](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/takehiko_nakamura/32/110308_2.png) [@takehiko\_nakamura](https://community.thunkable.com/u/takehiko_nakamura)\ **Post date:** [July 13, 2021, 1:59pm UTC](https://community.thunkable.com/t/alarm-app-with-multiple-recorded-sounds/1388609/3 "2021-07-13T13:59:07Z")
Thank you for your response, muneer. I am not sure how I can find the row ID for “j” by using “list of values”. Can you show me more, please? From DB, the first thing that I need to find is an alarm time that matches with current time, and this is why I chose to use “for each item “j” in list”. So, “j” is one of the items that is in Alarm Time column in DB. And, the second thing that I want to find is the row ID for “j” to find a sound that is saved in the same row as the alarm time. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 15, 2021, 12:14pm UTC](https://community.thunkable.com/t/alarm-app-with-multiple-recorded-sounds/1388609/4 "2021-07-15T12:14:38Z")
An easy way to solve this one is to: - Create an app variable counter and set it to 0 - Before the loop `for each "j" in list`, set the variable counter to 0 - Before the `If condition` inside the loop, increase the counter by 1 - Use this counter as the `row number` to get the song/alarm file. This should work for you. ---
**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, 1:19pm UTC](https://community.thunkable.com/t/alarm-app-with-multiple-recorded-sounds/1388609/5 "2024-11-08T13:19:50Z")