Advertisement
Guest User

Untitled

a guest
Apr 21st, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*
  2.     Add this script to a form.
  3.     Go to Edit > Current Project Triggers
  4.     Add the addOption function to the On Submit trigger
  5.     Fill the form once.
  6.     Go to View > Logs
  7.     Change the id 00000000 for the one that was logged.
  8. */
  9. function addOption(e) {
  10.   try {
  11.     var form = FormApp.getActiveForm();
  12.     var formResponse = e.response;
  13.     var itemResponses = formResponse.getItemResponses();
  14.    
  15.     for (var j = 0; j < itemResponses.length; j++) {
  16.       var itemResponse = itemResponses[j];
  17.       var id = itemResponse.getItem().getId();
  18.       Logger.log('id ' + itemResponse.getItem().getId()); // 00000000
  19.      
  20.       if ( id == 00000000) { // Replace with your own id after logging it first
  21.         var item = form.getItemById(id).asMultipleChoiceItem();
  22.         var choices = item.getChoices();
  23.         var add = true;
  24.         var answer = itemResponse.getResponse();
  25.  
  26.         for (var k = 0; k < choices.length; k++) {
  27.           if (answer == choices[k].getValue()) {
  28.             add = false;
  29.           }
  30.           Logger.log(itemResponse.getResponse() + ', ' + choices[k].getValue());
  31.         }
  32.         if (add) {
  33.           choices.push( item.createChoice(itemResponse.getResponse()) );
  34.           item.setChoices(choices);
  35.         }
  36.       }
  37.     }
  38.   } catch (err) { Logger.log(err); }
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement