Erik-74
New Member
Hi everyone, I could really need some help solving this...
In a very simple table I have two columns. In the first you'll find the city name, in the second you'll find the country the city belongs to. In a form the user can select a city via dropdown, which works fine. The dropdown retrieves its options from column one in the table.
Now I need the element "country" to auto fill, depending on the selected value in "city". E.g.: when user selects "Amsterdam", country will be "Netherlands". If user selects "Berlin", country is automatically changed into "Germany".
In my head it all sound easy. When the value in column A from row 34 is selected, then the value from column B in the same row should be presented. Can't seem to find the right function or plugin though. Any help would be greatly appreciated.
In a very simple table I have two columns. In the first you'll find the city name, in the second you'll find the country the city belongs to. In a form the user can select a city via dropdown, which works fine. The dropdown retrieves its options from column one in the table.
Now I need the element "country" to auto fill, depending on the selected value in "city". E.g.: when user selects "Amsterdam", country will be "Netherlands". If user selects "Berlin", country is automatically changed into "Germany".
In my head it all sound easy. When the value in column A from row 34 is selected, then the value from column B in the same row should be presented. Can't seem to find the right function or plugin though. Any help would be greatly appreciated.