IssueTracker

Hello, thank you for your replay.

I search for a little more in this case, making others tests and I found the problem.

This is really a Bug, because I can make this process run if I fill the the Array with all columns value defined, like ["Column 01","Column 02", "Column 03"]

But it's not possible to send a Response for a GridItem with a empty values (null values) for rows that do not have values defined, even if the property SetRequired of the GridItem is set to false .

In that case is not mandatory to have one value set for each row, but the function createResponse still trow a error (when values like [null, null "Column 02",null] is provide to that function).

I send bellow a code in order to show the bug:

var formTeste = FormApp.openById("1nSGjp0JvFI4n0UAVu7it7JJ4nA2viup3Z0HAmQrRU6I");
  const skipTypes = [ FormApp.ItemType.SECTION_HEADER, FormApp.ItemType.PAGE_BREAK ];
  var items = formTeste.getItems();
  for (var i = 0, retItems = []; i < items.length; i++) {
    var item = items[i], type = item.getType();
    if (skipTypes.includes(type) > 0) {
      continue;
    }
    switch (type) {
      case FormApp.ItemType.TEXT: item = item.asTextItem(); break;
      case FormApp.ItemType.GRID: item = item.asGridItem(); break
      default:
        Logger.log("Warning: Question '" + item.getTitle() + "' has unsupported type " + type + ". It will be skipped.");
        item = null;
        break;
    }
    retItems.push(item);
  }
  var itemsForm = retItems;
  var membersImport = [["Pergunta Teste","Produto Teste"],
                       ["Resposta Teste",["Nenhum","02 Itens","Nenhum","04 Itens","Nenhum"]]];
  for (var row = 1; row < membersImport.length; row++) {
    try {
      var responseForm = formTeste.createResponse();
      for (var i = 0; i < itemsForm.length; i++) {
        var resp = membersImport[row][i];
        var item = itemsForm[i];
        if (resp == "" || item === null)
          continue;
        var type = item.getType();
        try {
          Logger.log("item: " + item.getTitle() + " || " + type.toString() + " || " + resp);
        } catch (exc) {
          Logger.log("Erro: "+exc+" || item: " + membersImport[row][i] + " || " + type + " || " +
                     resp + " || row: " + (row+1).toString() + " || column: " + (i+1).toString());
          throw exc;
        }
        if (item) {
          var respItem = item.createResponse(resp);
          responseForm.withItemResponse(respItem)  
        }
      }
      responseForm = responseForm.submit();
    } catch (exc) {
      Logger.log("Error: import the response: " + (row+1).toString()+" - "+exc);
      throw exc;
    }
  }

I create a sigle form with two fields (one TEXT and one GRIDITEM), the GridItem have SetRequired set to no, so if I leave one row with value null should be run with no problem, but its not what happened !!!

Please, run this code and you see that works, but if you try to change the follow line to null values, you will see the error:

  var membersImport = [["Pergunta Teste","Produto Teste"],
                       ["Resposta Teste",[null,"02 Itens",null,"04 Itens",null]]];


In the documentation of this function will can se the description saying the is allowed to set null values if the row does not have any response assigned:

createResponse(responses)

Creates a new ItemResponse <https://developers.google.com/apps-script/reference/forms/item-response> for this grid item. The argument responses must be a String[] array containing as many values as the number of rows in the grid. A null element for a non-required grid question indicates no response to that row. Throws an exception if any of the values does not match a valid choice.


I wait for your reply again and hope you can understand and make the correction in the function in order to solve this bug.

Thank you again for your help and support !!!

Best Regards,

Mr. Marcelo Facioli.

Hello,

Thank you for you reply.

As you asked I attached three images from the Test Form.

The first imagem show the edit template of the form, with two fields available (one Simple text and other GridItem).

The second imagem show a response enter manually, leaving some rows with no answer (as the Grid allows), this operation it's not possible to do with Script, using the method createResponse() because return a error with message of a invalid response submitted to grid question.

The third imagem show the form full filled with method createResponse() and call after a submit(), this works, but as I told, you have to provide one value to every rows, so no NULL values in array should be present (as the GridItem and Form allows) in order to work.

Waiting for your replay.

Best regards,

Hi,

Sorry for delay in reply your message.

I attach again the three images from the Issue Tracker and I think it's ok now.

Waiting for any news.

Best regards.

Has there been any developments with this?  I'm having the same issue.