Dependent Dropdown for car's make & Model

[Akhil.N]

Hi,

So I am new here and just learning my way around the Bubble.

So I am looking to create a dependent drop-down list with car’s make & model.

Dropdown1 (make): “Audi, BMW, etc”
Drop-down2 (models): “A3, A4, etc.” (if Audi was selected in dropdown1)

I really appreciate any help the members can provide.

[adamhholmes]

You can either have a list of Models on the Make datatype…

Or just have a parent Make on the Model datatype

Or both.

[Akhil.N]

Ok. Thanks, @adamhholmes! I’ll try that.

Would you recommend creating an option-sets for this type of requirement?

[adamhholmes]

Possibly…

but it depends on how many options you’ll have, and how often they are likely to change/be added to…

If it’s many, and/or they are likely to change often, I would use a custom datatype.

As it’s cars, and new models come and go (and there a many makes and models of cars) I’d probably stick with a custom datatype for this… it will be much easier to work with and manage.

[karamwise]

Hey @Akhil.N ,

You need to create category mapping in the bubble. In this, you have to make 3 databases.

1. Car Company Database
2. Car Model Database
3. Car company and car model combined database.

Here is the screenshot for the car database:

Screenshot for the car model database:

Screenshot for the Mapping Database (Refer to category and Sub-category only):

Create a workflow for creating data for entering data in the car company and car model input element which will populate both databases.

The click of submit button starts the workflow.

Create a condition so the same company or car model cannot be entered again.

Creating Data in the database.

Repeat the above steps with the car model.
Once both databases are populated create a workflow for the mapping.

Take two drop-down fields and provide the database to the car company to one dropdown element and the car model to another dropdown element.

On click of submit save data to the mapping database.

Now take two dropdowns again where you want to have the select option.

Search for the car company from the car company database as I have searched for the department.

Now in the car model dropdown select the mapping database and add constraint as shown in the screenshot instead of the department you need to select the car company drop-down element which you created earlier and instead of the product type, you need to select the car model.

If any further assistance is required get in touch with me on:
LinkedIn:- Karamjit Singh - Aprintaa - Rank First To Earn Fast! | LinkedIn
Gmail:- karamwise@gmail.com

[Akhil.N]

Thanks @karamwise!

Thanks for taking the time for the detailed explanation. I shall definitely try this method.