Hello im stuck with this ? anybody has the fix ? trying to bring back up data from an other table with a search button
var SEARCH_COL_IDX = 0;
function Search(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var formS = ss.getSheetByName("Task");
var str = formS.getRange("C3").getValue();
var values = ss.getSheetByName("Data").getDataRange().getValues();
for (var i = 0; i < values.length; i++) {
var row = values[i];
if (row[SEARCH_COL_IDX]== str) {
formS.getRange("C6").setValues(row[0]);
formS.getRange("C8").setValues(row[1]);
formS.getRange("C10").setValues(row[2]);
formS.getRange("E6").setValues(row[3]);
formS.getRange("E8").setValues(row[4]);
formS.getRange("E10").setValues(row[5]);
}
}
}