I'm all mixed up! :-( :'( HELP PLEASE!

Hello Nicholas,

Ah! GREAT! I knew there was something missing! I suppose you know how it is… You’re SO concentrated on what could be wrong that you DON’T see the obvious! :slight_smile:

Always good to get an outsider’s look :slight_smile:

Oooops… doesn’t seem to want to work.

If you want to try it :
https://merlinregis.wixsite.com/accueil

Since not ALL the brands and models are populated, you can try for something I know is in there :

Year (Année) : 2016
Brand (Marque) : Mini
Model (Modèle) : MiniCooper
Partname : Airbag

Do I need to make an export function for EACH dropmenu? Since I only have one created for now, I expect that the results should show ALL the 2016 makes and models and parts even if we chose brand, model and part.

And is the input box capable of searching word by word or does it look in each field for EVERYTHING that is typed in it ? If so, obviously, the year field would not return any results if it’s ALSO searched for Mini, MiniCooper, and airbag.

No errors in the console, but the results don’t STILL update in the table.

Does it make a difference to have or not “event, $w” ?

//Input search
import wixData from ‘wix-data’;
export function searchInput1_keyPress(event, $w) {
$w(“#Inventaire_Dataset”).setFilter(wixData.filter()
.contains(“veh_year”, $w(“#input1”).value)
.contains(“brand”, $w(“#input1”).value)
.contains(“model”, $w(“#input1”).value)
.contains(“partName”, $w(“#input1”).value)

); 

}

// ===========

//Dropbox search

export function searchDropdown1_change(event, $w) {
$w(“#Inventaire_Dataset”).setFilter(wixData.filter()
.contains(“veh_year”, $w(“#dropdown1”).value)
.contains(“brand”, $w(“#dropdown2”).value)
.contains(“model”, $w(“#dropdown3”).value)
.contains(“partName”, $w(“#dropdown4”).value)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
})
);
}

Lines 1 and 19 have that little yellow triangle saying “Parameter ‘event’ is never used.”

Thanks in advance :slight_smile: