Using WebService - getting correct code from GoogleSheets

Question

Hello All,I’m trying to use codes taken in from GoogleSheets through WebService in my survey (as form a one-time reward for participants). I have a working script pasted in Google’s AppsScript (after each time I go through a preview or another form of doing the survey, I see in my GoogleSheets that a code has been used - it’s getting marked as used; I’ve pasted the script’s code at the very end of this message).My Survey Flow looks like this (link is correct ;) and the length is as it is now, it’s testing first :))...And I believe that piping in form is also fine: However, I don’t see the code - just the text (even though the script works). I set the app as public with access to everyone and I’ve set the sheet as public (same; the app works in incognito and the test Web Service in Qualtrics’ Survey Flow connects with the app, marking new codes as used).Still - there’s no code visible in either preview or actual link :( Could anyone help me out and either point out what I’m doing wrong (and what I should do differently ;))?  Thanks a lot! Kind regards,M.    function doGet() {  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Codes");  var data = sheet.getDataRange().getValues();   for (var i = 1; i < data.length; i++) {    if (data[i][1] === false) {      sheet.getRange(i + 1, 2).setValue(true); // Mark as used      return ContentService.createTextOutput(data[i][0]);setMimeType(ContentService.MimeType.TEXT);    }  }   return ContentService.createTextOutput("NO_CODES_LEFT");}

vgayraud · Answer

Hi,Don’t know if there are other issues, but with a quick look you seem to have improper chaining in this ( ; instead of .)return ContentService.createTextOutput(data[i][0]);setMimeType(ContentService.MimeType.TEXT);return ContentService.createTextOutput(data[i][0]).setMimeType(ContentService.MimeType.TEXT);

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded