I have a database with some columns that describe information about the product and long list of product variety. I to manage dataset in a way so visitors input product name (#iMPN) on one search line, or description (#iDescription) in another and it open up information on that product they are looking for. WIX support told me that I need a custom code for this function and it will be good to ask you here. I am a very beginner and don’t have an experience with custom codes.
here is my code, but I have an issue with that:
Here is the code one more time:
export function iMPN_keyPress(event) {
// Runs a query on the “TablePlan” collection
wixData.query(‘PartSearch’)
.find() // Query the collection for any items whose “MPN” field contains
// the value the user entered in the input element
.contains(“MPN”, $w(“#iMPN”).value)
.find() // Run the query
.then(res => {// Set the table data to be the results of the query
$w(“#table1”).rows = res.items;})
}
Please advice what I have to change?
thank you in advance!!!