If you enjoyed this video, you might also like this one: kzitem.info/news/bejne/2WmuwIyAppRhaIo
@justiceinkoom2983
Жыл бұрын
Please can you make a video on HOW TO SHOW THE USER INPUTS IN THE NEXT SECTION OF A GOOGLE FORM.
@justiceinkoom2983
Жыл бұрын
To throw more light on what I'm asking for: I want to create a google form that when the user enters some inputs in the first section those input will appear in the next section of the form.
@simonelgarrad
Жыл бұрын
I am a coder and have worked with Javascript before. But the fact that she has explained these concepts in such lucid language so that non coders can grasp it is amazing. Great Job. 🎉
@saperis
Жыл бұрын
Thank you for the feedback. I believe in teaching concepts and not simply sharing code which viewers can copy & paste.
@Zulonix
11 ай бұрын
@@saperis Did you intend to say "copy and turn to pasta?" ;-)
@Maire3935
9 күн бұрын
right!! I have uber enjoyed this!
@md310
Жыл бұрын
I am a python coder ... i have to say this was a delightful intro to gscript and well worth my time ... i LOVE your style ... so clear and concise ... no fat.
@saperis
Жыл бұрын
I'm happy you liked it. Have fun with Apps Script!
@thoughtsbygrich5967
2 жыл бұрын
Thank you so much! For a complete beginner in programming, this tutorial taught me so much more than I'd expected. Really appreciate your content and your articulate style of teaching. 30 out of 10!
@saperis
2 жыл бұрын
Thanks for watching and learning with our video. Learning to code is a challenge but one you can master. 👍
@spadealt456
2 жыл бұрын
🧡
@madavplc703
2 жыл бұрын
Hello madam how to make student results viewer in Google sheet by typing index number
@ifeanyibarth5137
11 ай бұрын
Non coders understand? Nah!
@nitchow
3 жыл бұрын
Hello @Saperis, This one video cleared up a bunch of important concepts including adding script execution to the menu etc. Minute for minute the best video on the subject that I've seen. Very neatly done!
@saperis
3 жыл бұрын
Great to hear and thank you for watching! 😀
@spadealt456
2 жыл бұрын
🧡
@enchantinglysimple
Жыл бұрын
I just want to say what a well explained video. For someone who struggles understanding things easily, you do a fabulous job breaking things down. I am so excited to learn more from your videos. So glad I found this video!
@saperis
Жыл бұрын
Happy to hear that! We have a playlist full of beginner friendly JavaScript videos you might want to check out: kzitem.info/news/bejne/2WmuwIyAppRhaIo
@m.l4080
2 жыл бұрын
ive been in the coding game for about 2 years now, and by far the best tutorial for beginners indeed. usually when people say for "beginners" they still treat it like its advanced, or they already know coding/JavaScript terms. studying for an interview tomorrow and this helped a lot, so thank you. and also thank youfr breaking it down BY TERM for the true (no pun) beginners.
@saperis
2 жыл бұрын
Happy to hear you find the video helpful. By the way, I've started making pure JavaScript videos for beginners. You might find them helpful. All the best for your job interview!
@xaquison
3 жыл бұрын
You definitely have a gift for teaching. I look forward to your other videos
@saperis
3 жыл бұрын
Thanks for your motivating words! You might also want to check out my Google Apps Script online course: courses.saperis.io The first lessons are for free so you can try out the course with no strings attached.
@ramsubramanian359
3 жыл бұрын
Very True.
@luisr320
2 жыл бұрын
Hello Saperis. I'm starting to learn how to use Apps Script and after browsing throughout KZitem, I ended up here, on account of your very calm and tutorial way of explaining things. I have one question, though: on minute 18:25 you say that you could call the function onOpen() whatever you like. So when will the script figure out when to run this onOpe() function to start running? Isn't "onOpen()" the specific name that the script will look for to start running when you open the file? Once more, thank you.
@saperis
2 жыл бұрын
Hi Luis. Yes, the onOpen() function runs when the file is opened. So here you would for example create a custom menu so you can then run the other functions you have created.
@spadealt456
2 жыл бұрын
🧡
@DanaJenkins-tc2ct
5 ай бұрын
I have watched many coding tutorial videos, and you have done such a fantastic job at explaining code to non-coders. Thank you so much
@fartman3254
Жыл бұрын
Watch in 1.25x becuase she talks like a lazy grandma. But overall video is 10/10 and really helpful.
@saperis
Жыл бұрын
😀
@moatazkhan4345
2 жыл бұрын
@saperis if you call the function at line 18 anything other than "onOpen()" then it wouldn't work, and the menu wouldn't appear.
@saperis
2 жыл бұрын
Correct. onOpen is a simple trigger and has to be written like that.
@dkg4975
3 жыл бұрын
Best teacher I have seen in my life 😊😊
@saperis
3 жыл бұрын
That's so nice of you! Check out my online course if you want to dive deeper into Google Apps Script: courses.saperis.io
@savashzaynal6502
2 жыл бұрын
Yes she is very good, that said however either your to young, you have not seen many teachers or you have the world's worst luck.
@saperis
4 жыл бұрын
Check out my Google Sheets Automation online course: courses.saperis.io/
@pks-bisqp2677
4 күн бұрын
So simple... and so informative. Thanks a lot! :D. You did an amazing job with this video by introducing people completely new to coding and scripting.
@handlepersonthing
2 жыл бұрын
Great video to get started in Google Apps Script! One thing I noticed on mine is there's no script editor option in the Tools menu. I found this under Extensions -> Apps Script.
@saperis
2 жыл бұрын
Yep, Google updated the Google Sheets menu since I made this video tutorial.
@merjohncorvera
3 жыл бұрын
Hi Saperis, your videos are awesome! The way you explain things (maybe also because of your voice) makes me wanna listen until the very end which I believe is a very important skill in teaching. May I request a tutorial video on how to copy row values from sheet to sheet using Google Apps Script? Thank you! :)
@saperis
3 жыл бұрын
Hi Merjohn. Thank you for the great feedback! I'll add your request to my list and will publish such a video in the future. So stay tuned to my channel. 😀
@saperis
3 жыл бұрын
Hey Merjohn. I jost published the video you requested about copying a row from one sheet to another. Check it out: kzitem.info/news/bejne/2aOq3YuBkn57e6g
@NabeelButt
Жыл бұрын
I am not a coder but loved the way she's explained it. precise and at a pace that a beginner can grasp the concepts and do it simultaneously.. Amazing job!
@saperis
Жыл бұрын
Happy you liked the video 😀
@sunpy7908
3 жыл бұрын
Your video series was needed years ago. Thank you so much, I learned a lot.
@saperis
3 жыл бұрын
You're very welcome! I'll be adding a new Google Apps Script video every month.
@spadealt456
2 жыл бұрын
🧡
@mohdzafarofficial
2 жыл бұрын
Superwomen What a teacher 😍 Love from india
@saperis
2 жыл бұрын
Thank you very much for learning with us on our KZitem channel. 😀
@LongSamniengpol
2 жыл бұрын
Awesome video!! You explained so well. I will have to rewatch it again to understand better. I am completely new to the App Script...Hopefully, I can get used to of using this.
@saperis
2 жыл бұрын
I'm sure you will learn it! Have fun.
@BetWithLB
2 жыл бұрын
I've watched 10+ videos to get started on GS and was about to give up, but thank goodness I stumbled across your channel. Thank you very much
@saperis
2 жыл бұрын
Great to hear! 😀
@NetMediaCCTV
3 ай бұрын
Thank you for your sharing. Very useful for beginners!
@Anvjc85_bxjv_jcfjeyiut68
3 жыл бұрын
Hi! This helped me understand it better and makes me more motivated to learn Google Scripts, thanks. Cheers!
@saperis
3 жыл бұрын
Great to hear Livia! Have fun with learning Google Apps Script. 😀
@AnshulMarele-gbaa
5 ай бұрын
How to give Individual Worksheet View, Edit & download Access to Specific Email in one Google Sheet Workbook? For example: Sheet1 can be viewed, edited & downloaded by Mr. A only, Sheet2 can be viewed, edited & downloaded by Mr. B only, likewise
@WenSaiPanther
3 ай бұрын
Thanks for your good work. Here's the really odd thing, Google Sheets people removed the scripts editor. Any suggestions?
@user-fv1576
23 күн бұрын
What caused the delay ? Is google sheets really that slow at running scripts?
@jamesbond_007
4 ай бұрын
You said that "onOpen" was just a random name, I think you said "it can be anything you like". However, the evidence presented suggests that it is a *special* name that will be executed when spreadsheet open events are received. I would request that you add a quick asterisk text to the video that explains that his is a SPECIAL name, and not just whatever name the coder wants, if you want to have it automatically be called when the spreadsheet is opened.
@Moist_yet_Crispy
3 жыл бұрын
What a great tut! I love the way you explain things. I could learn/listen all day!
@saperis
3 жыл бұрын
Thanks for the feedback Corey. I put out a new Google Apps Script tutorial every month so stay tuned. 😀 And you might want to check out my online course: courses.saperis.io
@spadealt456
2 жыл бұрын
🧡
@chrisder1814
Ай бұрын
hello I thought that appscript only allows you to connect an API? but in fact it allows you to do a lot more things than that?
@sertzaiweld4389
Жыл бұрын
I was following by live doing your steps. I had to save halfway and shut my pc. Upon reboot, I launched Chrome and opened the form and the spreadsheet from google drive. When I opened Script editor, it gave me a new page. I could not find the code that I was working on. How or where can you find the source code if you want to edit?
@ZXXZZXXZ
4 жыл бұрын
Thanks for the informative video. Previously when I was learning App Script i have seen people using "var" before a variable to define it. Is there any difference between let & var? Also, is it possible for App Script to search the name of a SpreadSheet file in a folder and if the spreadsheet name matches, it will get the URL or ID for it?
@saperis
4 жыл бұрын
Hi Alex. Thank you for your comment. Here the answers to your questions. var vs let > you can use either to create a variable. I always use let. There are some technical differences though, which you can read about here: developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/let#:~:text=let%20allows%20you%20to%20declare,function%20regardless%20of%20block%20scope To search for a file you could try combining Google Drive method getFilesByName() with Google Spreadsheet service. Here the infos on Google Drive Services for Google Apps Script: developers.google.com/apps-script/reference/drive/drive-app#getFilesByName(String) Greeting, Chanel
@ZXXZZXXZ
4 жыл бұрын
@@saperis Dear Chanel, thanks for your reply. As I am relatively amateur in App Script with no experience of JavaScript (only Java), do you provide online consultation to one person (my personal project) on behalf of saperis with a fee of course?
@saperis
4 жыл бұрын
@@ZXXZZXXZ Hey Alex. Write me an email to hello@saperis.io and let me know what topics in Google Apps Script you want coaching for.
@ZXXZZXXZ
4 жыл бұрын
@@saperis One last question, if I learnt the basics of JavaScript, will I able to learn and write app scripts more easily, according to your experience? Thanks in advance!
@saperis
4 жыл бұрын
@@ZXXZZXXZ Yes you will. Google Apps Script is based on JavaScript. So learning one of these two coding languages will also help you read and write the other language. - Chanel
@AleksTrifonov
Жыл бұрын
How do I publish an app on the Google Workspace Marketplace? Make a video tutorial on this topic.
@AhmedShakil
Жыл бұрын
Wow! I am impressed. I am a software engineer as well. I have to admit that no one really talks about these basics and good practices any more including the documentation. The whole industry has become adhoc development campus. I normally do not subscribe to the one time videos that I watch, but I did end up subscribing.
@saperis
Жыл бұрын
Happy to hear you like this video. You know the saying where you give someone a fish and they will eat for a day. But if you TEACH them how to fish they will eat every day. I believe in teaching the HOW and WHY so that aspiring developers can apply concepts instead of only copy & pasting code. And yes, learning to read and use the documentation of any technology is super important in my opinion.
@inderjeetpal2998
2 ай бұрын
You have such a lovely voice. Which Mike you are using.
@rent2ownnz
Жыл бұрын
you should have just kIcked straight into it .... I skimmed and skimmed .... no work was done whatso ever..... lucky I did not waste my time - NOTHING TO SEE HERE FOLKS OF ANY VALUE.....
@saperis
Жыл бұрын
Sad to hear you didn't learn anything from this video.
@healthadvice3091
10 ай бұрын
You are a handsome woman, btw this video is helpful
@marksawesomeadventures
2 жыл бұрын
I want to make this Code work on Multiple pages in the Same Google Sheet, how do I do that? function onEdit(e) { var range = e.range; var spreadSheet = e.source; var sheetName = spreadSheet.getActiveSheet().getName(); var row = range.getRow(); if(sheetName == 'SHEETNAME') { var new_date = new Date(); spreadSheet.getActiveSheet().getRange(row,6).setValue(new_date).setNumberFormat("MM/dd/yyyy hh:mm:ss A/P"); } } I tried just ADDing If statement lines for each page that didn't work. Can I Add the Names of the Pages in the SAME If Statement? If So, how do I separate them with a Comma or Semi colon?
@saperis
2 жыл бұрын
Here a couple of tips: - Use the console log or run your code in debugger mode to see what values you get from things like e.source. Here a video on how to do this: kzitem.info/news/bejne/rWqMl2mQsXubdYY - You could use a switch statement instead of separate if statements: developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/switch
@koreanqueen7458
Жыл бұрын
how to add sell subscription charge and sell our appscript on google workspace 😢
@saperis
Жыл бұрын
There is no way to sell our Apps Script project on Google Workspace. You can though make a Google Workspace Add-on: developers.google.com/apps-script/add-ons/how-tos/building-workspace-addons
@koreanqueen7458
Жыл бұрын
@@saperis then how people are charging subscription charges? What method they use for giving few trials and then ask for payment later
@saperis
Жыл бұрын
There is no built-in way to do this. You will have to set up a payment method yourself.
@koreanqueen7458
Жыл бұрын
Your videos have helped me a lot. Now I have started making apps. Its time to earn now. Do you know any payment method any idea to earn money now by adding subscription or payment method. How can I add stripe or paypal.
@claytontrehal463
2 жыл бұрын
Very nice teaching here! Not only did the tutorial work and showed me how to do what I wanted, but the way you explained it is clear and understandable. This was my first foray into using the Apps Scripts, but it is not my last! Thank you.
@saperis
2 жыл бұрын
Happy you liked it! We have an entire playlist with Google Apps Script videos. You might want to give it a look: kzitem.info/door/PLNwCcck1-mNhiOoAGICW3fYKTP5gHZyjR
@hanzupchannel
Жыл бұрын
That was amazing tutorial I think for beginner like me.. I already tried this tutorial especially for the last function but sadly, I don't find UI on my google sheet menu.. I see in this tutorial it will show up on right of Help menu. Maybe you could give me a hint what should I check to solve this error?
@saperis
Жыл бұрын
Here is a detailed explanation on how to customize the UI: developers.google.com/apps-script/guides/menus
@PositiveLee-eo9rt
4 ай бұрын
4:26 lucky for you to still have a job to go to...
@hemanthmasterpiece2664
4 жыл бұрын
Thank you so much it worked kindly please teach more about google spreadsheets the way you teach is awesome and understandable.
@saperis
4 жыл бұрын
Thank you very much! I'm happy that others can learn from my experience and go on to create useful Google Apps Script automations. - Chanel
@isaacchukwuma7829
6 ай бұрын
It's my first time learning about app script but I have foundation knowledge about JS. I need urgent answer please, can I use Google app script on mobile phone? Can it connects to my Google sheets just like this?
@saperis
5 ай бұрын
Apps Script runs on the server so it doesn't matter if you open up a Google Sheets file with Apps Script tied to it on desktop, mobile, or sheets.
@FilmFraudFinder
3 жыл бұрын
How to display Dynamic Max/Min/Avg value in google sheet timeline chart? Max/Avg/Min value to change with timeline chart weekly/monthly/yearly?
@saperis
3 жыл бұрын
Don't know. But if you find a way you can share it with our viewers.
@KuyaRicOfPRU
2 жыл бұрын
Good day! Can you make tutorial on how to make RESPONSIVE PRODUCT CARDS on webpage using Google Sheets & Apps Script?
@saperis
2 жыл бұрын
Thanks for your request. We try to make videos that are interesting to as many viewers as possible. Your request doesn't macht any of the frequent searched for Google Apps Script topics on KZitem.
@jojos8888
7 ай бұрын
Thanks for the video. Your teaching is clear! May I know if you have a video that allows me to call a function from a cell? I’m thinking of converting my excel sheets which has a few functions written in VBA. Thanks!
@saperis
7 ай бұрын
No, I don't have such a video. But how about going about this differently? Maybe using an onEdit trigger that runs your function when the sheet is updated? See the documentation for more infos: developers.google.com/apps-script/guides/triggers
@Zulonix
11 ай бұрын
I see several comments saying the commenter is a this coder or that coder. IMO, they would do themselves a favor by calling themselves software developers. Programming languages are simply a vehicle to implement logic. The first language I learned was RPG II. My next language was COBOL where I thought I'd died and gone to heaven. Well, I finally made it to heaven when I learned C.
@saperis
11 ай бұрын
Thanks for sharing your programming journey.
@mariannehislop5158
3 жыл бұрын
Thank you. Completely knew to Google products. Long time Office (Excel) user. Worked great until the very end, then I got an alert "Google hasn't verified this app. The app is requesting access to sensitive info in your Google Account. Until the developer (.........@gmail.com) verifies this app with Google, you shouldn't use it. ??
@saperis
3 жыл бұрын
Yep, that happens because you are using a free, consumer version of a Google account. On the other hand I am using a paid Google Workspace account. Although you can follow along with a free Google account with about 80% of the things I show here, somethings won't work the same or at all compared to the Google Workspace account I'm using.
@AniketKulkarni-k8r
6 ай бұрын
this video is indeed a great help to kickstart learning. however, I have a GS code consisting spreadsheetApp and Drive. can you please refer any video which shall help me in debugging that code? Thanks in advance
@saperis
6 ай бұрын
Check this video to see how to debug: kzitem.info/news/bejne/rWqMl2mQsXubdYY
@RajRaj-ch7ds
10 ай бұрын
Mam the way you explained is truly awesome and easily understandable. Thankyou so much for providing us these types of videos. Keep up the good work 💯
@saperis
10 ай бұрын
It's my pleasure 😃
@alanharris3061
6 ай бұрын
I cannot seem to find script editor in my browser and it doesn't appear in Excel sheets. Driving me mad. I have a Google account and using laptop, even looked on desktop.
@saperis
5 ай бұрын
Since I've published this video, the menu in Google Sheets was updated. Look for Extensions > Apps Script. If on the other hand you are opening an Excel file in Google Sheets, you can't use Apps Script. It only works with Google Sheets files.
@SunilBhatt-h7p
Жыл бұрын
I am seeking a solution regarding data automation through Apps Script. Specifically, I have a collection of CSV files stored in my Google Drive, with a new file being generated each day. My objective is to extract data from these files and import it into my Google Sheet. It is worth noting that the format remains consistent across all the files. I kindly request your guidance and expertise on whether it is possible to achieve this integration. Any insights or suggestions you can provide would be greatly appreciated. Thank you in advance for your assistance.
@saperis
Жыл бұрын
Yes, that is possible. Check this sample to get an idea of how you can do this: developers.google.com/apps-script/samples/automations/import-csv-sheets
@maherm.7966
4 жыл бұрын
Awesome. It's so helpful. I like to learn more how to create Add, Del, Update buttons. Can I get some help from you
@saperis
4 жыл бұрын
Hi. I‘m happy you found this video useful. I have more video tutorials about Google App Script that you can check. Greetings, Chanel
@saperis
4 жыл бұрын
Thank you for the feedback. I’m happy to hear that!
@marksawesomeadventures
2 жыл бұрын
Wait, wait wait! I go to TOOLS, there is NO SCRIPT EDITOR!! Start there Please.
@saperis
2 жыл бұрын
This video was made more than 2 years ago. Since then, Google has updated the entire Google Sheets menu. Check Extensions > Apps Script.
@jodtark
2 жыл бұрын
Wow... This is just what I need! Thank you, subscribed, followed, and liked! I'm attempting to use the script in sheet to open two websites that I have listed within the open spreadsheet. I want to launch these sites with new dates each month. I'm using the concatenate function to append a new date at the end of the website url (...reports/valuation?date=02/28/2022). Do you have a video that describes something similar? thanks in advance.
@saperis
2 жыл бұрын
No, I don't. I've never done anything similar myself so I don't even have any "tips & tricks" to share with you. ☹
@rinsidaniel191
2 жыл бұрын
Thank you so much for the video! I am trying to solve a problem where I have a Google form, and based on what user inputs for Q1, I want to autopopulate the answers for Q2, Q3, Q4, etc. from a Google spreadsheet. This is to save time for the end user filling the survey. I cannot use the prefill functionality as this is dependent on user response for a question. Can this be done using Appscript?
@saperis
2 жыл бұрын
I've never done anything like that. But in theory it should be possible.
@chrisw1462
Жыл бұрын
Manipplating? I'm just not that kind of a programmer... (Manipulate - manIP-you-late)
@saperis
Жыл бұрын
Thanks for watching the video
@davidb4093
8 ай бұрын
Unfortunately this did not work for me despite following all the steps. The script only works for one file under which it was created. Once I copied the code to a "standalone" script which was supposed to apply to all of my sheets documents, the new UI item never appeared.
@saperis
8 ай бұрын
Note that we are using the getActiveSpreadsheet method in this video which gives you the active, meaning open, Google Sheets file. So this can't work if you are using a standalone Apps Script that should apply to all your Sheets files. Learn more about the method used in this script: developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#getactivespreadsheet
@SergioSanchez-l2w
2 ай бұрын
Awesome! Thank you so much!
@deepakranamis199
2 жыл бұрын
Hello madam, I want to learn Google Apps Script and after searching so many youtubes videos, I think your channel is best platform to learn google app script for beginners, I love your way of teaching. You explained it very deeply and very clearly method. But I have one doubt I don't know about javascript language , so can this is also beneficial for me or not, or either to learn google app script we should have knowledge about javascript
@saperis
2 жыл бұрын
Google Apps Script is essentially JavaScript. So the more JavaScript you know the faster you will be automating things with Apps Script. But you can also learn JavaScript by learning Google Apps Script.
@fiorediaries3541
3 жыл бұрын
This is very informative. Can you also make a comprehensive tutorial on how to do multiple levels of dependent drop down menu on google sheets?
@saperis
3 жыл бұрын
Hey there. Thank you for your request. I might do something like that in the future. In the meantime check out my Google Apps Script online course: courses.saperis.io
@spadealt456
2 жыл бұрын
🧡
@oluwayomidada3536
2 жыл бұрын
Hi saperis, absolutely wonderful, thanks a lot. Have a problem. I have a Google sheet with plenty tabs and renaming them has been a headache, how can I rename my Google tabs using appscript.
@saperis
2 жыл бұрын
In theory, you could have in Column A all the existing tab names and in column B all the new tab names. Then you could write a script to get every existing tab by name and rename it. But I'm guessing you will be faster by renaming every tab manually.
@jagadeepjadhav
2 жыл бұрын
I need a script to copy the value from a particular cell (which changes dynamically) to another sheet in a tabular form. Each time the source value changes, the destination should note the time of change and the value in next row. Could you please help in this? With Best Regards, Jagadeep Jadhav
@saperis
2 жыл бұрын
You probably need to set up a trigger. Something like the onEdit trigger would probably work best. developers.google.com/apps-script/guides/triggers#onedite
@divayrana275
2 жыл бұрын
Why we should use Google scripts ,we can format it manually in excel very easily without coding in few minutes , What is the advantage of Google scripts ? Can u please explain
@saperis
2 жыл бұрын
First, Google Apps Script is only for Google apps. So if you want to use it for Excel that won't work. Second, whenever you want to automate something within a Google Sheets, you can use Google Apps Script. Have a look at this video to get an idea of what you can do with Apps Script: kzitem.info/news/bejne/xmhvn5eqb3lld4Y
@sulemandawood9140
Жыл бұрын
Thank you so much for this beautiful piece of knowledge. Respect and regard for you
@saperis
Жыл бұрын
Glad it was helpful! 😀
@Jacob11Fox
4 жыл бұрын
Super helpful video :) thank you!
@saperis
4 жыл бұрын
You‘re welcome Jacob. Let me know if there‘s any other Google Apps Script related topic you would want me to cover. - Chanel
@anthadupulasuresh2539
2 жыл бұрын
Thank you for making this video. But I wanna ask you something. If I want delete the specific group of cells with the help of onedit function and one cell as trigger to run the script, what i need to write in Appscript. Please help in this regard. Thanks in advance
@saperis
2 жыл бұрын
Well, I can show you how to do many things with Apps Script through the videos we published. But if you want to create a new script that does something else, I can't write the script for you.
@theannyoonweemcroy8830
3 жыл бұрын
I just attend Google course in hiring east
@GiovanniTommasini
Жыл бұрын
Nice video, thanks a lot! Is it also possible to use a "createMenu" function to add a custom field in the google calendar event? I'm trying to create a custom field in a Google Calendar event to choose the corresponding project of that calendar event
@saperis
Жыл бұрын
No, that's not possible. You can't add custom buttons or fields.
@usamaballu1993
3 жыл бұрын
Ma'am I need a complete video tutorial on point of sale project on apps script and designing on our project and easy to use software making along with google spreadsheet database auto generating....kindly next videos I learn this things .....
@saperis
3 жыл бұрын
Well that's a very specific video you are asking for. We keep our videos here general so that as many viewers as possible can benefit from them. I don't think we will be able to make that specific video you are looking for. Maybe it would be better for you to contact a Google Apps Script developer if you want help on your own projects.
@ashanair6040
2 жыл бұрын
Your instructions are great. However, I wasn't able to follow along as a beginner. I'd like to get one-on-one training from you and I'll be happy to reimburse you for your time. Please let me know.
@saperis
2 жыл бұрын
Hey there, I currently don't offer any personal coaching for Google Apps Script. If you want to though you can check out my online courses: www.saperis.io/products
@oniadrian
2 жыл бұрын
Apps script assumes and requires you to know JavaScript. My problem with this tutorial is that too much time was spent assuming the viewer does not know any programming and tried to teach basic JavaScript.
@saperis
2 жыл бұрын
Hi Denis. This channels does, as you've noticed, teach Apps Script to people who DON'T have coding or Javascript experience. So if you find our tutorials boring, that's great news for you! That means you are already at an advanced level! 👍
@monmonbonbon
Жыл бұрын
Hi is there a way I can contact you directly for some help. What is your hourly rate? I'm in a time crunch and would like to ask you specific questions to do a script and app connecting to slack. Are you able to help
@saperis
Жыл бұрын
I don't offer any coding services. Check this directory to hire an Apps Script freelancer: workspacedevs.com/
@Shaistakhan-sg1gb
Жыл бұрын
so nice teaching, teacher like you very rare on KZitem, I just found you today, and soon i will learn a lot from you.... .
@saperis
Жыл бұрын
Happy to hear that! 😀
@arthurmarquis764
3 жыл бұрын
turn down the mic gain. Win more. Your tutorial is really good, but the mic gain is not 100%.....
@saperis
3 жыл бұрын
I know. In the meantime I've improved my recording setup. But you can't improve old videos.
@LukasMossum
6 ай бұрын
Whenever I create a new script it makes the last one stop working, why is this? I even name them differently,
@saperis
6 ай бұрын
You mean that when you create a new file with a new script, the old script in the other file doesn't work? They aren't connected to each other so that seems odd.
@azurazdandaridae9158
2 жыл бұрын
Fail. This is supposed to be a tutorial for beginners. Script editor doesn't show in my tools menu. Why? How about tutoring properly and letting people know how to get the damn thing to show up in the first place.
@saperis
2 жыл бұрын
Hey there. Google is currently updating the menu structure and for some users the script editor isn't under 'Tools' anymore. This isn't the case for our Google Workspace domain yet, so I don't know how the new structure will be.
@JinaneKarhaniRawda
2 жыл бұрын
Thank you for this nice tutorial ..After following all the steps, once I open the sheet associated with it, it gets formatted by itself & the menu doesn't appear, any idea what did I do?
@saperis
2 жыл бұрын
No, wouldn't know what went wrong. Maybe check your code again for any missing symbols or any typos.
@MISMydaddy
Жыл бұрын
what a explanation if i got chance to have live classes from you will be a great opportunity. thank you mam.
@saperis
Жыл бұрын
Happy you liked the video.
@reactstack257
Жыл бұрын
Thank you for the video, I have a question: what if I want to add more rows and columns for the table? should I edit the code every time for those changes?
@saperis
Жыл бұрын
You can define a different range in the sheet. Check this video: kzitem.info/news/bejne/2G93voacq5qFdoY
@hahahahaha52010
2 жыл бұрын
The video is slowed down. The voice becomes very weird. You should play this with x1.25 speed
@saperis
2 жыл бұрын
👍
@shonabarnes7610
2 жыл бұрын
What if I have a hierarchy set up in my presentation and I just need column C to autofill on the last set of boxes of the hierarchy on different pages of the presentation? I hope I'm making sense.
@saperis
2 жыл бұрын
I must admit, I don't quite understand what you are trying to achieve. But in general: you decide on which columns you want to do formatting or add values. Just make sure to select the correct column. Check how to use the getRange method to access specific columns or rows in your Google Sheet: developers.google.com/apps-script/reference/spreadsheet/sheet#getrangerow,-column
@AJ-iv4vf
3 жыл бұрын
Hi, Can you make an script that will read the Google sheet and sent an email when click on run. The sheet will have columns such as To , cc, bcc, Subject, body and attachments from drive. When the mail is sent it will write as Yes in a cell. We will have multiple rows for sending bulk emails.
@saperis
3 жыл бұрын
Sure. Have a look at this template provided by Google: developers.google.com/workspace/solutions/mail-merge
@AJ-iv4vf
3 жыл бұрын
@@saperis Thanks!! I tried and it worked. Just one question, is there any way, where I can send emails from my Group gmail email box not from my personal gmail. Within the same script.
@saperis
3 жыл бұрын
I found this that should help you with your goal: gsuite-developers.googleblog.com/2011/12/google-groups-and-google-apps-script.html
@thedebapriyakar
3 жыл бұрын
Lovely tutorial, thank you so much!
@saperis
3 жыл бұрын
Glad it was helpful! 😀
@honey24cute
4 жыл бұрын
I have a question. I am doing a lot of Excel Programming and I designed Excel Programs that will help me to create the database and the reports needed. I have this daily task I designed in Excel with macros and vba wanted to do it also in google sheet is that possible? I have a flow chart already in mind.
@saperis
4 жыл бұрын
Hey there. I thought I answered this question but don't seem to have done so. Basically, you can do many of the things you do with Macros and VBA in Excel in Google Sheets.
@PradeepKumar-1987
4 жыл бұрын
Love u bisnar, could u pls guide a source or website where I can learn macro & VBA, I do record macros but don't have coding knowledge
@arjunram4584
3 жыл бұрын
How to run a script on a spreadsheet being shared with others? The script should run automatically.
@saperis
3 жыл бұрын
Maybe the onOpen() trigger is what you need. Check out our video about triggers, the things that run your code: kzitem.info/news/bejne/rHlt1nagfWV4eqw
2 жыл бұрын
My English is very weak but she have crystal clear speaking. Wow
@saperis
2 жыл бұрын
Happy you enjoyed the video 😀
@ramonhamm3885
2 жыл бұрын
Can I make this work in a regular text only Google Doc or does it have to be in a table in a Doc or only in Sheets? Thanks!
@saperis
2 жыл бұрын
You can use Apps Script for most of the Google Workspace apps. Check the documentation to find out more: developers.google.com/apps-script/reference
@bharatjain839
3 жыл бұрын
Hey thank you so much for this wonderful channel, I was looking forward towards making some projects which involves taking data and values from the sensors and having them on my sheets. Can you please help me out as to what should I approach as a total newbie into this. Once again a heartful thankyou :)
@saperis
3 жыл бұрын
Hi Bharat. I'm happy you like this channel. Well, I think there are many different ways to get started with Google Apps Script depending on your prior knowledge. I have launched an online course for people who don't have any JavaScript knowledge and want to start processing data in Google Sheets. Check it out: courses.saperis.io
@spadealt456
2 жыл бұрын
🧡
@JosePadilla-v1x
2 ай бұрын
You are a really amzing Teacher. I dont speak english well but I understand everything you teach. Congratulation
@himanshusomani1744
Жыл бұрын
Very well explain video saperis! I have seen many beginner tutorials. this is one of the best :)
@saperis
Жыл бұрын
Glad it was helpful! 😀
@harshdhali7813
2 жыл бұрын
Awesome video Madam my Google problem is how to enable filter in protected Google sheet please solve my problem
@saperis
2 жыл бұрын
What do you mean with "protected Google Sheet"? Do you have access to the file?
@evasofge1804
3 жыл бұрын
This was such a helpful video! @saperis Would you consider doing a Google Apps Script tutorial for basic data analytics? Another helpful video could be how to incorporate Google Appsheet with Google Apps Script in order to incorporate some coding ability to the UI abilities of Appsheet.
@saperis
3 жыл бұрын
Sound like interesting topics to cover in future videos but I can't make any promises. Might cover such topics towards the end of summer 2021.
@spadealt456
2 жыл бұрын
🧡
@hans1783
2 жыл бұрын
let ui = SpreadsheetApp.getUi(); ui.createMenu('Custom Formatting').addItem('Format Report','function_name').addToUi();
@saperis
2 жыл бұрын
Ok, thanks for engaging with this video.
@AleksTrifonov
Жыл бұрын
How do I publish an app on the Google Workspace Marketplace? Make a video tutorial on this topic.
@saperis
Жыл бұрын
Sorry, I don't do any Google Apps Script videos on this channel anymore. Check out the official Google Workspace Developer's channel for such videos: www.youtube.com/@googleworkspacedevs
@chrisder1814
17 күн бұрын
hello can you help me
@ivanurbina2422
2 жыл бұрын
Love your tutorial. explaining object and then breaking it down to its component. Awesome!
@saperis
2 жыл бұрын
Glad you enjoyed it! 😀
@ynoter1
2 жыл бұрын
Hey thank you for the content i really appreciate it :) just wanting to confirm when you say the code is ran on the google cloud and not locally does that introduce any quota's or limits for how many import or calls you can do using google scripts? Because the idea is that i can do ideally hundreds or so but i'm not sure, thanks.
@saperis
2 жыл бұрын
Yes, the code is run on the Google servers and there are quota limits in place. You can check them here: developers.google.com/apps-script/guides/services/quotas
@spadealt456
2 жыл бұрын
🧡
@ra-hi1cw
4 ай бұрын
Thanx for that quiet , slow explanation and wonderful algorithm of teaching what is coding for beginners. I subscribed and am waiting for your new videos.
Пікірлер: 770