0

Code.gs

function logHIST(){

//already got sheet assigned.....
var taskITEMS = userORDER.getRange(2,3).getValue();
var entry = [today,username,"",taskITEMS,"","","",periodLABEL,userBASKET];
history.getRange(lastRow+1,1,1,9).setValues([entry]);
}

So I get the items alright, but it only write the first item in the set. it writes the other entries, such as the name dates and all; but the TaskITEMS only put the first. [[a][b][c]]

The log shows that it has the set though.

basically I need store [[a][b][c]]==>A4 Hope this makes sense. Thanks.

TheMaster
  • 45,448
  • 6
  • 62
  • 85
wrtstv
  • 1
  • 2
  • Using relevant tags ensure your question reaches the proper audience. Your question never reached the intended audience as you missed [google-apps-script] tag. – TheMaster Oct 23 '22 at 21:16
  • https://stackoverflow.com/questions/63720612/what-does-the-range-method-getvalues-return-and-setvalues-accept – TheMaster Oct 23 '22 at 21:17

0 Answers0