# Firebase Lookup A B C D with Thunkable Drop downs and return E F G H from Firebase
**URL:** https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465
**Category:** Questions about Thunkable X
**Created:** [September 18, 2021, 8:37am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465 "2021-09-18T08:37:50Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@towball](https://community.thunkable.com/u/towball)
#### Post date: [September 18, 2021, 8:37am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/1 "2021-09-18T08:37:50Z")
Hi
I want Firebase to store 10 fields of data in a row or similar and there could be 1000 or more rows
Lets say
Make, Year, Model, Variant and 6 other bits of Info
There are many Makes with many combinations
In thunkable I need to create 4 drop down boxes where the user would enter a Make and Year of manufacture then Firebase returns in the third drop down, a list of Models, a Model is selected then firebase returns in the fourth drop down, a list of Variants.
Once there is a match in Firebase of the first 4 fields I want to return the other 6 fields in Firebase to a list
I am connected to firebase and have written a very simple save to Firebase using Join with Comma’s and Get from Firebase using a list and list from text to extract to a list
I dont want to store all this info in the phone or variables. Easier to update and manage all the combinations in Firebase…
Is Firebase able to offer this lookup type function and return more info based on a match
Regards
Baz
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [September 18, 2021, 10:46am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/2 "2021-09-18T10:46:44Z")
Can you give an example so it becomes clear, at least to me, and I will make a sample project to reflect the requirement.
In short, Firebase is a JSON based database and you will need to look into things differently if you want to make the best use of it.
You will structure your data as blocks of `objects` and your rows and `object arrays / lists`.
This is how rows are saved in Firebase
Each row contains multiple pieces of information such as
---
### Author:  [@towball](https://community.thunkable.com/u/towball)
#### Post date: [September 18, 2021, 11:37am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/3 "2021-09-18T11:37:43Z")
Hi Muneer
Airtable might be a better tool for entering data and keeping it up to date
I need a similar principle to Redbook where you look up Make Model Year.
[https://www.redbook.com.au/](https://www.redbook.com.au/)
My intention is to enter many many rows of data for each vehicle brand and return some very specific data if Make Model Variant and Year match
Once the Make Model Year and Variant match what I have already entered into Firebase or Airtable, then other fields are returned to Thunkable App and need to display in with a label and the data. Example Colour - White. Colour being a label and White being the data
Example
1.Entering Jeep in the first drop down would then load the relevant options in the second drop down
2. Options in next drop down might be - Grand Cherokee, Cherokee, Blackhawk
3. Options in next drop down might be - 2014, 2015
4. Options in next drop down might be - Petrol or Diesel
Once the match has been made with the above data then I want to return other information about the vehicle, another 6 fields of info
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [September 18, 2021, 11:59am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/4 "2021-09-18T11:59:59Z")
First of all, Firebase is catered for large volume and you can easily store and retrieve hundred of thousands of records with ease and relatively good speed.
Due to the fact that Firebase is JSON based and not relational SQL type of database, the data structure model is a bit different and for sake of speed you will need to allow duplication of data.
I will create a `data node` just to fill search fields and that is mainly for performance issues.
The actual vehicles data will reside in a separate `data node` that can be looked up by the set of search fields presented. Under the `vehicle data node` I will create `sub-nodes` for each **Make** which will give me a performance advantage in searching for matched results.
---
### Author:  [@towball](https://community.thunkable.com/u/towball)
#### Post date: [September 19, 2021, 6:29am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/5 "2021-09-19T06:29:59Z")
Thanks Muneer be a great help to get my head around it…
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [September 19, 2021, 7:11am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/6 "2021-09-19T07:11:35Z")
If I would build such an app, I would start structuring my DB with the following
- Common App Settings
This is to manage info in the app in a dynamic way.
- Look up tables/lists
For performance issues, I will have the information for the user choices and options in a separate key for the app to retrieve faster.
- Actual vehicle info
This is the main `bucket` which will hold the major part of the info and is already separated by vehicle type again for performance purposes.
Of course this is only a start, as far as I understood of the case, and the more you get into the app itself you might need to add and go deeper in the node tree.
---
### Author:  [@towball](https://community.thunkable.com/u/towball)
#### Post date: [September 21, 2021, 7:19am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/7 "2021-09-21T07:19:59Z")
Hi Muneer
Looked at so many vids etc, still struggling a little. I can create the following but cant work out
- how to get another level or 2 ???
Like your image
Do you know of any Thunkable examples where I could view the blocks
??
Regards Barrie
---
### Author:  [@towball](https://community.thunkable.com/u/towball)
#### Post date: [September 21, 2021, 9:38am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/8 "2021-09-21T09:38:13Z")
Hi Muneer
I worked out how to create multiple nodes, found an article in thunkable community that helped me understand.
Long way to go as there is a lot more information I need to add. And then work out how to link the information
Regards
Baz
---
### Author:  [@towball](https://community.thunkable.com/u/towball)
#### Post date: [September 26, 2021, 9:21am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/9 "2021-09-26T09:21:12Z")
HI Muneer
I have spent hours reading threads on the community and having trouble getting my head around filtering data from FB. I am having trouble understanding the filtering and am in over my depth here…
I was going to have 5 lists to get the first 5 pieces of information.
Make, Model, Variant, Year, Fuel Type. Depending on what is selected then it will follow that NODE.
The length of the text between each set of brackets will vary so I cant see how I can use Letter to Letter for the substring
I have managed to have a list retrieving the first node when screen starts (Kia)
When I click on the list item I get everything after the first node but I only want (K2A)
Can you assist as to how I might achieve this???
Here is the setup in FBase
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [September 26, 2021, 9:37am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/10 "2021-09-26T09:37:58Z")
To make a working example, I’ll use the data available in my Firebase and then you can just do the same but apply it to your structure
My FB is this way
to get the data under the key `LookUps` in a `List Viewer`, I’ll do this
This is my output
This is the code blocks
Hope this makes it easier
---
### Author:  [@ruanyixincc5](https://community.thunkable.com/u/ruanyixincc5)
#### Post date: [January 7, 2022, 8:37am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/11 "2022-01-07T08:37:22Z")
hello, I am a new hand of thunkable and I got some thunkable problems , I can not upload my data to real time database?Here is my topic address:
> [@Realtime Database does not work](https://community.thunkable.com/t/realtime-database-does-not-work/1667456):
>
> I swear I have obeyed every step the thunkable docs told me to establish a personal real time database. I have got the API Key and Database URL and filled in the App Setting on Thunkable,but still I can not upload or get my data from real time database,how could that happen?Where the problem is? [QQ截图20220107160840] [QQ截图20220107161537] [image]
Could you help me to solve this problem？Thank you very much
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [January 7, 2022, 8:41am UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/12 "2022-01-07T08:41:06Z")
Please don’t post the same question multiple times. If someone has an answer, they will respond to your original topic.
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 1:15pm UTC](https://community.thunkable.com/t/firebase-lookup-a-b-c-d-with-thunkable-drop-downs-and-return-e-f-g-h-from-firebase/1512465/13 "2024-11-08T13:15:12Z")