Hello! Thanks for the guide, this worked for me. I was hoping to see how you can post the image to sheets on form submit button. It uploads every photo that you choose to the drive, but I would like it so that it uploads when the form submits. Also how can you have the image be loaded into a certain column and have it be in the same row as other form inputs of the same form? Thanks!
Instead of using a change listener, you can execute the code inside the form submit event listener, like this: form.addEventListener('submit', e => { e.preventDefault(); // Image submission code here }); To load the image into a different column, you can define a variable to select the specific column or row range, and then use the `range.setValue(imageLink)` method to set the image link in that cell: const imageUrl = "example.com/image.jpg"; // Replace this with the actual image URL const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const imageCell = sheet.getRange("A1"); // Replace "A1" with the desired cell reference imageCell.setValue(imageUrl); This code will set the image URL (stored in the `imageUrl` variable) into the cell defined by `imageCell`, which you can adjust as per your specific requirements.
how to store pdf in case of image?
In mine first error appear cors policy origin so I add header and mode to no-cors after this error now error comes 403 forbidden , what I do now,?
I have the same error :(
Spectacular, that's the word for it. This is simply SPECTACULAR.
u are the best. Thank you very much
this is fantastic sir
make a video how use this image for different projects
my image doesnt appear in google sheets but it tells me that the process was done correctly, I don't know what it could be
Deploy your appscript clicking on "new deploy"
How to prevent auto uploading, how to fill in the upload progress bar? Please give me a tutorial.
Great work you have done. Thankyou
Great, this help me so much, thank you broo
Hello! Thanks for the guide, this worked for me. I was hoping to see how you can post the image to sheets on form submit button. It uploads every photo that you choose to the drive, but I would like it so that it uploads when the form submits. Also how can you have the image be loaded into a certain column and have it be in the same row as other form inputs of the same form? Thanks!
Instead of using a change listener, you can execute the code inside the form submit event listener, like this:
form.addEventListener('submit', e => {
e.preventDefault();
// Image submission code here
});
To load the image into a different column, you can define a variable to select the specific column or row range, and then use the `range.setValue(imageLink)` method to set the image link in that cell:
const imageUrl = "example.com/image.jpg"; // Replace this with the actual image URL
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const imageCell = sheet.getRange("A1"); // Replace "A1" with the desired cell reference
imageCell.setValue(imageUrl);
This code will set the image URL (stored in the `imageUrl` variable) into the cell defined by `imageCell`, which you can adjust as per your specific requirements.
Good job, it s same way for document pdf word?
Very good...
But what can you do with it after saving?
Can I get some link from it and use it in an html page for example?
Yes the download link you can use in html page
Apke video ka volume low hei ise increase koreye
Can I get the source code?
Good content
please update you code link, or buy your domain again
👍👍👍👍👍👍👍👍
why the title is english and the video is on Indian language, bro pls talk english, i cant understand what are u talking about