Probably a simple solution to this (I've looked for answers but haven't come across any)....
DB 1 contains a Contact List with a column called Country. This Country field is populated from DB 2 called Country List.
I have a form called 'Add a Contact'. A dropdown allows a user to select a Country. (This should be populated from DB 2 - Country List). When a user submits the form, I'd like it to save to DB 1 - Contact List.
I've selected 'Connect dropdown list items' and connected it to DB 2 - Country List. Unfortunately, when I try connect to DB 1 - Contact List, the Country field is grayed out.
https://support.wix.com/en/article/working-with-the-connect-dropdown-panel - Here I see that two options are available - You can connect a dropdown to a dataset to capture user input and store it in a collection or to display data from a collection. Is there an option to allow both?