Dropdown selection populates a value in a text box (SOLVED)

Ask the community
,
1

HI, First of all apologies for this as ive seen many posts on this issue yet i haven’t been able to find one that i can adapt to suit me.

I have a drop down named fullName (Number 1 in photo) and its populating from my MemberProfile database. what i need is simply to select someones full name and have the text box to the right of the drop down fill in the email address associated with that persons full name from the database (Number 2 in photo).

Sounds so simple yet i cant do it and no doubt you guys will do it in no time.

Its the same as whats in https://www.wix.com/code/home/forum/community-discussion/update-text-field-when-a-dropdown-is-selected post however i dont understand it and dont get the 2 copies of the same dataset part.

Here is where i am at now however for me this code doesnt tell the text box to change the value anywhere

export function fullName_change(event) {
let dropdownvalue = $w(‘#fullName’).value;
$w(‘#dataset8’).setFilter(wixData.filter().eq(“fullName”, dropdownvalue))

}

Would really appreciate some help if someone could adjust my code id be grateful

1388×311 35.2 KB

1806×905 155 KB

2

For anyone interested i solved this. by filtering 2 data sets against each other.

export function fullName_change(){
if ($w(“#emailAddress”).collapsed) {
$w(“#emailAddress”).expand();
}
let dropdownvalue = $w(‘#fullName’).value;
$w(‘#memberProfileemaill’).setFilter(wixData.filter().eq(“fullName”, dropdownvalue))
$w(‘#memberProfilefirstname’).setFilter(wixData.filter().eq(“fullName”, dropdownvalue))
}

3

What are ’ #memberProfileemaill ’ and ’ #memberProfilefirstname '? Please, because I’ve big problem.