I’m looking to enter a .csv into my database that has the Years, Makes, and Models for all vehicles produced from 1984-2022. There are multiple makes per year, and multiple models per make. The .csv is three columns and nearly 45k rows.
I’m an Adalo newbie (but loving it so far!) and I’m stumped with how to properly enter this. Should I have three collections (Year, Make, Model), or one collection with three properties?
My goal with this is to create a form dropdown where users can effectively select the year, make, and model of their vehicle. I’d like for the make to be contingent on the year they select, and the model to be contingent on both the year and make they select.
Thanks in advance!
PS: Screenshot of the top of my data stack attached
With the large amount of data, would it then be necessary to manually associate all of the 1984 Makes with that year, and then the specific models to their respective makes? Or is there a way to automatically associate those?
It depends on how you want to structure the addition: in the addition forms it is possible to automatically add fields, but these will always be the same (if you always have to add 1984 as a year, it is possible to do so, but if you then have to add a 1985, this automatism will not that is fine).
if these three fields vary and are not always the same, you are advised to add them each time by hand, paradoxically it would take less time
In this case, there are 40 years, 141 makes, and 4627 models. I definitely don’t want to be adding them manually. But I’m hoping to upload all of the data so that the user can pre-select from a fixed list.
As an example,
Field 1: The Year field would dropdown to display all years 1984-2022. The user would select the Year of their vehicle (1995).
Field 2: The Make field would then filter to only dropdown Makes specific to the Year 1995. The user would then select their Make (Jeep).
Field 3: The Model field would then filter to only dropdown Models specific to the 1995 Jeep. The user would then select their Model (Wrangler 4WD).
Given that my 4627 Models would have to be manually associated with 141 different makes, and then across 40 different years, is there a way to automate the import of my .csv into the database so that I can provide the example experience to my users as listed above?
I believe the best way of doing this is creating separate collections for year, make and model.
But in every collection create three properties for year,make and model. And when importing the CSV to the three collections select the respective property to the column and import it!
And also in the year collection drag the year property to 1st place , in the makes collection drag the make property to 1st place and in the models collection drag the model property to 1st place!
I suggested to add all three columns for all three collections because then you can filter the drop downs from any property. Like there is a drop down for make and also a drop down for year. And you need to filter the year drop down according to the selected make ! Then you can add a filter to the year drop down as make ( make property in the year collection) > is equal to > Other drop down’s > make ( year drop down name ) > make!
The other way is creating One to many relationship with each collection and add them. But that will take your time because I see that there are lot of records!
If you need more help you can send this CSV in DM and I’ll make a clonable app!