Is there a way I can time this export to be done once a week?

I already found😀 { attachments: [pdf], bcc: '[email protected],[email protected].........' }

I like to use indexof or match to make dynamic ranges as intended within the code. it's harder but i'm trying to find a better method of streamlining and debugging it

Thank you!

😀What if we have 40 recipients?

is there a way to write speaker notes to google slides, fed by / from excel - google sheets etc. I really need this as bulk. how can I do it ? :)

Hi hi, is there a way to add speaker/presenter notes to google slides as bulk ? like with mail merge or with an addon or something ?

Can somebody confirm if there any way to not send the notification via email when we share the file via script?

I dont know if things simply changed in 2024, but I dont get all the windows at the bottom for the debugger. All I get is a panel at the right-hand side that says "variables" and it shows my variables with an arrow to expand, but expanding them only shows me the functions I can use on them. Expanding such a function will NOT show me any useful information. They all show length 0, name "", arguments null and caller null. For every single variable and every single function I have checked. You'd think that it would show the value in getValue, but no. I'm trying to script for the first time, all good tutorials are from years ago and I'm at my wit's end because my debugger doesn't look anywhere close to what the videos show 😢 I know a bit of Java so I'm figuring some simple things out at I go (and for those things the debugger also doesn't show anything useful), but just a tad more advanced is already not working, likely because I just dont know the correct functions/methods and perhaps syntax, I mean its a different language. But the debugger should help me figure out what DOES go right and where it goes wrong, so that I can properly look that up.... except it doesnt.

Very well!

👍

nice tutorials

hello, do you know api connector? do you use AI for coding? can I find "templates" ?

Great video! I’m curious how you could use this to execute a new version of a slide deck, so it will take a copy of the slide pack and make a new one? I’m trying to work on a templated solution using the sheets as the request document

It's super silly you can not send private chat messages in Google Meet if on a call with more then 2 people.

Well of course Google when all these other tech companies made it difficult where you can't just turn it off so we got to delete a whole email so nobody don't send us nothing on our spam email account I guess you're not helping at all

I feel like a buffoon right now, I didn't see the hidden bar xD. Thank you!!!

Suppose I am added to a shared drive and I am the manager there. Apart from that, there are no other members added; it's only me in there. Now, if I upload any files there, will anyone else have access to those files like being able to see them? Like the organization or someone above me? Or if im removed from accessing it? Note that there are no other members than me in that shared drive.

Very helpful! Thank you so much!

hello Can you help me understand if the ideas I had on my feasible

hello

You are awesome. Please make a Google app script video on "How to unmerge the entire spreadsheet's cells". I couldn't find something over internet.

Waiting also for new videos ='(😢😢😢

Waiting for new videos please

You are explanation is good 💯 👍 Can you create video of full javascript and Google apps script

Superb ma'am explanation We have beginners Can you explain each thing

Thank you for taking the time to make this video - super helpful

Hey I am not able to get the icon for some reason

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?

Awesome! Thank you so much!

Didn't work.

I am a total beginner and this was a terrific video. Such a calmed and clear explanation making it super easy to understand. Thanks!

HI. it didn't work for me. Its saying "getDataRange" is not a function

I'm Hyunjung Cho, a subscriber from South Korea. I've been watching your videos with great interest. Although I'm not a developer, I find Apps Script extremely fascinating. I'd like to dive deeper into studying Apps Script myself.

I didn't know that was a thing!! So helpful!! Are you going to keep posting? Miss your content!!

Could you please assist me with my issue? I need to transfer data from one Google Sheet to another. The complication arises because my source data contains columns in both French and English. For example, I need the "Name" column data to be copied into the "Nom" column in the target sheet. Similarly, the "Nom" column (French version) in the source data should also be copied into the "Nom" column in the target sheet. I would like to know if this is feasible.

Love your clear explanations - video is great. I just wanted to know if it should update automatically on the calendar every time you add an new event to the spreadsheet or is it a one off upload ? Mine doesnt seem to do it.

How would you handle event cancelations? Just tell people to decline the invite and re-submit the form for a new time or is there a better way to handle with scripts?

Hi regarding with that option between busy and free which one I’ll click? I created an event for my boss

I have no words to thank you; you've literally saved me hours. I've been searching for this function for a couple of weeks. Thank you so much!

how about if the row changes everytime how can we use it with getlast row

Amazing content, can you make one to setup sending Bulk mails or Merged mails. One that's personalized in bcc to each individual recipient so they're not seeing personal emails of others like in cc.. Thank you much 🤗

Hi! FYI now it's ; symbol instead of , symbol

You are a really amzing Teacher. I dont speak english well but I understand everything you teach. Congratulation

How to export as image

I am just starting to view your many resources (thank you!) I am needing a simple solution: I need to convert a range of cells (say D2:E10) that contain various three- or four-digit numbers into 24-hr time (830 to 08:30 or 1715 to 17:15) I would also like to make the cells change the number when entered (it is easier to enter the data on the number pad and not have to enter the ":" each time. I have seen this question out on the net quite a bit - so I thought I would ask you for a possible short? Many thanks!! Daniel

Hi ! Your tutorial is great! Everything is really clear and well explained accessible to an audience that doesn't know how to code. Thank you very much. One small question : is the table automatically synchronised? I mean, if you add an new date on the sheet, does it goes directly on the Google Calendar or do you need to execute the script manually each time you put a new entry? Also, do you know which formula is used for a event that goes all day ? Thank you very much and keep going this way!

How can i make it so the text "Yes" is in green color and "No" in red color, of course using if formula. And how can i make it so if the cell value is none it says "0", but when it changes to other value it says "Yes" or "No"

can I move the speaker notes to the side panel instead of bottom?

Thank you 🙌