This video is a demonstration video on “How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets”. Visit the following link to see the complete blog post at bpwebs.com.
Post Summary
Google Apps Scripts has introduced to increase the power of your favorite Google apps. So, by using Google Apps Script with Google Apps, you can build various types of custom solutions to boost your collaboration and productivity.
In this example, I explained to you how to build an Online Data Entry Form that can Perform CRUD Operations on Google Sheets. Where I used Google Sheets APIs with Google Apps Script HTML service. I have added most of the form elements that required to build most of the forms used in your day to day works. So, you can expand this form to meet your requirements even if you do not have much knowledge of coding.
You can see the live form and the Data Sheet from the following links.
Live Form:
Data Sheet:
You can make copies of the Google Sheet and the Apps Script file described in the video from the following links.
Google Sheet:
Apps Script
If you cannot access the above URL due to the error “There are currently too many people viewing this file” please use the following URL, which is an exact copy of the above Apps Script file.
Tag: google excel online, Google Sheets, Google Apps Script, Apps Script, Data Entry Form, Google Forms Alternatives, Online Data Entry Forms, Online Forms, Productivity, Time Saving, Google Sheet Forms, Free Forms, Free online forms
Xem thêm: https://taichinh4u.net/category/cong-nghe
Nguồn: https://taichinh4u.net
Is it possible to use my own set of IDS???? instead of using the date etc?
How do i modify this so that I can search for a specific person or ID number??? in case i want to edit or just find it???
I have followed your steps but the country name doesn't appear and GetAllData doesn't work
It's a great demonstration.
Let me tell you what I face. I created a new field as you showed "street" it comes ok. But when I edit the data it is not showing what I previously provided. Just a black space we need to provide street address again
It is really good to record data. I follow all yr steps and it works very well for data set up and transfer to worksheet in computer browsers. However, it cannot work in Chrome mobile when it deploy as web app not like you demo file. Can you advise?
Thank you por the script; it would be great if we can implement dependant drop downs and a search button
Creo que el codigo tiene problemas, intento hacer eso de muchas formas pero no me guarda ni me muestra la base de datos. Agradezco tu respuesta y me ayudes, Muchas gracias.
How to give upload document provision in this form ?
Thanks is beatifull, I want to do everything… In spanish please… JJajajaja
great demo thanks for the effort, i tried to copy the code instead and changed the ID for the spreadsheetId and the sheetID to my sheet , but the problem is that still the script cant make any of the CRUD operations I don't know what's missing, any useful hint, please
I like this a lot and was wondering if you or someone could help? I want to do the and thing however I want to perform a vlookup or something like that to autopopulaye the ID for the number given. In other words, each ID is associated with a number, Ex: #5 is associated with the id scmb5765. I want the Id to display when you put the number in just so I can confirm we entry the right info in. How do you integrate that into this?
Cool. Subbing
Thanks bro. I have subscribed to your channel. I ask permission to use one of your source code, I use it to make tutorials on my channel. I got the source code from your website which is entitled "How to create a web form to get data from Google Sheets". I will include your website link in the description column. I will delete the video if you don't give permission. Once again, thank you 🙂
Muchas Gracias! Me Sirvió Mucho para aprender a hacer un Crud con Google App Script. ¿Quisiera preguntar como puedo filtrar la Tabla por pais que se seleccione? Mil gracias muy buen aporte!
I cant copy script, i got the error "There are currently too many people viewing this file. Please try again later." Can u re upload script again? pls . Thanks
How to make form upload image?
Haw to works..
https://youtu.be/bSDiiHQbo3U
تابع هذا الفيديو داش بورد لمتابعة اعمال المشاريع والمقاولات..
Dear Team, Thanks for your Demonstration
Kindly give a solution to include multiple selection drop down option and export selected data to google sheet with separators while click on submit in the above demonstration script
looking your support….
Thank you for this!, ive used it but the only issue I have is when the form inputs a number it attaches an Apostrophe infront of the number in google sheets. This breaks any formula using that field. What do i need to change on the code to make it just enter a number and not the Apostrophe + number?
after submitting i'm getting ( ' ) symbol ,in database how to remove this
Awesome job done. But as i am beginner so it is a little bit of difficult for me to add new columns.
Is this free or paid?
do you do any gig work if so please connect with me, looking for some google sheets help – dharm31@gmail.com
No audio, no video!
CAN'T SUBMIT, GET ALL DATA AND COUNTRY SELECT NOT WORKING!
Please reply u am very mad about to create like this app
Is it free or not
Is it free or paid
Is it possible to apply interactive datatable functionality to the dynamic table. Please help.
where does the ID come from? would you mind to explain?
Thank you for your Effort , very easy to learn