I'm building this database for my husband's job. I need the search function to search the entire data sheet for whatever is put in the search bar not just the first column.
function Search() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var formSht = ss.getSheetByName("Input Form");
var recordsSht = ss.getSheetByName("Data Sheet");
var sValue = formSht.getRange("C5:E5").getValue();
var sData = recordsSht.getDataRange().getValues();
for (var i = 0; i < sData.length; i++) {
var row = sData[i];
if (row[0] == sValue) {
formSht.getRange("B9").setValue(row[0]);
formSht.getRange("B11").setValue(row[1]);
formSht.getRange("B13").setValue(row[2]);
formSht.getRange("B15").setValue(row[3]);
formSht.getRange("B17").setValue(row[4]);
formSht.getRange("B19").setValue(row[5]);
formSht.getRange("E9").setValue(row[6]);
formSht.getRange("E11").setValue(row[7]);
formSht.getRange("E13").setValue(row[8]);
formSht.getRange("E15").setValue(row[9]);
formSht.getRange("E17").setValue(row[10]);}
}
}
Here is the link to my sheet and what I have gotten so far.
https://docs.google.com/spreadsheets/d/1ClQp_mT3d6CEFRrKu43g5ya6CK3M4H9EpPPjAZ1EUg8/edit?usp=sharing