Advanced Coding Tips in Google Sheets for Programmers
Discover advanced coding techniques in Google Sheets tailored for programmers, including creating custom menus, native-like functions, and developing Google Sheets add-ons to enhance your productivity.
A year ago, I created Google Sheets for Coders. This is a quick guide, 15 minutes to coding. If you already know how to code, if you're a programmer somewhere else, I share with you a few things to know about programming inside of Google Sheets. What you're watching now is more advanced tips and tricks.
Speaking of better sheets, if you are watching this on Better Sheets now, great. If you're not a member of Better Sheets yet and watching this somewhere else, Better Sheets has now I think 548, so probably 549 tutorials there for you. 34 courses you can learn to code, automate sheets, add AI, design better dashboards , and even learn how to Publish add-ons, which I will talk about later in this video.
I'm going to just show you a little deeper. And then I'm going to talk to you a few, about a few things about developing Google Sheets add-ons. Once we get through all of those and why it's important to develop add-ons. If you're a coder and you already know how to code, coding in Google Sheets provides you a user base of 2 billion users.
Okay. So first off, let's go to extensions, add extensions, app script actually. And we're going to create a custom menu .
You can make it clickable right here. What are native like functions ? The native functions are all like this, filter , and they have some information here.
So let's create one that we might actually want to do, which is equals get, URL. So we want to get the URL of the sheet with the word on. How do we do that? First off, we're going to use this custom function .
And instead of create menu, What we're going to do is create add on menu. We're going to save this. And again, this will only happen. This function will only happen when we're open the sheet.