@@jsphpalumbo The only thing I can't figure out is how to connect a Wix database to a Google sheet so I can get the data over there automatically. Do you know how to do that? I've tried Integromat(make), but I keep getting errors.
hi Joseph, your videos are great but too much for me to process. I am looking for a script that will email my teachers based on selection from a google form. For example, if user selects course 1, then teacher 1 should receive the email, "hi this person sent a request" if user selects course 2 then email should be sent to teacher2. on activesheet sheet2 I have list of teachers and their email address. Can you post what it would look like? the trigger is based on "form submit".
Im struggling to find it. I can automate in excel but im wanting to share it in Google drive and excel sheets doesnt have it and i suspect thats why it doesnt work from there
around the middle, you run the logger and return the data - but you are still using current sheet, not raw_data. I accidentally changed sheets and it didnt work, thats how i noticed. I changed it to let dataRange = raw_data.getRange(1,1,10); and it worked (you have let DataRange = cs.getRange)
hi Joseph, your videos are great but too much for me to process. I am looking for a script that will email my teachers based on selection from a google form. For example, if user selects course 1, then teacher 1 should receive the email, "hi this person sent a request" if user selects course 2 then email should be sent to teacher2. on activesheet sheet2 I have list of teachers and their email address. Can you post what it would look like? the trigger is based on "form submit"
I just happened across this video in my recommended. EXACTLY what I need to automate reporting on my website. Thank you!!
Glad it helped, Sam. Let me know if there’s anything else you want to know.
@@jsphpalumbo The only thing I can't figure out is how to connect a Wix database to a Google sheet so I can get the data over there automatically. Do you know how to do that? I've tried Integromat(make), but I keep getting errors.
Love your radio announcer voice! Very clear presentation.
Ha, thanks @tombrazee
Absolutely perfect presentation with exactly the right amount of information to get started. Thank you!
Great introduction to using App Scripts in Google Sheets. Thank you for putting this up! :)
Fantastic - thank you very much for putting these together and your depth and stle of teaching/explaining takes the value to another level
Save my life bro, really helpful for my work
😀
Happy to help
Hi Joseph,
I have created a keypad in VBA for Excel and having trouble trying to duplicate this in Google sheets, can you assist?
Excellent presentation.
thank you!! really helful. can you make another vid about insert checkbox within submit button.
hi Joseph, your videos are great but too much for me to process. I am looking for a script that will email my teachers based on selection from a google form. For example, if user selects course 1, then teacher 1 should receive the email, "hi this person sent a request" if user selects course 2 then email should be sent to teacher2. on activesheet sheet2 I have list of teachers and their email address. Can you post what it would look like? the trigger is based on "form submit".
Im struggling to find it. I can automate in excel but im wanting to share it in Google drive and excel sheets doesnt have it and i suspect thats why it doesnt work from there
So helpfull... sir, I have some query can you help me to resolving that. that is similiar to this.
Thanks!
around the middle, you run the logger and return the data - but you are still using current sheet, not raw_data. I accidentally changed sheets and it didnt work, thats how i noticed. I changed it to let dataRange = raw_data.getRange(1,1,10); and it worked (you have let DataRange = cs.getRange)
hi Joseph, your videos are great but too much for me to process. I am looking for a script that will email my teachers based on selection from a google form. For example, if user selects course 1, then teacher 1 should receive the email, "hi this person sent a request" if user selects course 2 then email should be sent to teacher2. on activesheet sheet2 I have list of teachers and their email address. Can you post what it would look like? the trigger is based on "form submit"