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.
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!
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 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 "
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
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
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 👍👍👍
This is awesome!
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.
Really like this video but is it posible to make dependent dropdown at city and state coloum?
Can it add the geocode (longitude and latitude) and address on the spreadsheet when Submit is clicked?
My new row that needs to be populated will start at A8. How do you append a new row at A8 then?
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!
Looking for option to upload file in this web app form
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. When you click Submit button.How to create go to link browser External ?
greate work
how do we add radio button in this form?
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
how do I add this to my website?
Hi, how to save this form as pdf? Can you please help me with 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 "
Perfect
Can we make this type of form in paython with app script
"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.
Sir how to create submit after redirect form using google webapp script
Hi i m not able to find the code
Sir please create add or remove multiple input fields in google script
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
Why me write Uncaught InvalidArgumentError: Failed due to illegal value in property: 3?
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
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
can you do this on a showModalDialog ?