I want Firebase to store 10 fields of data in a row or similar and there could be 1000 or more rows
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