CODEWITHSUNDEEP
google-apps-scripttriggers
Stef
Stef

Reputation: 1

Google App Script onFromSubmit Trigger doesn't trigger

I have a spreedsheet, with a sheet feed by a Google Form. unfortunetly, I need special features, like conditional formatting, and data added by google form are added in a new line without format.

So, I did an other sheet, with the same columns, and I had to copy paste from the first one to the second one. I'd like this copy to be automated. So I tried to do it using Google App Script. But it seems like I did something wrong with the trigger.

Here is the code :

function creerTrigger()
{
  ScriptApp.newTrigger('deplacerCommande').forSpreadsheet("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx").onFormSubmit().create();
}

function deplacerCommande(e)
{
  var id = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
  var feuille = SpreadsheetApp.openById(id).getSheetByName("Commande");
  feuille.appendRow(e.namedValues);
}

When I run deplacerCommande() from Google App Script, the messageBox is displayed, but not when a form is submitted, so I don't think the trigger works.

Yes, I created my trigger. I did it by running the function creerTrigger() from Google App Script. I also tried deleting it, then changing the version, then recreating it, because I read it can solve the problem, but it didn't.

list of trigger

It's in French, but I'll translate the value for you : deplacerCommande is the name of the function called by the trigger. the second value means From the spreedsheet. the third means sending Form

Upvotes: 0

Views: 150

Answers (1)

Stef
Stef

Reputation: 1

The solution was simple. The trigger triggered, but the appendRow function raised an Exception because namedValue is an object, not an arrow. using e.values instead of e.namedvalues solved the problem!

Upvotes: 0

Related Questions