Is there a simple way to refine the search for messages that were received today or perhaps within the last 24 hours?
@malcolmsokol42942 күн бұрын
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.
@praditleelanimit31532 күн бұрын
Thank you greatfully. This is help me to finish my work.
@chrisder18143 күн бұрын
hello, do you know api connector? do you use AI for coding? can I find "templates" ?
@HariTheHelper4 күн бұрын
browsers don't allow fetching of local json files??? how do you overcome this basic problem??
@HariTheHelper4 күн бұрын
On reflection it seems that you are using a local server!
@malcolmsokol42944 күн бұрын
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.
@cinnaminwolf43545 күн бұрын
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
@MuratUzman6 күн бұрын
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.
@adegunloyerebecca26719 күн бұрын
@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.
@chrisder181410 күн бұрын
Hello, could you help me understand if my ideas are feasible?
@iskojc357412 күн бұрын
what if i want every new doc created to be saved as a pdf?
@ParidhiUPSC12 күн бұрын
where is the link for the code for this?
@yaniadam13 күн бұрын
does it automatically send to email?
@richardnorris925620 күн бұрын
Omg there's a 'insertSheetsChartAsImage' method? I wish I'd known that 2 days ago.
@chrisder181421 күн бұрын
hello I thought that appscript is only used to connect an API to it? but in fact it's more than that?
@chrisder181421 күн бұрын
hello do you know the extension that allows you to add APIs to Google sheets?
@thekarandeep00722 күн бұрын
Just put the negative sign "-" in the formula, =PMT(C3/12,B3,-A3,D3), so u dont have to pu negative principle amount
@sma_bari22 күн бұрын
sir, why are you using light theme? following a course with light theme is tough, when you use dark , you know...
@JasonRiadyZelin23 күн бұрын
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.
@jjc653029 күн бұрын
How do you include bcc and cc?
@user-tf5ew6mz1wАй бұрын
Very clear
@barrosoolivАй бұрын
Thank you 🤝
@masbromw3880Ай бұрын
Hello sir, why file pdf isblank from sheet template ,the template fill data from sheet
@FioraAbbingtonАй бұрын
Спасибо!
@EndroPoraАй бұрын
how does the script reconnect the google form with the spreadsheet on the original sheet
@randpetersen906Ай бұрын
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('[email protected]','whatTheF', 'shittyResults'); Logger.log(email);
@masbromw3880Ай бұрын
Hello Sir, How to replace text with QR from URL?
@masbromw3880Ай бұрын
Hello Sir, how to replace text on google docs with image from url using apps script?
@AhmedRaza-ty7zqАй бұрын
Awesome video😎😎👍👍
@SwoOopy2 ай бұрын
37:00 (my pinned)
@amymcintosh38792 ай бұрын
Thank you for this video. I have no coding experience and this made it very easy to follow and write the code I need.
@amymcintosh38792 ай бұрын
I was wondering if you had any videos on how to automatically populate the yes/no column if someone signed in or not. I have made a google form and link this to sheet which works for people who have attended but I'm not sure if it would be possible to make a system that picks up if someone's name doesn't appear on the sheet and automatically puts a 'no' next to their name
@sheikhsadi7682 ай бұрын
how can i submit the response by appps script?
@biuromegadesign2 ай бұрын
good job, but: TypeError: current.getFiles is not a function 🕵♂
@ChristianDG212 ай бұрын
if I have an external email from hostinger, can I use this function? and how?
@m200h22 ай бұрын
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.
@vegasrunaway2 ай бұрын
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?
@nisaesinify2 ай бұрын
Thanks for your amazing work. How can I add the owner (who created the file) information as a column?
@ivanoleksii2842 ай бұрын
Above and beyond Thank you a million !!!
@ahmedfathy69842 ай бұрын
please i want code to make dirction left to right
@ahmedfathy69843 ай бұрын
how make page language dirction ltr or rtl by programming
@scubacentresodwanabay15313 ай бұрын
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?
@nicko55663 ай бұрын
Great tutorials! I have learned a lot. Do you have or would you consider making a video for converting date and time to UTC?
@vegasrunaway3 ай бұрын
Help! I keep getting a TypeError: responses.forEach is not a function.
@r.bd_mamiks79873 ай бұрын
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
@LaurenceSentieri3 ай бұрын
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[?]);
@ornellaluna71283 ай бұрын
Excellent explanation, super clear. It's just I needed it. Thank you!
@DevLearn-lv7nr3 ай бұрын
Laurence can the web app be located on any server and have nothing to do with the google eco system ?
@maartenmtr30223 ай бұрын
thank you, can you use the same method to convert pdf to google doc ? (other way around). Preferable with OCR enabled? Thank you!
@AdrianDITTMAIER2 ай бұрын
Yes this is possible. However the result might not be very satisfying. PDF->Doc conversion is messing with pictures coloures and formats.
@saikat_is_here3 ай бұрын
but I need to know the distances from my current location to multiple GPS coordinates.
@billfrug3 ай бұрын
How to run a script function as a formula in sheet?