# How to display text in column corresponding to first column **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [December 21, 2020, 3:02pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694 "2020-12-21T15:02:45Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![looovelee](https://avatars.discourse-cdn.com/v4/letter/l/e19b73/32.png) [@looovelee](https://community.thunkable.com/u/looovelee)\ **Post date:** [December 21, 2020, 3:02pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/1 "2020-12-21T15:02:46Z")
Good evening Thunkers! 👋🏻 My app streams audio files from a thunkable database list. Each time the audio is played, it is removed from the list and then when everything on the list has been played, it automatically refreshes the list and starts again, all music is always in a shuffled order. 😀 **GOAL:** To display the title of each audio file being played. “Trackfiles” is the first column. This houses my audio URLs to stream. I added a text label called “displaytext” to call the text written in the 2nd column (also called “displaytext”) of this database. When I tested it, it displays _all_ of the columns at once like: _“text1, text2, text3… etc”_. I need one row at a time, the same row as the audio file being streamed. I hope I am explaining this well! I will add a screenshot of my work so far to give more context. ![Screen Shot 2020-12-21 at 14.54.54](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/8/b8e1b81b700a7307a6daae677b197ae57df2beed.png) Thank you so much in advance for your advice! I really appreciate it. It’s becoming very complex for me, as I am definitely a beginner! 😅 ---
**Author:** ![looovelee](https://avatars.discourse-cdn.com/v4/letter/l/e19b73/32.png) [@looovelee](https://community.thunkable.com/u/looovelee)\ **Post date:** [December 26, 2020, 3:17pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/2 "2020-12-26T15:17:22Z")
Can anyone advise how to use the database columns correctly? Attaching column 2 to the corresponding row in column 1 to show the title of the streaming audio track? I’d really appreciate your help! Many thanks Thunkers! 😅 ---
**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:** [December 27, 2020, 1:33am UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/3 "2020-12-27T01:33:05Z")
The variable displaytext is a list and you should use it the same way you use the variable tracks. To accomplish what you want, first change the order of blocks in the screen open event. The loading of columns to displaytext comes first then the function “set track” Inside the function “set track” you need first use a variable to store the random number. Now, you are using it directly in variable thistrack. You need to use the same random number to choose the track and to display the track title in the same way. You will also need to refresh the list displaytext in the function “reset” the same way you refresh the list tracks. Hope this helps ---
**Author:** ![looovelee](https://avatars.discourse-cdn.com/v4/letter/l/e19b73/32.png) [@looovelee](https://community.thunkable.com/u/looovelee)\ **Post date:** [January 29, 2021, 3:30pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/4 "2021-01-29T15:30:50Z")
> [@muneer](#): > > Inside the function “set track” you need first use a variable to store the random number. Now, you are using it directly in variable thistrack. > > You need to use the same random number to choose the track and to display the track title in the same way. 👋🏻 Hi Muneer! Thank you so much for your advice! I believe that I understand the rest of your suggestions above, and what you’ve said here makes sense in my mind - however applying it in the blocks is confusing me a little… 😬 Would you mind possibly sharing an example of blocks to convey this? Thanks again for all of your time and help! 😁 ---
**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:** [January 29, 2021, 3:41pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/5 "2021-01-29T15:41:11Z")
I made this sample project for another member of the community but it should show the concept. [https://x.thunkable.com/projectPage/601251952713580012555b7a](https://x.thunkable.com/projectPage/601251952713580012555b7a) When you select an item from list one, I use the index to open the link in list 2 Hope this helps ---
**Author:** ![looovelee](https://avatars.discourse-cdn.com/v4/letter/l/e19b73/32.png) [@looovelee](https://community.thunkable.com/u/looovelee)\ **Post date:** [February 4, 2021, 9:53pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/6 "2021-02-04T21:53:23Z")
Thank you so much Muneer! I see what you did here and it makes a lot of sense when I look at it! 😀 I have a few questions, as my app is getting a bit complicated (to me!) & my head is spinning as I try to adapt these concepts to what I have already. I hope you don’t mind a few additional Q’s… 🙏🏼 I set display text to connect to the variable “displayverse”. I’m not sure if that’s right, but if I set it to “displaytext”, all of the rows immediately end up showing together. I am also unsure how to connect an individual item and index to my blocks without “list viewer” - is that an essential element here? I wasn’t sure, because I am not using a list to click - these audio files are being randomly selected from col 1 and the corresponding text in col 2 needs to display. No written lists are needed. Do I add all of this functionality within “set track”? 🤔 Apologies if this is all a bit obvious, it isn’t to me! 😅 Thank you again for you time and advice - it’s much appreciated! ![Screen Shot 2021-02-04 at 21.41.40](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/e/5e7382051caa7275b8735bfe0260b62fa1c2279f.png) ---
**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:** [February 5, 2021, 8:27am UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/7 "2021-02-05T08:27:38Z")
Please see my explanation in this sample project [https://x.thunkable.com/projectPage/601cf5c2988b8128b77e801e](https://x.thunkable.com/projectPage/601cf5c2988b8128b77e801e) ---
**Author:** ![looovelee](https://avatars.discourse-cdn.com/v4/letter/l/e19b73/32.png) [@looovelee](https://community.thunkable.com/u/looovelee)\ **Post date:** [April 10, 2021, 4:23pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/8 "2021-04-10T16:23:17Z")
Muneer, I **really can’t thank you enough** for all of your help! This worked so well when I adapted it to the app, just perfect! 💯 !!! **Thank you so so much** for all of your time and effort to put these samples together so I could understand it. That made all of the difference, and now I have a functioning app!!! 🤩 ---
**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:** [April 10, 2021, 5:08pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/9 "2021-04-10T17:08:07Z")
Glad it worked 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, 12:19pm UTC](https://community.thunkable.com/t/how-to-display-text-in-column-corresponding-to-first-column/1040694/10 "2024-11-08T12:19:26Z")