Using onSubmit() in Google Script for my Google Form per syntax shared here, I’ve successfully managed to instantly trigger a webhook in my Make scenario. However, while the webhook output bundle appears to hold all responses including the FileID of a file uploaded to the Google form, later modules in my scenario are not able to access that file ID from the array element representing that ID. The value is empty once it reaches further modules. Again, the FileID of the uploaded document is present in the output bundle at array[1], but the value of array[1] is empty when evaluated from the variable picker in other modules.
I’ve reviewed related topics here including this one, but even an iterator module is not getting the value of the array element from my Form upload field. Please help!
For this you might need to use an iterator to separate out the array. Then you should be able to map the id of each file to the google drive.
Thanks LinkYourTech. I’d previously tried this, but gave it another go this morning on your recommendation. Please see attachments. The FileID is not even getting picked up by the iterator despite its presence in the webhook output structure. Is there an issue with the custom webhook module?
I created a ticket w/ Make for this, and it turned out to be a data structure issue related to the file upload field in my Form. After removing all line breaks in the form field, refreshing the data structure in my webhook module in Make, then remapping the field to other modules, the issue was resolved. Thanks again to @LinkYourTech for sharing some thoughts and to the Make team for looking into this further.
2 Likes
