Google App Maker Dynamic Dropdowns

Learn how to build dropdowns from the data you have in other datasources to give your apps the dynamic elements they need to be awesome.

[HPDStudios]

You know the initial problem was how to make the customizing the drop down list less confusing. However, if you already understand datasources then it's likely that this task would not be confusing. Hence, I think as a teacher on the subject you missed the point.... Its confusing because it is not clearly explained how datasources are "modeled" or how they are to be utilized. There is a conceptual disconnect in the task.


Consider the code segment:
= widget.text;


it is unclear how you can run a query, get a result and then assign it a value of the widget.text that initially doesn't even have any values set. It's kinda an order of operations question, that is really really confusing. Maybe slow down, less bells and whistles and focus on explaining this model and building blocks of the datasources object.

[abdullahquhtani]

Do you know where I can find a good freelancer who can help me.build my own customized app or do that totally for me?

[TheAmazeer]

Too much confusing, you don't explain us how to simply create a dropdown

[jmacdono]

There has to be a way to clear the Cities dropdown after the country is changed in the Country dropdown, right?

[HPDStudios]

Yea, right off the start, the menu options are not the same for the AppMaker that I'm using as a part of GSuite. Is there an updated video?

[jessemacdonough]

There are a few tweaks that you need to make to the Cities / Countries table to get the Country name to display instead of the ID, since you make these tables using the Google Cloud SQL database.
That would be in the options for the Country Name (on the Relations table) use