Apps Script - Difference Between Properties & Methods in Objects and Class Instances - Live Stream

Apps Script - Difference Between Properties & Methods in Objects and Class Instances.
Live Stream Recording.

[@thecodfather7109]

I had to jump on a course and pay a tutor just to find out the differences and then you upload this 🤦🏽‍♂️ I should've just waited lol 😂

[@tomeknaj]

what if I told you you never had to do it in the first place...

[@johnmillersr.colorado]

As always, thanks so much for what you do on this channel. A definite thumbs up! 😀I've seen another video that explains objects and demonstrated the usage of them in more detail. I'll ditto what Mark Mark posted because you kept your tutorial very basic. I've been working on replicating the MS Word mail merge functionality using Google Apps Script (GAS) and it's been challenging yet fun. Your tutorials have been a key making that happen, and utilizing objects has been helpful. (One thing I would note if anyone is considering a mail merge project, to save time, is that Google's limit on GAS processing time is about 6 minutes for a free account, which I had to overcome using timed triggers.)

[@MarkTheCat]

thanks for the video! great explanation as always!

[@Kevin_Cohen]

The exact video I asked for, thanks so much!

[@nazer2husen]

Hello, i have a question. In Google Spreadsheet / appscript is it possible to extract how many people (with their names/user id) made how many changes(with what change) in a separate sheet tab. Just like how we see in 'show edit history'

[@nickdimuzio4629]

Thank you so much for all of your videos! I was wondering, is there a way for us to know in advance when you are going to do a live stream? Do you announce it somewhere?

[@ExcelGoogleSheets]

Yes. In youtube community posts or by singing up to email newsletter. The problem is that youtube only notifies very active subscribers only,

[@ExcelGoogleSheets]

To be honest with you, I'm not certain I'll be doing live stream again.

[@nickdimuzio4629]

@@ExcelGoogleSheets I'm sure you do repeat a lot of things in live streams which I'm sure can be annoying

[@ExcelGoogleSheets]

Repeat is not a problem. The issue is most questions I get make no sense. They sound similar to "Can you show me how to build a 100 story high-rise in 5 minutes? Keep in mind that I've never laid a brick in my life."

[@matthewoconnor1901]

as an aside. i think. spaces come from system preferences/keyboard 'add period with double spaces'. AND. Thank you for all your time

[@ExcelGoogleSheets]

👍

[@jdml3575]

Thank you!

[@ExcelGoogleSheets]

🙂

[@mohamed.montaser]

when do u do your live stream sir .. i didn't get the notification even so i checked the bell icon

[@jackhealy2341]

Hello, unrelated to this video, but I need help in VBA. Specifically, everyday I import a dataset into my file. I want to have a command that will autofill my formulas in columns A and B all the way down to the end of the dataset. If i did it manually, I would double click the square in the bottom right corner and it would fill all the way down. However, when I record the macro (I am not a very experienced developer), it lists the range as an actual cell. The problem is that my dataset's size changes every day. Sometimes it is 1500 rows, sometimes it is 1700. As you can imagine, this is problematic. I am looking for a way to autofill to the end of the range, which is variable. Is there a command that does this or will I need to do a work around? Please email me for your insight, I can compensate you for the effort. Thanks!

[@ExcelGoogleSheets]

kzbin.info/www/bejne/pHrPaKWGm5WffaM

[@AnyPossibleRandomThing]

Hi, do you have a video explaining how to send a message from google sheet to slack? OR cam you make a video of it, please? Thank you.

[@j53iliff2]

Thanks can you create objects by looping through data. For instance, if i had rows of student data and I wanted to loop through that data to create 100 student objects with their details. How can i loop through the data to build the objects?

[@김요한-o4p]

Teacher! I have made many web apps with apps script thanks to your videos. But a few hous ago, suddenly it shows this error in console. This document requires 'TrustedHTML' assignment. Uncaught TypeError: Failed to set the 'innerHTML' property on 'Element': This document requires 'TrustedHTML' assignment. and it stops. Is it something that Google changed its policy? I need urgent help. Please can you help me out?

[@mohamed.montaser]

also how to generate sequential numbers when you edit a cell, generating a number instead of a timestamp

[@ExcelGoogleSheets]

The easiest option would be to store the last number some place in the spreadsheet and then keep updating it to one higher with every change.

[@ingewll]

What about use and not use SPACE. I see you use space after console.log( .I would have tried ". And function {

[@ExcelGoogleSheets]

It's up to you, it doesn't do anything.