วีดีโอ

Hi Laurence, I need some course where I can learn to query if a specific date is not empty because I already have registered an event previously. All this using Google Calendar API. Do you have this kind of course?

I can never get the 3rd button to give me output I am boggled?

I keep getting an error saying curriedAdd is not a function.

It doesn't work, says "Unknown function: 'COMPOUND_INTEREST'.". I see that in your screenshot as you're typing but somehow it works. Edit: Had to press Save, run doesn't save it.

Thanks for taking the time to make this content!

Thanks. If I wanted to create the list of items from a single column table in a Google Sheet Doc, how do I do that?

hello Laurence. nice Tutorial.can i used ONE DRIVE instead of googel drive? for this tutorial?

Just let chatgpt make the source code then you're good to go bro

Hello. Sorry, I need help! At 6:17 "the value of F12" we jump from two rows to four for some reason? Can you PLEASE tell me how and /what you did? Also- probably related: but I can only drag/advance one row at a time in any given column. For instance I can drag row two to row three and get an accurate new balance; but if I drag from two through three and end on four I get 0 in the cell? I am new to sheets so feel free to dumb it down if you're able to answer.

Thank you so much. I struggled a little bit, but it worth it.

Very nice, I like your way

This would be perfect for me, but I keep getting an error in line 3: ReferenceError: numGrades is not defined I am not sure what I did wrong; I followed the directions exactly.

It is amazing. You have save a lot of time. God bless you man.

this is an expertly-made tutorial, great one!

Te veo desde México y solo me queda agradecerte por tu buen trabajo, bendiciones.

Can I get it in writing.....so I can write it down.

This is great, after a lot of testing I think I ran into the 100 emails a day limit, then it gives the cors errors again. It took me a while to figure this out.

nice work but is there any way to display created files in a google web app table?

this video is very helpful, thank you🙏🙏

Perfect!

i got an error: TypeError: Cannot read properties of undefined (reading 'source')

A Google NotebookLM conversation

Thanks!! I'm learning how to work on Apps Script and this has helped me.

Hey Laurence, great content. Question, Is it possible to copy data from a cell in column C to column M (column C is showing an image through a dynamic URL, so it's not a typical jpeg or png ending but Google Sheets is able to read the dynamic URL and still display the image properly. Since all the rows in column C have the same code, the image will only show if the streamer is live)? I'm currently using Google Apps Script for this. The end goal here is if the streamer is live, the row will turn green and if offline, it will be gray. I am driving my colour based on if an image is present or not. Any help will be appreciated, thanks!

Hi, all works for me from any navigator but when I try to run the webhook from the same appscript project some error occurs, like they miss an OAuth2 access or something like this. How can I run the doGet outside gmail environment? At deploy screen the Anyone option are missing.

I don't know what half of what I just typed is but it worked thank you!!

Hi Can we call the backend api and get the id of presentation and load that presentation in same google slides ?

I did this but for some reason it isn't generating an email. I set the trigger and nothing has been received although I see that it says it was on the trigger history.

Hello

Hello its really nice your work! Thanks! i managed to get the json but i have a CORS error, how do you configure the CORS to fetch appscript from a webapp?

This is definitely _not_ written to the Promise A+ spec, which is what the native Promise implements. For instance, I believe Promise does not use iteration at all. Rather, its then method sets the promise's state as the return of your fulfilled handler, wrapped in a new Promise whose state is resolved to the previously set state of the currently resolved promise. Something like that. And same for catch and finally. I'll take the video for what it's worth but I'm not sure how it helps me. What I would **love** to see you do is _inherit_ from Promise and do something really useful and cool with that. Here's an idea... You know how setting an element's innerHTML is actually an async op in webkit? That's why, if you set a huge string/fragment and on the next line try to querySelector it's children, you get back null. Well, you can leverage Exponential Backoff on the query selection to dispatch an event when it's finally part of the DOM. I wanna see a class that inherits from Promise, takes a parent node, and resolves when the children are attached. In fact, you can use MutationObserver instead of Exponential Backoff. Then you can just debounce the mutation handler so it resolves when no more children are being added, or throws once it reaches a timeout threshold. Makes me wonder what other things you could solve by inheriting from Promise.

Can you just copy and paste this? I tried following along and it's way too fast and I somehow started off strong but got errors toward the end that I couldn't figure out how to fix.

thanks 👍

hello mr.laurence, i want to learn how to make a website using google sheets and app script, type web blog and landing page. is it possible?

poor tutorial

Google AppScript is buggy, so please be sure to rely on it at your own risk. Nevertheless, Laurence is doing a very nice job... thank you for all you do.

Thanks a million!

cool video! i wish i understood it better but i will keep working on it!

Thanks a lot! :)

🙋Köszönöm!

I am getting the cors error.Anyone resolve it?

Awesome content, greatly appreciated! Liked and subbed

How can we get full information of ip address using javascript

Nice 👍🏻

Thanku Sir for creating these videos .I am learning through these.

Thank you for the video! It is really helpful! 👍 Is there any way that I could attach image in the email? Thank you.

Great video. Would it be possible to change the floating image in part one for another using your script

how do I see the log of the script when I launch it from the webpage in the browser, instead of from the console?

I waw wondering : is there a way to use the doGet route to get HTML page from GAS, including a form to perform a POST request to a doPost method ? I'm currently facing an issue because of the different s the GAS returns along with HTML. Any workaround for that ?

hello I don't understand the code at all, I asked gpt to make me some code and it is unable to correct it because it doesn't work, could I show you what it did to me