Stack Overflow Asked by aWeakProgrammer on January 5, 2022
I am using appendRow() to insert values in Google Sheet, and even if some fields are empty, it adds the values to the next line if any cell contains content.
Example: Cell C1 has a Sum formula, =SUM(A1,B1) When I insert a row with appendRow(), the values are added to A2 and B2 instead of A1 and B1, due to the content of C1.
Is there any way to solve this?
function showUserForm() {
var template = HtmlService.createTemplateFromFile("userForm");
var html = template.evaluate();
html.setTitle("Form");
SpreadsheetApp.getUi().showSidebar(html);
}
function appendData(data){
var ws= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Records");
ws.appendRow([data.depo,data.phone,data.game]);
}
function errorMsg(){
Browser.msgBox("Name & Phone Required");
}
Try this:
function appendData(data){
var sh=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Records");
var rg=sh.getRange(sh.getLastRow(),1);
rg.setValue(data.depo);//column A
rg.offset(0,1).setValue(data.phone);//column B
rg.offset(0,3).setValue(data.game);//column D
}
or
function appendData(data){
var sh=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Records");
var rg=sh.getRange(sh.getLastRow(),1,1,4);
var vA=rg.getValues();
vA[0][0]=data.depo;
vA[0][1]=data.phone;
vA[0][3]=data.game;
rg.setValues(vA);
}
Answered by Cooper on January 5, 2022
2 Asked on December 4, 2021 by lucas-vitor
1 Asked on December 3, 2021 by jake-rankin
3 Asked on December 3, 2021 by hellofanengineer
4 Asked on December 3, 2021 by maimok
2 Asked on December 3, 2021 by sak
1 Asked on December 3, 2021 by chessguy
1 Asked on December 3, 2021 by carrey
0 Asked on December 3, 2021 by rickyk95
3 Asked on December 3, 2021 by aysh
0 Asked on December 3, 2021 by ntakouris
apache beam google cloud dataflow google cloud sql tensorflow tfx
2 Asked on December 3, 2021
1 Asked on December 3, 2021 by kok-how-teh
1 Asked on December 3, 2021 by question3r
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP