Create Bootstrap Web App Form on Google Sheets using Google Apps Script

[@PenaChannel1987]

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..

[@JohnH-kr4gg]

Fantastic tutorial. Very easy to understand. Thanks!! Now on to the CRUD tutorial.

[@CodeWithCurt]

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

[@fokozuynen2048]

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.

[@calvincrane]

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.

[@enshoes7378]

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!

[@lendypradhana4744]

Thank you very much man.. keep up the good work 👍👍👍

[@tukangdleming4786]

Really like this video but is it posible to make dependent dropdown at city and state coloum?

[@coreymccall2963]

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 "

[@sinarrejekibaru5160]

Can it add the geocode (longitude and latitude) and address on the spreadsheet when Submit is clicked?

[@relaxingsounds7256]

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

[@aumaummizz2951]

Hi. When you click Submit button.How to create go to link browser External ?

[@LieNuk]

Looking for option to upload file in this web app form

[@jailbirdx0x]

My new row that needs to be populated will start at A8. How do you append a new row at A8 then?

[@Rustamkhan-pk2kh]

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

[@wahiatasnim5758]

Hi, how to save this form as pdf? Can you please help me with that?

[@RakuenKnight]

how do I add this to my website?

[@manojrana6723]

Can we make this type of form in paython with app script

[@mayursawant7992]

Sir how to create submit after redirect form using google webapp script

[@ТарасБабіч-р8я]

Why me write Uncaught InvalidArgumentError: Failed due to illegal value in property: 3?

[@thetpaingmyo9077]

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 posted the code in the comments section of the video.

[@abhinavjuyal6371]

@@CodeWithCurt Where in the comments section? I can't see it.

[@CodeWithCurt]

@@abhinavjuyal6371 The comment starts with 'Google Apps Script'. You need to click Read More to see it all.

[@imtisunuplongchar6090]

how do we add radio button in this form?

[@macporton5953]

This is awesome!

[@sanahaskuranage8071]

it worked yesterday not working today? did google update something?

[@sanahaskuranage8071]

Error says, We're sorry, a server error occurred while reading from storage. Error code INTERNAL

[@rafisir2679]

Sir please create add or remove multiple input fields in google script

[@ictwithvimu]

greate work

[@NeerajKumar-qj6nc]

Hi i m not able to find the code

[@vijayananddarbi2943]

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

[@ME550]

Perfect

[@benjobluemusic]

"Next I'm going to going to copy in my google app script code" 1:54 ...where did you copy this from?

[@bobburanich3262]

IM not seeing the code you copied in comments??

[@CodeWithCurt]

It should be the first comment of the video. You can expand it by clicking Read more.

[@bobburanich3262]

@@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.

[@bobburanich3262]

Im seeing a total of 14 comments under this video including the replies. Mine, yours and others although RUclips says there is 15 comments, im wondering maybe since its code google is maybe voiding it out

[@CodeWithCurt]

In the comments section, try clicking on 'SORT BY' then clicking 'NEWEST FIRST' and see if they show up.

[@bobburanich3262]

That worked thx! It showed up on bottom after sorting newest 1st

[@jcheng1981]

can you do this on a showModalDialog ?

[@harryshaw5360]

how do i deploy on my own website?

[@CodeWithCurt]

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.