# Explain to me please! **URL:** \ **Category:** Ask for Help\ **Created:** [June 3, 2020, 7:39pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248 "2020-06-03T19:39:27Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\ **Post date:** [June 3, 2020, 7:39pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/1 "2020-06-03T19:39:27Z")
Hello everyone! This is not the first time I ask, I did not hear a distinct answer. I have an addition of activities in the application, the user has a “add activity” button in his personal account, when you click on it, a form from the activity sheet opens, you need to have two drop-down lists in the form, “Cities”, and “Countries”, when choosing a country in the first list, in the second we select the city and then fill in the remaining fields and click send. How to make these two dropdowns lists??? And it is at the top level !!! ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [June 3, 2020, 10:38pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/2 "2020-06-03T22:38:57Z")
You should create a tab in your gsheet with the country or city options. Then, in the form, add a choice component. The origin of data for that choice component will be the newly created tab. And the destination of said data will be in a column in your forms sheet. Does that make sense? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 3, 2020, 10:50pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/3 "2020-06-03T22:50:44Z")
Unless he was trying to make a dependent choice: based on the country? For example only show French cities when selecting France. Is this possible? Would it be a choice component that’s displaying a relation? I haven’t attempted this. @Jeff_Hager to the rescue? ---
**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\ **Post date:** [June 3, 2020, 10:51pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/4 "2020-06-03T22:51:41Z")
I did that. But I need exactly dependent lists. That is, in the first you choose a country, and in the second a city of this country. ---
**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\ **Post date:** [June 3, 2020, 10:53pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/5 "2020-06-03T22:53:55Z")
Yes exactly! To choose the city depended on the country! and most importantly, these lists should be immediately in the form of adding, and not the first step! ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [June 3, 2020, 11:16pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/6 "2020-06-03T23:16:19Z")
Oh… I’ve tried for a couple of minutes, but didn’t achieve it. Don’t you have this dependent drop down menus in your car templates @Robert_Petitto ? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 3, 2020, 11:26pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/7 "2020-06-03T23:26:22Z")
Nope…it’s an inline list that leads to a form button. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [June 3, 2020, 11:29pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/8 "2020-06-03T23:29:00Z")
hmmm. I’m sure @Jeff_Hager has already figured it out somehow. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2020, 11:38pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/9 "2020-06-03T23:38:48Z")
I advised him the same the other day. Basically a user-specific choice for the country, a relation to return the cities, then a form that captures the country and city chosen via columns component. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 3, 2020, 11:59pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/10 "2020-06-03T23:59:46Z")
I’m too mentally fried right now to try it, but is it safe to assume that the new column to column compare on a filter will not work to compare choice sheet columns to form column values? Based on this post: > [@Wrong data context for new dynamic (3 dot) Choice filters in Forms](https://community.glideapps.com/t/wrong-data-context-for-new-dynamic-3-dot-choice-filters-in-forms/9979): > > The new dynamic options for the right side of filter conditions is awesome, however it is pulling in the wrong data context for Choice/List components in Forms. I can only compare a value for the current list item against a value in that same item, which is not really helpful at all. That could be done with a simple If/Then/Else in the data editor. Instead, the right side filter options should be pulling from the Form’s data context which enables things that were difficult or impossible to do pr… If that was possible, then it could be done in the form. Otherwise, like @ThinhDinh said, I think we are stuck making the choices outside of the form using user specific columns and a relation. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 4, 2020, 12:24am UTC](https://community.glideapps.com/t/explain-to-me-please/10248/11 "2020-06-04T00:24:47Z")
> [@Jeff\_Hager](#): > > I’m too mentally fried right now to try it Rest up king, let me try your suggestion later to see if it works and if there’s a workaround for that. Actually I implemented the method I mentioned via a TeamViewer session for him the other day but seems like he still wants it to be in the form. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 4, 2020, 12:42am UTC](https://community.glideapps.com/t/explain-to-me-please/10248/12 "2020-06-04T00:42:09Z")
Just thinking out loud though…there’s no way to do this within the form, correct, since nothing gets written to the sheet until the form is submitted? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 4, 2020, 12:45am UTC](https://community.glideapps.com/t/explain-to-me-please/10248/13 "2020-06-04T00:45:08Z")
Yes that’s correct, as far as I’m aware. That’s why we have tried to implement a 2-step input until now, putting all the things that need relations in the 1st one. I try to make the UX as nice as possible by showing a basic table when they go to the 2nd step (via the form button), then ask them to check the details and then submit the final order. ---
**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\ **Post date:** [June 4, 2020, 5:49am UTC](https://community.glideapps.com/t/explain-to-me-please/10248/14 "2020-06-04T05:49:24Z")
I am not against two steps, the first is the choice of a country with a city, and the second is the rest of the form. But then after the form is submitted, the redirect goes again to the choice of the country and city, and this is not logical. @Jeff_Hager @eltintero ---
**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\ **Post date:** [June 4, 2020, 8:48am UTC](https://community.glideapps.com/t/explain-to-me-please/10248/15 "2020-06-04T08:48:03Z")
Yes, I want it to be in the form, or two steps, but after sending it redirected to another page, and not to select the country again. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 6, 2020, 5:44pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/16 "2020-06-06T17:44:59Z")
Right now a form will only redirect back to the page that had the form button. ---
**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\ **Post date:** [June 6, 2020, 5:56pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/17 "2020-06-06T17:56:39Z")
Hey. Can you tell me. How to make two dependent lists if there is already data in the table ?! Example: there is “Country” - Vietnam in the table and “City” - Ho Chi Minh City. You need one drop-down list with the City and the second should show the city of Ho Chi Minh City. etc. I repeat, they are already in the table. They just need to be pulled into shape. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 6, 2020, 6:06pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/18 "2020-06-06T18:06:22Z")
Take a look at the Dynamic List Filter example in [https://concepts.glideapp.io/](https://concepts.glideapp.io/). ---
**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\ **Post date:** [June 6, 2020, 6:18pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/19 "2020-06-06T18:18:55Z")
I already watched it. There are more fields. I have only two fields and they are already written to the table. I need to pull them into two dependent lists. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 6, 2020, 6:33pm UTC](https://community.glideapps.com/t/explain-to-me-please/10248/20 "2020-06-06T18:33:52Z")
Yeah, I have some extra steps in there, but the concept is the same. Your first county selection from the country choice component would write the value to a column in the sheet, then you use that value to create a relation to the cities sheet. You would then use the relation for the second choice component of city. That’s it. [Next page](https://community.glideapps.com/t/explain-to-me-please/10248.md?page=2)