Showing a specific field base on user input in database collection

Ask the community
,
1

Hi guys,
I created a database collection and want to show specific value base on user choice(from two drop down.
Here is my code but it however cannot work.
Could someone spot the bugs here?
Many thanks!

export function dropdownto_change(event) {

 let dropdownfrom = $w('#dropdownfrom').value
 let dropdownto = $w('#dropdownto').value
    wixData.WixDataQuery("Fee") // <--- here your database-name
        .eq("title", dropdownfrom)
        .find()
        .then((results) => {
                $w('#inputfee').value = results.items[0].dropdownto;
                $w('#text58').text = results.items[0].dropdownto;
        });
}
2

Already tried using some console.logs?

export function dropdownto_change(event) {

 let dropdownfrom = $w('#dropdownfrom').value
 let dropdownto = $w('#dropdownto').value
    wixData.WixDataQuery("Fee") // <--- here your database-name
        .eq("title", dropdownfrom)
        .find()
        .then((results) => {
                $w('#inputfee').value = results.items[0].dropdownto;
                $w('#text58').text = results.items[0].dropdownto;
                
                console.log(results.items[0].dropdownto)
                console.log(results.items[0].dropdownto)
        });
}

What do you get, in the CONSOLE ? What is the result?

This here should be the first founded ITEM in a specific ROW and COLUMN of your DATABASE.

results.items[0]

If you are searching in the first COLUMN —> “title”, then…

results.items[0].title

If you are searching in another COLUMN(reference) then for example…

results.items[0].hereYourColumnIdOfYourSelectedDatabase

So one more time…
You are searching in DATABASE —> “Fee”, right ???

wixData.WixDataQuery("Fee")

You are searching in the “title”-COLUMN , right?

.eq("title", dropdownfrom)

And you use a DropDown-Value?
That means, that in the “title”-column the corresponding value of the choosen DropDown-value must be a value of the “title”-reference.

Sure that you want to search in the first column ?
Are your FEES located there? (title-column)?
What are the values of your DropDown ?

Check everything, if you have setted everything right!

This is surely not correct!

$w('#inputfee').value = results.items[0].dropdownto;

It will just work, if you have the column-IDs in your “dropdownto”-DropDown.