enter image description here
Need Apps script codes to save information from scoresheet to agent’s spreadsheet.
I’m having difficulties on setting up the codes and needs help to finalize my project proposal on our office.
I appreciate to all the answers I may get.
<code>function saveData() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheets()[0];
const url = sheet.getRange('Scoresheet').getValue();
const follower_count = sheet.getRange('Sheet1!B1').getValue();
const date = sheet.getRange('Agents').getValue();
sheet.appendRow([url, follower_count, date]);
} //code added by Cooper from the comments
</code>
<code>function saveData() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheets()[0];
const url = sheet.getRange('Scoresheet').getValue();
const follower_count = sheet.getRange('Sheet1!B1').getValue();
const date = sheet.getRange('Agents').getValue();
sheet.appendRow([url, follower_count, date]);
} //code added by Cooper from the comments
</code>
function saveData() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheets()[0];
const url = sheet.getRange('Scoresheet').getValue();
const follower_count = sheet.getRange('Sheet1!B1').getValue();
const date = sheet.getRange('Agents').getValue();
sheet.appendRow([url, follower_count, date]);
} //code added by Cooper from the comments
New contributor
Reynaldo Gravador is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
8