I have been trying to use Camera Tool to take a picture, then upload directly to Google Form. But how do I do this?
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.
The reason why I need to have the 5 textboxes + 1 spinner + 1 upload image in one same google form is so that my app can display all 6 information together with the respective image, as shown below:
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:
