I have a entry from created in sheet that i want to share to 10 user, so i duplicate the usersheet to 10 separate spreadsheet. I wanna to make a web form login, that if User A login it goes to A spreadsheet so on So the form is just a gateway to another sheet. Can it possible?
Sir how to modify these form by submited then redirect other page/landing page sir...please sir tell me.. and sir only ask form name, email, and number and one thing form supported to google sites
Can you attach the PDF files to the form and save them in the G Drive under the created subdirectory {{Username}} from the form, saving the clients' contact data in the fields of the Sheet? Thank you.
Hello. Thank you very much for the information you have given. I wanted to know; Once we fill out the form and send it, we can only print it on the 1st line. Is it possible to print this in a few lines? For example, a person has 3 phone numbers. I want to write these numbers sub-bottom. Is this possible ?
Boss how to post multi input fields data in multi-row in one column at a time by one clicking? example: column is "materials" ---items are "shoe, t-shirt, jacket, and so on.
Thank you for the tutorial. It would be interesting if you put your first name, last name and in addition to geolocate your location latitude and longitude and transfer all that to the Google Sheets, can you do it?
I would put the First-Last Name labels within their own tags too. I don't know how putting the entire line in a paragraph tag affects it completely. Most likely stacks them on top of each other instead of being side by side but it should work. Example: First Name:
function AddRow() { var firstname = document.getElementById("firstname").value; var lastname = document.getElementById("lastname").value; google.script.run.AddRecord(firstname, lastname); document.getElementById("firstname").value = ''; document.getElementById("lastname").value = ''; } I should mention that I haven't run any of this code yet.
Thank you for the tutorial. Do you have a video on how to extract checkboxes values from each row and update those checkboxes values to the assigned ID into Google Sheets. Below is an example of HTML table from Web App (the table values 'ID' & 'Name' are extracted from Google Sheets) ID Name Q1 Q2 Q3 Q4 1 John checkbox1 checkbox2 checkbox3 checkbox4 2 Helen checkbox1 checkbox2 checkbox3 checkbox4 3 Pete checkbox1 checkbox2 checkbox3 checkbox4
I am having an issue with the onclick working, it doesn't seem to be triggering anything in the published Web App, any help would be appreciated. Everything else works great and was easy to follow
I posted the HTML and Javascript Code in the Video. It is in the public comment. Make sure the URL in the google script code is the exact URL to the google sheet you are wanting to copy to. Also, make sure the sheet name in the script code matches the one on the google sheet. I hope this helps.
Dear Curt, Great material! I wonder if you think it'd be possible - if it's legal at all - to create a google web app and rent out the solution by granting access to a 3rd party without them having the possibility to duplicate the app and start using on their own. If yes, I also wonder if it's possible to create pdfs with a press of a button within the app, to which the user would have access via a shared folder and get it somehow email it to their customer by a couple of clicks. Thanks in advance for your answer!
how to search a particular record from HTML page by Id or Name in googlesheet , html form with text box and search button searching record in Google sheet, Thanking you Lots
superb u rock man, pls help I just want the reverse of this , Data from GoogleSheet being displayed on HTML page one row at a time with next and prev button on html page . Data on spread sheet contains Name , Age , Photograph
Greetings from Venezuela. Today I have learned more than in college years.
Thanks. I hope to do all the videos of the channel.
Amazing! Gave me the building blocks to update my finance tracker easily.
Its 1yr ago published this video.. But it helps me a lot now...
Hi. Followed your video exactly but when I paste the url to go to my web app the page is blank… what could be the problem?
Is it possible to reload the page after submitting the answers? How to do it?
HTML and Javascript Code in Video:
function AddRow()
{
var firstname = document.getElementById("firstname").value;
var lastname = document.getElementById("lastname").value;
google.script.run.AddRecord(firstname, lastname);
document.getElementById("firstname").value = '';
document.getElementById("lastname").value = '';
}
First Name:
Second Name:
Great information. thank you
Where did you use the AddRecord() function in your HTML file???
Thank you this was very helpful!!
Hello.., can we do something like.. for the first name at colum B2 NOT starting at A1? By default it at A1 right
I have a entry from created in sheet that i want to share to 10 user, so i duplicate the usersheet to 10 separate spreadsheet.
I wanna to make a web form login, that if User A login it goes to A spreadsheet so on
So the form is just a gateway to another sheet.
Can it possible?
Sir how to modify these form by submited then redirect other page/landing page sir...please sir tell me.. and sir only ask form name, email, and number and one thing form supported to google sites
Does it work for the new IDE ?
Can you attach the PDF files to the form and save them in the G Drive under the created subdirectory {{Username}} from the form, saving the clients' contact data in the fields of the Sheet? Thank you.
Can you upload video on search data on Google sheets using html pages
Hello. Thank you very much for the information you have given.
I wanted to know;
Once we fill out the form and send it, we can only print it on the 1st line. Is it possible to print this in a few lines?
For example, a person has 3 phone numbers. I want to write these numbers sub-bottom. Is this possible ?
Thanks so much!
Why would you do it this way rather than by using a google form and connecting it to a google sheet?
HELLO MY FRIEND. Are there any restrictions for GOOGLE APPS SCRIPT as to how many times a script can be called by a website?
THANK YOU
Very useful. Thanks
thankyou so much!!
Boss how to post multi input fields data in multi-row in one column at a time by one clicking?
example: column is "materials" ---items are "shoe, t-shirt, jacket, and so on.
Thank you for the tutorial. It would be interesting if you put your first name, last name and in addition to geolocate your location latitude and longitude and transfer all that to the Google Sheets, can you do it?
01:46 output html
03:10 call .gs function
google.script.run. is unable to call the function. why?
how to add more records sir?
Thread of code, hopefully.
No idea if youtube is going to mess up the tabbing etc.
Hopefully you don't mind. I may not type everything out.
WebApp.html
First Name:
Last Name:
I would put the First-Last Name labels within their own tags too. I don't know how putting the entire line in a paragraph tag affects it completely. Most likely stacks them on top of each other instead of being side by side but it should work.
Example: First Name:
function AddRow()
{
var firstname = document.getElementById("firstname").value;
var lastname = document.getElementById("lastname").value;
google.script.run.AddRecord(firstname, lastname);
document.getElementById("firstname").value = '';
document.getElementById("lastname").value = '';
}
I should mention that I haven't run any of this code yet.
WebApp.html, specifically in the head of the document (in the tag).
Thank you for the tutorial.
Do you have a video on how to extract checkboxes values from each row and update those checkboxes values to the assigned ID into Google Sheets.
Below is an example of HTML table from Web App (the table values 'ID' & 'Name' are extracted from Google Sheets)
ID Name Q1 Q2 Q3 Q4
1 John checkbox1 checkbox2 checkbox3 checkbox4
2 Helen checkbox1 checkbox2 checkbox3 checkbox4
3 Pete checkbox1 checkbox2 checkbox3 checkbox4
I am having an issue with the onclick working, it doesn't seem to be triggering anything in the published Web App, any help would be appreciated. Everything else works great and was easy to follow
I posted the HTML and Javascript Code in the Video. It is in the public comment. Make sure the URL in the google script code is the exact URL to the google sheet you are wanting to copy to. Also, make sure the sheet name in the script code matches the one on the google sheet. I hope this helps.
@@CodeWithCurt In my case I try all this still after clicking on Add nothing happens. Even data is not added. Please help me
Also Please share code
@@suyogsawant5045 Hello, did you find out what was wrong with your code?
@@intrealestate No... Not worked for me in any way.
gracias
The names are not adding to the sheet1
Is the creation date?
Dear Curt,
Great material!
I wonder if you think it'd be possible - if it's legal at all - to create a google web app and rent out the solution by granting access to a 3rd party without them having the possibility to duplicate the app and start using on their own.
If yes, I also wonder if it's possible to create pdfs with a press of a button within the app, to which the user would have access via a shared folder and get it somehow email it to their customer by a couple of clicks. Thanks in advance for your answer!
Yes it's possible
thanks
how to search a particular record from HTML page by Id or Name in googlesheet , html form with text box and search button searching record in Google sheet, Thanking you Lots
superb u rock man, pls help I just want the reverse of this , Data from GoogleSheet being displayed on HTML page one row at a time with next and prev button on html page . Data on spread sheet contains Name , Age , Photograph
exatly the reverse .. from sheet to html