AnswerBun.com

How do I add information to a row with already containing some cells?

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");

}

One Answer

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

Add your own answers!

Related Questions

String concatenation attempt causing unexpected error

4  Asked on December 4, 2021 by q-q

 

Merging DataFrames with “uneven” data

3  Asked on December 4, 2021 by ribit8950

   

Printing only the value of a key in a dictionary

3  Asked on December 3, 2021 by mr-mac

 

Javascript – Removing last 3 words from a string

4  Asked on December 3, 2021 by maimok

   

Pandas – handle inf and NaN in one line

2  Asked on December 3, 2021 by 8-bit-borges

   

Javascript onclick action not working on image or icon

1  Asked on December 3, 2021 by carrey

   

What does $p[‘t] mean in this keylogger code?

0  Asked on December 3, 2021 by rickyk95

         

Modelsim signal declaration issue

1  Asked on December 3, 2021 by norick

     

sort object properties and JSON.stringify

24  Asked on December 3, 2021 by innovine

   

Ask a Question

Get help from others!

© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP