CONCATENATE / JOIN SHEET'S DATA FIELDS = APPS SCRIPT / JAVASCRIPT

Опубликовано: 30 Март 2026
на канале: Mohdar Ismail

1,404

Google sheet Tips Basic and Advance CONCATENATE / JOIN SHEET'S DATA FIELDS = APPS SCRIPT / JAVASCRIPT

Code below;

//====================
function concate() {

let ss = SpreadsheetApp.getActiveSpreadsheet();

let ws1 = ss.getSheetByName("Sheet1");

let dataRange = ws1.getRange(2, 1, ws1.getLastRow()-1, 4);

let dataValues = dataRange.getValues()

let dataArr = dataValues.map(rowData);

function rowData(rows){return [

"Hii, " + rows[1] + " Your ID is '" +
rows[0] + "' and your email is " +
rows[2] + " and you've been appointed as " +
rows[3] +"."

]
}

let concat = ws1.getRange(2, 5, ws1.getLastRow()-1, 1).setValues(dataArr);
}
//================================

In the next video
(1) Spread sheet function How to - ONLY output when all column rows are filled
(2) Trigger to Auto to - ONLY output when all column rows are filled