Відео

Any reason to this this instead of using Object.assign()?

Mil gracias, sus conocimientos me están ayudando a comprender más el complejo mundo de la programación

Hey!! thank you for this video! I am looking to identify certain "Flag" or "Placeholder" and then add the paragraph in that place. How do I do this or what function do you suggest I should be using?

Hey, first thank you for the video this was exactly what i was looking for but if had to give a feed back it would be, please try to explain the code while you're writting it rather than explaining it at the end of the video. Great video !

Maybe this is doing something cleverer than I realise? It seems an awfully complex way to just to automatically identify the range a given number sits within? Isn't there just one line of code we can put in the function bar, tweak to define the ranges and highlight relevant spreadsheet columns?

Is there a simple way to refine the search for messages that were received today or perhaps within the last 24 hours?

Following your video and when I recreate it and execute either in debug or using a URL the messge says the script complete but did not return anything. No window opens.. Execution log shows start and end. I am assuming I do not need to have any HTML files open becasue I se no reference to any so assume a new browser window should open.

Thank you greatfully. This is help me to finish my work.

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

browsers don't allow fetching of local json files??? how do you overcome this basic problem??

So I gather this code is in the sheets script associated with the link ss tied to the form. I was trying to do onFormSubmit in the form itself and not working and scripting with FORMS leaves a lot that can't be done. Anyhow what I want to do is add some data to another sheet not in the default ss and manipulate there. I assume rather than writing to the new sheet you created for logs I could open a second google sheet and work with that one. So the trigger is on the linked sheet because that is the active sheet tied to form submission and then you use a google sheets trigger, not a form trigger. This is all new to me and not like my Excel VBA experience.

Today i learned that there IS in fact a function to check if a string has a numerical value, would've saved young me the headache of creating mass function to solve a simple problem lol

I can't get past the cors issue. I run the script on my local machine (browser opens the local index.html which loads the sheets.js file). The targeted Google Sheets is shared for anyone with the link. I receive this error: "Access to fetch at [url] from origin 'null' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource." If I use the fetch with 'no-cors' mode, it doesn't return anything (response.ok == false). Any ideas how to solve this issue and get access to the Google Sheets? Thanks.

@LaurenceSvekisCourses I am reaching out to discuss an exciting business proposition regarding your Udemy course. Our aim is to enhance the visibility of your course, increase sales, expand your student audience, and cultivate positive reviews. I am eager to explore potential collaboration opportunities with you to achieve these objectives. Looking forward to the possibility of working together.

Hello, could you help me understand if my ideas are feasible?

what if i want every new doc created to be saved as a pdf?

where is the link for the code for this?

does it automatically send to email?

Omg there's a 'insertSheetsChartAsImage' method? I wish I'd known that 2 days ago.

hello I thought that appscript is only used to connect an API to it? but in fact it's more than that?

hello do you know the extension that allows you to add APIs to Google sheets?

Just put the negative sign "-" in the formula, =PMT(C3/12,B3,-A3,D3), so u dont have to pu negative principle amount

sir, why are you using light theme? following a course with light theme is tough, when you use dark , you know...

Hi Laurence, great explanation! I've been watching several video of yours regarding Apps Script tutorial to integrate data between Google Suite apps. Thank you for the hard work. By the way, I have another question, do you happen to know how would I copy the bullet lists to a certain placeholder? Thanks in advance.

How do you include bcc and cc?

Very clear

Thank you 🤝

Hello sir, why file pdf isblank from sheet template ,the template fill data from sheet

Спасибо!

how does the script reconnect the google form with the spreadsheet on the original sheet

why does email address not show up execution logfunction mySquarespaceFunction4(){ var authInfo = ScriptApp.getAuthorizationInfo(ScriptApp.AuthMode.FULL); Logger.log(authInfo.getAuthorizationStatus()); //Log the authorization status (REQUIRED or NOT_REQUIRED) const email = Session.getActiveUser.getEmail; //const email = Session.getEffectiveUser.getEmail; Logger.log('bubbakingofbbq'); const id = '1PKG0WlYOhQ40kSq9oMiG50L19r-r82CvSnJDFxD94Fv1xiUq_QtBFlwN'; const doc = DocumentApp.create('Test2'); const body = doc.getBody(); let emailContent = body.editAsText().getText(); Logger.log(doc.getName()); //doc.setName('my email doc'); const subject = doc.getName(); const url = doc.getUrl(); emailContent += '' + url; GmailApp.sendEmail('bubbakingofbbq@gmail.com','whatTheF', 'shittyResults'); Logger.log(email);

Hello Sir, How to replace text with QR from URL?

Hello Sir, how to replace text on google docs with image from url using apps script?

Awesome video😎😎👍👍

37:00 (my pinned)

Thank you for this video. I have no coding experience and this made it very easy to follow and write the code I need.

how can i submit the response by appps script?

good job, but: TypeError: current.getFiles is not a function 🕵‍♂

if I have an external email from hostinger, can I use this function? and how?

When I don’t run a script directly from the code editor (for example adding a button in google sheets that runs a function) I can’t see the log at all. It’s neither in the execution log, nor is it in the console you can find by using inspect element. Thanks in advance.

I'm trying to tie this to a form so that the email from the sheets goes out upon form submission. Is there simple code to add to sheets or should I start over and code the form?

Thanks for your amazing work. How can I add the owner (who created the file) information as a column?

Above and beyond Thank you a million !!!

please i want code to make dirction left to right

how make page language dirction ltr or rtl by programming

Awesome tutorial!! Please help me take it one step further. How can i automate a follow-up email sent to an email in column 2 in 3 months time based on the date in column 4?

Great tutorials! I have learned a lot. Do you have or would you consider making a video for converting date and time to UTC?

Help! I keep getting a TypeError: responses.forEach is not a function.

how to insert a json file from the web taken with fetch api / UrlFetchApp google script into the html dropdown input in google app script, and the input is in the form of a dependent dropdown from province, district, sub-district, village... please make a tutorial

Hello, I am trying to automate a template using a spreadsheet but I seem to be having issues populating multiple fields. I am able to body.replaceText once but when I try to add the others it won't work. How do I know which row number to use? thank you. Example: body.replaceText('{Employee Name}',row[1]) body.replaceText('{Field 2}',row[?]); body.replaceText('{Field 3}',row[?]);