Google Apps Script Code in Video Below: function doGet(e) { return HtmlService.createHtmlOutputFromFile('WebAppBoot'); } function AddRecord(firstname, lastname, street, city, state, zip, email) { var url = ''; //Paste URL of GOOGLE SHEET var ss= SpreadsheetApp.openByUrl(url); var webAppSheet = ss.getSheetByName("FORM DATA"); webAppSheet.appendRow([firstname, lastname, street, city, state, zip, email, new Date()]);
} HTML and Javascript Code in Video Below:
function AddRow() { var firstname = document.getElementById("firstname").value; var lastname = document.getElementById("lastname").value; var street = document.getElementById("street").value; var city = document.getElementById("city").value; var state = document.getElementById("state").value; var zip = document.getElementById("zip").value; var email = document.getElementById("email").value; if(firstname != '' && lastname != '' && street != '' && city != '' && state != '' && zip != '' && email != '') { google.script.run.AddRecord(firstname, lastname, street, city, state, zip, email); document.getElementById("firstname").value = ''; document.getElementById("lastname").value = ''; document.getElementById("street").value = ''; document.getElementById("city").value = ''; document.getElementById("state").value = ''; document.getElementById("zip").value = ''; document.getElementById("email").value = ''; document.getElementById("display_error").innerHTML = ""; } else { document.getElementById("display_error").innerHTML = "Please Enter All Information!"; } }
you know why you doing a very cool job? because atm are around internet a tons of platforms and frameworks to create apps or webpage etc but all those need to be installed with Visual Studio and are some procedure for them to work , then is the part that most of them are some how Pay to Create or Use. This way of creating from a script that is connected to spreadsheet and trasnform in a web app@html you just make 50% of work easy since i don't need to worry about all that.
Thanks you are a hero man it worked .... have an important and big question how to redirect someone who submitted the form to a new page after submit < let's say you embed it to Google Sites website Thanks a lot
Hi Kurt, awesome page. I was wondering if you have tutorial on how i can have a form that looksup on a googlesheet then shows the data that you have searched back on to the page after submitting. much like for package tracking and item look up. Would help heaps. Thanks! More success!
Hi Curt! I was wondering if you can help me get an understanding with a code. I'm using Google Forms script editor and I followed a video called "Google Forms - Email Notification Script - Send Confirmation Emails To Users" by another youtuber called Learn Google Spreadsheets. I did everything and that works fine. I found a code to send the respondents response in the email, but I inserted the code but it's not doing the action. I put it under the code that is able to send the confirmation email but it's showing "
Hello sir, thanks for uploading knowledgeable video, Sir, How to show "Your data has been saved on" + last row number" after successful submission. Thank u sir Vijayanand City gulbarga State Karnataka Region india
Where can I check the code , Curt? Sorry if I requested so much , but it's hard to follow the code from the screen. If you can , please share it with us.
@@CodeWithCurt i read every comment. Nothing to expand its possible google may be deleting them but they are not showing up on our end. On any of your videos.. maybe post them onto a google doc. Save to a google drive, fake acct is ok and share file via link. Just a suggestion.
Im seeing a total of 14 comments under this video including the replies. Mine, yours and others although UA-cam says there is 15 comments, im wondering maybe since its code google is maybe voiding it out
You would use the exec URL and link it in your website. If you want someone else to access your link then you would need to open up the access to the web app.
Google Apps Script Code in Video Below:
function doGet(e) {
return HtmlService.createHtmlOutputFromFile('WebAppBoot');
}
function AddRecord(firstname, lastname, street, city, state, zip, email) {
var url = ''; //Paste URL of GOOGLE SHEET
var ss= SpreadsheetApp.openByUrl(url);
var webAppSheet = ss.getSheetByName("FORM DATA");
webAppSheet.appendRow([firstname, lastname, street, city, state, zip, email, new Date()]);
}
HTML and Javascript Code in Video Below:
function AddRow()
{
var firstname = document.getElementById("firstname").value;
var lastname = document.getElementById("lastname").value;
var street = document.getElementById("street").value;
var city = document.getElementById("city").value;
var state = document.getElementById("state").value;
var zip = document.getElementById("zip").value;
var email = document.getElementById("email").value;
if(firstname != '' && lastname != '' && street != '' && city != '' && state != '' && zip != '' && email != '')
{
google.script.run.AddRecord(firstname, lastname, street, city, state, zip, email);
document.getElementById("firstname").value = '';
document.getElementById("lastname").value = '';
document.getElementById("street").value = '';
document.getElementById("city").value = '';
document.getElementById("state").value = '';
document.getElementById("zip").value = '';
document.getElementById("email").value = '';
document.getElementById("display_error").innerHTML = "";
}
else
{
document.getElementById("display_error").innerHTML = "Please Enter All Information!";
}
}
First Name
Last Name
Street
City
State
Zip
Email
I copied the code, sir and try to modify it and success. Thank you very much. May God always bless you. I follow your channel..
Fantastic tutorial. Very easy to understand. Thanks!! Now on to the CRUD tutorial.
you know why you doing a very cool job? because atm are around internet a tons of platforms and frameworks to create apps or webpage etc but all those need to be installed with Visual Studio and are some procedure for them to work , then is the part that most of them are some how Pay to Create or Use. This way of creating from a script that is connected to spreadsheet and trasnform in a web app@html you just make 50% of work easy since i don't need to worry about all that.
Thank you very much man.. keep up the good work 👍👍👍
Looking at options for static sites and forms. I suppose an is the only way to embed this form in an external html page? Thanks for the tutorial.
Thanks you are a hero man it worked .... have an important and big question how to redirect someone who submitted the form to a new page after submit < let's say you embed it to Google Sites website Thanks a lot
Hi Kurt, awesome page. I was wondering if you have tutorial on how i can have a form that looksup on a googlesheet then shows the data that you have searched back on to the page after submitting. much like for package tracking and item look up. Would help heaps. Thanks! More success!
Can it add the geocode (longitude and latitude) and address on the spreadsheet when Submit is clicked?
Really like this video but is it posible to make dependent dropdown at city and state coloum?
This is awesome!
My new row that needs to be populated will start at A8. How do you append a new row at A8 then?
Hello sir very helpful video for me.thank u but sir my sumbit button not work..so i did not put data into my sheet.. please help about that
Hi Curt! I was wondering if you can help me get an understanding with a code. I'm using Google Forms script editor and I followed a video called "Google Forms - Email Notification Script - Send Confirmation Emails To Users" by another youtuber called Learn Google Spreadsheets. I did everything and that works fine. I found a code to send the respondents response in the email, but I inserted the code but it's not doing the action. I put it under the code that is able to send the confirmation email but it's showing "
Hi. When you click Submit button.How to create go to link browser External ?
Sir please create add or remove multiple input fields in google script
Looking for option to upload file in this web app form
Hi, how to save this form as pdf? Can you please help me with that?
Perfect
greate work
Sir how to create submit after redirect form using google webapp script
how do we add radio button in this form?
Why me write Uncaught InvalidArgumentError: Failed due to illegal value in property: 3?
Can we make this type of form in paython with app script
Hello sir, thanks for uploading knowledgeable video,
Sir,
How to show "Your data has been saved on" + last row number" after successful submission.
Thank u sir
Vijayanand
City gulbarga
State Karnataka
Region india
"Next I'm going to going to copy in my google app script code" 1:54 ...where did you copy this from?
Where can I check the code , Curt? Sorry if I requested so much , but it's hard to follow the code from the screen. If you can , please share it with us.
I posted the code in the comments section of the video.
@@CodeWithCurt Where in the comments section? I can't see it.
@@abhinavjuyal6371 The comment starts with 'Google Apps Script'. You need to click Read More to see it all.
how do I add this to my website?
Hi i m not able to find the code
it worked yesterday not working today? did google update something?
Error says, We're sorry, a server error occurred while reading from storage. Error code INTERNAL
IM not seeing the code you copied in comments??
It should be the first comment of the video. You can expand it by clicking Read more.
@@CodeWithCurt i read every comment. Nothing to expand its possible google may be deleting them but they are not showing up on our end. On any of your videos.. maybe post them onto a google doc. Save to a google drive, fake acct is ok and share file via link. Just a suggestion.
Im seeing a total of 14 comments under this video including the replies. Mine, yours and others although UA-cam says there is 15 comments, im wondering maybe since its code google is maybe voiding it out
In the comments section, try clicking on 'SORT BY' then clicking 'NEWEST FIRST' and see if they show up.
That worked thx! It showed up on bottom after sorting newest 1st
can you do this on a showModalDialog ?
how do i deploy on my own website?
You would use the exec URL and link it in your website. If you want someone else to access your link then you would need to open up the access to the web app.