# How to show specific information from a table of real time firebase database **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** firebase, help\ **Created:** [June 6, 2024, 11:08am UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962 "2024-06-06T11:08:20Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![itsvedanttikareztlgx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsvedanttikareztlgx/32/179520_2.png) [@itsvedanttikareztlgx](https://community.thunkable.com/u/itsvedanttikareztlgx)\ **Post date:** [June 6, 2024, 11:08am UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/1 "2024-06-06T11:08:20Z")
okay I understand the question seems unclear and confusing so let me explain So with this snippet ![Screenshot 2024-06-06 153755](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/3/83cfdab325ba97ea40b16d14a23b5bb84c7ae9af.png) I get this result ![Screenshot 2024-06-06 153815](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/1/8198a54e7d7865d78bad6b6831c6d13f09cb8b26.png) **Now how do I make a blocks so that I can access information inside the items from simple list??** Now I have tried this ![Screenshot 2024-06-06 163051](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/8/48295acd435b099f31d49660312f5199a4469406.png) and this results to this ![Screenshot 2024-06-06 163310](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/f/bf788bb10c377773283160783821562dc5dd53b4.png) Now when I clicked on any city the result was same, but I want ciy specific results to appear Here is my database ![Screenshot 2024-06-06 163622](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/8/d8abc6eccfe428b9eba71fe881921432dfbbed44.png) **what do I do?** ---
**Author:** ![marion.dorsett](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/marion.dorsett/32/175129_2.png) [@marion.dorsett](https://community.thunkable.com/u/marion.dorsett)\ **Post date:** [June 6, 2024, 6:23pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/2 "2024-06-06T18:23:54Z")
This works to break out the data like you want, you just need to refactor it to work on the list item click like you want. ![json-non-normalized-list-02](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/8/686bb77fc829516135a0baae8bf8b38ad584f0f5.png) ![json-non-normalized-list](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/0/10a456f3fefbb46ad7167e96af48f4f5b7e4706f.png) ---
**Author:** ![itsvedanttikareztlgx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsvedanttikareztlgx/32/179520_2.png) [@itsvedanttikareztlgx](https://community.thunkable.com/u/itsvedanttikareztlgx)\ **Post date:** [June 7, 2024, 1:02pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/3 "2024-06-07T13:02:55Z")
I tried the blocks and I seemed to have missed something here are my blocks and their result ![Screenshot 2024-06-07 182618](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f84ad46cf607e67b31d0799f3b0b4ce8b3a5749.png) I also tried not putting anything in those initialized app variables and even tried putting their values null ![Screenshot 2024-06-07 182628](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/8/88327af9ef12df4521a5d162a4de78706425dea0.png) ![Screenshot 2024-06-07 182658](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/1/410e4c984661a91828d0a635b1a4c0c877a17441.png) **I want to access list specific elements when I click on the items** **example say I click on mumbai then I want to access info in mumbai in my database which would be CNN** ---
**Author:** ![marion.dorsett](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/marion.dorsett/32/175129_2.png) [@marion.dorsett](https://community.thunkable.com/u/marion.dorsett)\ **Post date:** [June 7, 2024, 2:30pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/4 "2024-06-07T14:30:19Z")
You have the wrong block in your setup when setting the temp value. Use get object properties of “j” …not get property of object “j” ![json-non-normalized-list-03](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/6/361bef50947fd82aaa0ad1a44d6bd19d45f17e7a.png) ---
**Author:** ![itsvedanttikareztlgx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsvedanttikareztlgx/32/179520_2.png) [@itsvedanttikareztlgx](https://community.thunkable.com/u/itsvedanttikareztlgx)\ **Post date:** [June 7, 2024, 3:01pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/5 "2024-06-07T15:01:01Z")
So I fixed the mistake, and I still seem to be missing something all other things are same in the app and database ---
**Author:** ![marion.dorsett](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/marion.dorsett/32/175129_2.png) [@marion.dorsett](https://community.thunkable.com/u/marion.dorsett)\ **Post date:** [June 7, 2024, 3:04pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/6 "2024-06-07T15:04:53Z")
I would do a hard refresh on your browser (ctrl+shift+r) or (cmd+shift+r) and verify the block change, and then try running the app again. I’ve had issues with blocks not actually changing and having to force the cache to reload before I could see changes. I’ll take another look at the blocks and see if I can see if I missed something too. ---
**Author:** ![marion.dorsett](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/marion.dorsett/32/175129_2.png) [@marion.dorsett](https://community.thunkable.com/u/marion.dorsett)\ **Post date:** [June 7, 2024, 3:17pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/7 "2024-06-07T15:17:48Z")
Another possiblity is that I translated the JSON wrong. Here’s what I setup based on your example image: {“city”: {“kolhapur”:{“library”:{“BBC”:“”}},“mumbai”:{“CNN”:“”},“pune”:{“BCC”:“”}}} ---
**Author:** ![itsvedanttikareztlgx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsvedanttikareztlgx/32/179520_2.png) [@itsvedanttikareztlgx](https://community.thunkable.com/u/itsvedanttikareztlgx)\ **Post date:** [June 8, 2024, 10:31am UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/9 "2024-06-08T10:31:06Z")
so your JSON is right and I have restarted my device too but the problem still has not been solved. I still see a blank screen, I’m not very sure what the issue might be but mean while can you explain the code block that you had given so that based on the logic if I make changes from my side I might see right results ---
**Author:** ![marion.dorsett](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/marion.dorsett/32/175129_2.png) [@marion.dorsett](https://community.thunkable.com/u/marion.dorsett)\ **Post date:** [June 8, 2024, 1:27pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/10 "2024-06-08T13:27:10Z")
Does this make sense to you? I moved some of the operations out of the getData function, but the process is the same. ![json-non-normalized-list-04](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/f/bf520f38f48027947fa82c1def3ba4bd73c1b851.png) ---
**Author:** ![itsvedanttikareztlgx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsvedanttikareztlgx/32/179520_2.png) [@itsvedanttikareztlgx](https://community.thunkable.com/u/itsvedanttikareztlgx)\ **Post date:** [June 8, 2024, 1:42pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/11 "2024-06-08T13:42:45Z")
So get data gives me values in both list when screen opens right? now what would be the process to make sure that the other list only shows the media when clicked on city so when mumbai clicked → show CNN ---
**Author:** ![marion.dorsett](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/marion.dorsett/32/175129_2.png) [@marion.dorsett](https://community.thunkable.com/u/marion.dorsett)\ **Post date:** [June 8, 2024, 2:32pm UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/12 "2024-06-08T14:32:30Z")
Simply by using the index of the item clicked from the city list. ![json-non-normalized-list-05](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/d/0dc7d6e87f089d7e441c09a08bd312a0a7ed509a.png) Since this is a single text string you could assign it as the Text of a Label component or button or were appropriate for your needs. ---
**Author:** ![itsvedanttikareztlgx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsvedanttikareztlgx/32/179520_2.png) [@itsvedanttikareztlgx](https://community.thunkable.com/u/itsvedanttikareztlgx)\ **Post date:** [June 9, 2024, 11:11am UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/13 "2024-06-09T11:11:18Z")
hey it works but I had to make some changes from my side for it work but still appreciate you feedbacks and responses thanks ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [September 7, 2024, 11:11am UTC](https://community.thunkable.com/t/how-to-show-specific-information-from-a-table-of-real-time-firebase-database/3044962/14 "2024-09-07T11:11:53Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.