While I’m pretty good at design I am a coding duh-head. The code I have I copied and modified is from this Wix help page.
I’ve attached a screenshot of my page so far as well as my code below that. The code I currently have allows people to search the Last Name (Surname) field. What do I add or alter to my existing code to allow them to search any of the other fields (First Name, Address, etc.)?
export function button1_click(event) {
// Runs a query on the “MasterDirectory” collection
wixData.query(‘MasterDirectory’)
// Query the collection for any items whose “Name” field contains
// the value the user entered in the input element
.contains(‘surname’, $w(‘#input1’).value)
.find() // Run the query
.then(res => {
// Set the table data to be the results of the query
$w(‘#table1’).rows = res.items;
});
$w.onReady( function () {
$w(“#table1”).columns = [{
“id”: “col1”,
“dataPath”: “surname”,
“label”: “Last Name”,
“width”: 110,
“visible”: true ,
“type”: “string”,
}, {
“id”: “col2”,
“dataPath”: “headOfHouse”,
“label”: “First Name”,
“width”: 110,
“visible”: true ,
“type”: “string”,
}, {
“id”: “col3”,
“dataPath”: “address”,
“label”: “Address”,
“width”: 170,
“visible”: true ,
“type”: “string”,
}, {
“id”: “col2”,
“dataPath”: “cityStateZip”,
“label”: “City, State, Zip”,
“width”: 170,
“visible”: true ,
“type”: “string”,
}, {
“id”: “col2”,
“dataPath”: “homePhone”,
“label”: “Home Phone”,
“width”: 100,
“visible”: true ,
“type”: “string”,
}];
});
}