Show two values from dataset in dropdown

Ask the community
,
1

Hey guys got this piece of code


$w('#ddFrame').onChange((event)=>{ 
	let options = [ ]
	console.log($w('#ddFrame').value)

 wixData.query("Students").contains("frame", $w('#ddFrame').value)
      .distinct("firstName",)
    .then((results) => {
		options =results.items.map(item => {
            return {
                label: item,
                value: item
				}
        })

		$w('#ddStudents').options = options
        console.log(results)
		console.log(options)
	})
	
	$w('#ddStudents').enable()
	})//onChange

i’m trying to make drop down #ddStudents show their first and last name. in this state i got only the first name. tried many things, i guess it’s pretty simple but i newb in query

2

Could you show us your database collection so we can get an idea of what fields you have?