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.
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
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.
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.