title: Multiple fields to a single row
body: <p>Going to start with, I am extremely new to this. We are using a google sheet as different forms of sorts where we want to capture data in a single source. I am trying to avoid having to individually map each cell. below is the start of the 100 fields i'll have to capture. I am getting the error that my data of 3 doesn't match my columns of 10. Is there way to lay out different ranges and get them to all push to one row?</p>
  <pre><code> //Input Values
      function SubmitData() {
    var ss        = SpreadsheetApp.getActiveSpreadsheet();
    var formS    = ss.getActiveSheet(); 
    var datasheet = ss.getSheetByName(&quot;Data&quot;);
         
    var values = [[formS.getRange(&quot;B1:B4&quot;).getValues(),
                   formS.getRange(&quot;D2:D4&quot;).getValues(),
                   formS.getRange(&quot;F2&quot;).getValue()]];
    
    datasheet.getRange(datasheet.getLastRow()+1, 1, 1,10).setValues(values)
  </code></pre>