Hey thanks a bunch for the help. Was wondering what code I would need to include in order to past a link to the folder in status rather than "complete". would you be able to help me with this?
Thanks for watching our videos. We share our knowledge, tips and ideas through this channel. But we don't do any coding for viewers or customers. Here maybe some hints so you can achieve your goal yourself. When creating a new folder or file you can get the respective link and then simply add it to the file. Check the official documentation to see how you can use Google Apps Script to interact with your files and folders: developers.google.com/apps-script/reference
I'm in a career where I deal with data and i simply want to merge PDF files from my GDrive into one document using sheets to filter the files needed. I have collected the data and written the sheets but i'm looking for an apps script to merge the files. Is this something your course can help me develop?
Hello. Thank you for sharing this video. I have a problem as follows. Can you help me. How to add path to another directory. for example, when I choose A, it will automatically create folders and files into folder 1. When I choose B, it will automatically create folders and files into folder 2
As demonstrated in the video you access that folder you want and create the file within it. Access the folder with the getFolderById() for example. See how to use Google Apps Script for Google Drive in the documentation: developers.google.com/apps-script/reference/drive
Hi can we run a JavaScript or python code when a specific file changes in drive ?. Let's say we have a form in drive and form contains quiz question and answer . if the form question or answers are edited . I wanna run some code . is this possible ?
If you want to use Node.js or Python to access any files on Google Drive, you would have to use the Google Drive API. developers.google.com/drive/api If you want to use a trigger, an on Edit trigger, that triggers your code to run when a file changes, you would have to use Apps Script like in the video. So you either use the Drive API with a language like Python or Node.js or you use Apps Script that gives you access to Drive like I do in my videos.
@@saperis thank you for your reply . also would onEdit trigger work on form ? because the drive file that I want to track changes of is a google form file
@@saperis I want to show images in google sheet, url also and images also from google Drive, but will I have to. Set images to. Anyone with the link can view, to. Show images in google sheet
Hi, my code: function printMessage() { const folder = DriveApp.searchFiles("test"); Logger.log(folder.next().getName) } However, when the script reaches the line 'var folder = DriveApp.getFolderById("myfolderID");' I encountered an 'Exceeded maximum execution time' error. how to fix?
If it was deleted then there is nothing to access. If your account is a paid Google Workspace your employer might be using Vault. In that case contact your Google Workspace administrator.
You have to put it in a separate .html file within the script editor and between style HTML tag. See the details here: developers.google.com/apps-script/guides/html/best-practices#page.html
Not directly. But an admin could reset your password and log in as you. So indirectly there are ways to do so. But most companies have regulations that inhibit admins of doing such things. Anyway, always keep in mind: whatever data you create and store with your company account belongs to the company. If you want to store personal things than your company's My Drive isn't a good choice.
@@saperis Last question ma'am, could the admin reset the password and log in as me without notifying? Even though the 2-step verification is activated and my phone number is linked into it.
@@Jerome-N According to this support article from Google that wouldn't work: support.google.com/a/answer/9176734?hl=en But we are only experts for the enduser side of things. If you want a 100% security on this you should reach out to a Google Workspace admin.
I had no idea Google Apps Script existed. Thank you for this video.
You are more than welcome 😀
You are an amazing instructor. Thank you for all you teach us.
You are very welcome 😀
thank you. very usefull. regards erik
Glad it was helpful! 😀
Hey thanks a bunch for the help. Was wondering what code I would need to include in order to past a link to the folder in status rather than "complete". would you be able to help me with this?
Thanks for watching our videos. We share our knowledge, tips and ideas through this channel. But we don't do any coding for viewers or customers.
Here maybe some hints so you can achieve your goal yourself.
When creating a new folder or file you can get the respective link and then simply add it to the file.
Check the official documentation to see how you can use Google Apps Script to interact with your files and folders: developers.google.com/apps-script/reference
Thanks a lot Chanel!
You are welcome! 😀
I'm in a career where I deal with data and i simply want to merge PDF files from my GDrive into one document using sheets to filter the files needed. I have collected the data and written the sheets but i'm looking for an apps script to merge the files. Is this something your course can help me develop?
No, that is nothing we cover in our Apps Script online course.
Hello. Thank you for sharing this video. I have a problem as follows. Can you help me.
How to add path to another directory. for example, when I choose A, it will automatically create folders and files into folder 1. When I choose B, it will automatically create folders and files into folder 2
As demonstrated in the video you access that folder you want and create the file within it.
Access the folder with the getFolderById() for example.
See how to use Google Apps Script for Google Drive in the documentation: developers.google.com/apps-script/reference/drive
Hi can we run a JavaScript or python code when a specific file changes in drive ?. Let's say we have a form in drive and form contains quiz question and answer . if the form question or answers are edited . I wanna run some code . is this possible ?
If you want to use Node.js or Python to access any files on Google Drive, you would have to use the Google Drive API. developers.google.com/drive/api
If you want to use a trigger, an on Edit trigger, that triggers your code to run when a file changes, you would have to use Apps Script like in the video.
So you either use the Drive API with a language like Python or Node.js or you use Apps Script that gives you access to Drive like I do in my videos.
@@saperis thank you for your reply . also would onEdit trigger work on form ? because the drive file that I want to track changes of is a google form file
Thanks!
You're very welcome and thank you for supporting our channel. 😀
Hi is there any way to show images from google Drive url without sharing it??
I don't understand, you want to show (to whom and where) images without sharing them?
@@saperis I want to show images in google sheet, url also and images also from google Drive, but will I have to. Set images to. Anyone with the link can view, to. Show images in google sheet
@@siddharth3419 You can add images to Google Sheets (Insert > Image). The image should be visible to anyone who has access to the Sheets file.
Hi, how do I check if the folder already exists before creating it?
You would have to add a conditional if statement before you have a new folder created. www.w3schools.com/js/js_if_else.asp
Saludos desde Colombia, sería muy chévere ver los subtítulos en español
Hola Ferney. Talvez en futuro podremos añadir subtitulos en español.
It is awesome what you did.
Can I hire you to create a similar code for my task?
No, I don't offer any coding services.
Hi, my code:
function printMessage() {
const folder = DriveApp.searchFiles("test");
Logger.log(folder.next().getName)
}
However, when the script reaches the line 'var folder = DriveApp.getFolderById("myfolderID");'
I encountered an 'Exceeded maximum execution time' error.
how to fix?
Maybe this article can help: pulse.appsscript.info/p/2021/08/an-easy-way-to-deal-with-google-apps-scripts-6-minute-limit/
How do I access files in Google Drive that was deleted 6 months ago? please help me
If it was deleted then there is nothing to access. If your account is a paid Google Workspace your employer might be using Vault. In that case contact your Google Workspace administrator.
Hi how do I access css files in Google apps script
You have to put it in a separate .html file within the script editor and between style HTML tag.
See the details here: developers.google.com/apps-script/guides/html/best-practices#page.html
Hello ma'am I have a question. Can my organization access my folders in my google drive without me knowing?
Not directly. But an admin could reset your password and log in as you. So indirectly there are ways to do so. But most companies have regulations that inhibit admins of doing such things.
Anyway, always keep in mind: whatever data you create and store with your company account belongs to the company.
If you want to store personal things than your company's My Drive isn't a good choice.
@@saperis That was insightful. Thank you ma'am! 😊
@@saperis Last question ma'am, could the admin reset the password and log in as me without notifying? Even though the 2-step verification is activated and my phone number is linked into it.
@@Jerome-N According to this support article from Google that wouldn't work: support.google.com/a/answer/9176734?hl=en
But we are only experts for the enduser side of things. If you want a 100% security on this you should reach out to a Google Workspace admin.
@@saperis thank you ma'am!!