วีดีโอ

can you make video that when you have all this data make in wordpress the chat gpt automate the changes?

Notes from the Video 1. Use Limit, If you are viewing the data (Table) for the first time. 2. Use Group by, to segment out a few aspects (Variables) & understand it better like Count 3. Use numerical to refer to the columns in Group by & Order by clauses. 4. For fuzzy Search use like & = instead of '=' 5. Use the Escaping key to search for ' words with ' = E'specific_word\'S' 6. Converting Date Format like to_char(date:: date, 'Mon YYYY') Thank you for the content 🥰

please tutorial side bar with search and edit, Sir

Can you paste a link of yours so I can copy it?

Thank you so much. I am trying to use one item recorded on to the google sheet to populate another question dropdown. in the same google form. Pl let me know how can I do it.

This is exactly what I need! I am having an issue... my worksheet question is "Select incident", I copied your code exactly but didn't change anything to match the question. I am getting an error at line 22 "ReferenceError: interviewer_question is not defined".

Great video, I am not a programmer at all and I was able to follow what you did successfully. I was hoping that this video would help me send the information from the form to a recipient. Basically, a person in a network giving another person feedback using google forms, and that person getting notified about the things they said in the form. Is this something easy to include?

This was extremely helpful! Do you know if there is a way to add multiple emails for each case? I tried email "email1" on one line and email = "email2" on the next but it didn't work. Any suggestions?

Programming is superpower!

Updated link for the source code: products.bootstrapping.tools/products/search-console-automation-b 🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉

Hi, I need to access Google Photos Library in apps Script using OAuth2.0 please help 🙏🙏🙏 Thank You

Is there a possibility to check if they have replied to email and stop the automation?

Hi! This is great! The spreadsheet that I want to take snapshots of has multiple tabs--how would I need to alter the code so that the spreadsheet "log" that is generated contains all the tabs of the original? Bonus points if this can be done dynamically--so it automatically captures any new tabs that are created.

Hi. I haven't seen the code yet, but a few questions before. Can the script be modified so it brings back the clicks and impressions on all the pages of the site and only the principal? Do I need the clients ID and Secret Key? Thanks.

Awesome video! Curious if we could retrieve the snapshot using a date and overwrite it on your main sheet?

I want that when we select the userName, the email should automatically appear in the Email field.

I want that when we select the userName, the email should automatically appear in the Email field.

Nice working bro but... Every time I searched for this title but in return these app scripts are helpful but I'm fedup because I'm not technically sound for app scripts, so what is the easy alternative? Thanks

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉 Get the code here: - Revised Source Code + Auto-setup of the daily scheduled job trigger: products.bootstrapping.tools/products/google-sheets-automated-snapshots - Revised Source Code + Auto-setup AND auto-email notifications: products.bootstrapping.tools/products/google-sheets-automated-snapshots-b

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉 Get the Source Code from this video here: products.bootstrapping.tools/products/dependent-drop-downs-in-sheets-a

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉 I also released a new video that covers Drip Campaigns (aka email sequences) - check it out here: th-cam.com/video/Oej2jPut07Q/w-d-xo.html

🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉 🧑🏻‍💻Download the Source Code and the Setup Guide here: products.bootstrapping.tools/products/drip-campaigns-via-google-sheets-b 💻or if you're an Apps Script veteran, here's a link to just the Source Code: products.bootstrapping.tools/products/drip-campaigns-via-google-sheets-a

This was exactly what I needed. Thank you!

I am unable to get the named_values to work but the values did. The email is in position one. What would it look like instead of writing "What\'s your email?" in the code? Would it be $1 in its place?

THanks for this!! But I have a problem. I'm using 2 Form questions that pull from the same list of choices in column A. I simply "duplicated" question 1 to create question 2. I don't know why, but changes to the list only show up for question 1, not question 2. Is there something I need to add to have it update both question lists?? THanks!

This is awesome and perfect for tracking stuff in my D&D campaign! Similar to @yngrco (I think) I would like to know how to keep base data on the TOC page. I imagine that instead of removing the grid we do something else but I don't know what. I would like to keep an image on the TOC and a title so I only want to replace and add to everything below that point. Is this possible with REMOVE_ROW or is there an easier way?

Hello! Thank you for this video, sad I am just checking this now. am getting an error on the conversations part. channel.id - the error is "id is undefined" would you know how to go around this?

This is clearly essential for huge sets of worksheets, however, the page link approach can be much faster for navigating small number of pages. for a small number of tabs under, say 15-20 or so it is faster to link to pages or cells directly, but once coded you can reuse the code. And agree it's best to create a link back to your guide or ToC page on each sheet.

Thank you so much for this tutorial! Just a short tip for the rest of the people over there: if you have more than 100 records you can get them by changing the requestAirtableData() function like this: function requestAirtableData() { var url = 'XXXX'; var api_key = 'XXXX'; var headers = { 'Authorization': 'Bearer ' + api_key, 'Content-Type': 'application/json' }; var options = { headers: headers, method: 'GET' }; var allRecords = []; var offset = ''; do { var response = UrlFetchApp.fetch(url + '?offset=' + offset, options); var data = JSON.parse(response.getContentText()); allRecords = allRecords.concat(data.records); offset = data.offset; } while (offset); return allRecords; }

Super useful video. Thanks a lot!

Hey this seemed to execute without any errors but nothing imported into my form. Is this now a known problem with this code?

This is outstanding! I made the donation and am working with the code. As a newb to app script, I’m struggling. So I have a couple questions: I put this in the app script for the form, replaced the id codes in the ‘getsettings’ function with the relevant ids from the web addresses (from edit mode for the form), ran each function, and am getting an Error for ‘getType’. It says, “TypeError: Cannot read properties of undefined (reading ‘getType’).” What am I missing? Second question; one of my favorite app scripts is to add edit urls. So far as I can tell it’s a popular one for the layman. Since it’s applied in the app script for the destination spreadsheet instead of the app script for the form, it’ll still work, right? Thanks in advance!

감사합니다

Can we do follow ups?

is it possible to send a google form for answering simple question yes or no with a gmail account. I trying from the google form directly but only allowed 20 to send. I am looking to send 500, I will be able to split up into two separate emails. This email list I have is from a separate exel list.

It worked! You saved me from a bunch of crappy subscription services :)

Hi what if its a multiple choice not drop down?

This is awesome... Thank you. This is a great head start for me ... Now to try to figure out how to put the responses into a format in the email.

Very useful ,can you provide coding

Hey Dude Can you help Me I need your Help ?

ScriptProperties is no longer valid, what to use instead of this Class?

Hello! Please I hope you can help me, I can’t get the codes to work: I am working on contracts, where if they meet a certain date (say contract expiration, or 30 days before due ,or 60 days) then custom alert email will be sent to team members once criteria is met. I don’t know if the loop or the if statement is the error here.

I’m a teacher and want to do fail notice with this so for example first question would be the class period in day then have the names pop up for them and then send fail email to them and parents I wonder if can be done