If you guys see my first picture, those are the items that users need to fill in, which will then be uploaded onto the google form. This includes taking picture and uploading onto the same google form.
However, when I click submit button on my app, the google spreadsheet (2nd picture) captures everything but not the google drive URL of the image I captured. Nonetheless, the image captured is in my Google Drive.
However, if I include the option to upload image (as optional), even when I fill in the 5 textboxes + 1 spinner, my google spreadsheet stops capturing any single responses despite the option to upload image is set as optional.
Furthermore, 5 textboxes + 1 spinner + 1 upload image, I would expect to have 7 "entry.xxxxxxxxx=". But when I try to obtain the link, it only gives me 6 of the "entry.xxxxxxxxx=". The entry.xxxxxxxxx for image upload is missing.
Can I ask, which Script Editor should I put this in?:
function doPost(e) {
var data = Utilities.base64Decode(e.parameters.data);
var blob = Utilities.newBlob(data, e.parameters.mimetype, e.parameters.filename);
var FileID = DriveApp.getFolderById('0B5wEV4Pes_aefnpwQnptSTFnQURBbDVVTUFsbzMyNjZ3bktMaGItaGRPaWdvSHhDeEwxOXM').createFile(blob).getId();
return ContentService.createTextOutput(FileID);
}
I tried putting in both Google Sheets --> Tools --> Script Editor and also Google Sheets --> Form --> Edit Form --> More --> Script Editor, but both don't seem to work. I get the response:
