const insertReport = (e) => {
if(e.namedValues['key']) {
const key = e.namedValues['key'];
const information = e.namedValues['information'];
const Sheet = SpreadsheetApp.opennById('ID).getSheetByName('SHEET_NAME');
const data_range = Sheet.getRange(1,1).getDataRegion().getValues();
const criteria_column = data_range.map((data) => data[0]);
// ここでkeyをtoString()にするのがポイントです。これがないとindexOfが検索値として認知してくれません
const is_match_row =
criteria_column.indexOf(key.toString()) + 1;
// SET_COLUMNには、値をセットしたい列の番号をセットします
Sheet.getRange(is_match_row, SET_COLUMN).estValue(information);
}
}
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme