How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets
Вставка
- Опубліковано 5 вер 2024
- 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.
www.bpwebs.com...
Post Summary
Learn how Google Apps Scripts can supercharge your favorite Google apps. With Google Apps Script, you can create customized solutions to boost collaboration and productivity.
In this tutorial, I'll show you how to build an Online Data Entry Form that can add, edit, delete, and retrieve data from Google Sheets. By using Google Sheets APIs and Google Apps Script's HTML service, you'll discover how to create interactive forms for your everyday tasks.
I've included all the necessary form elements you'll need to create various types of forms without requiring extensive coding knowledge. Even if you're not a coding expert, you can easily customize this form to meet your specific needs. Simplify your data entry process and save time with just a few simple steps.
Recommended WordPress Hosting: www.cloudways....
Excellent. I think it will be great if you use sheet form instead of separated application to get benefit of authorization of Google sheet or use login feature if you prefer your tutorial method otherwise anyone with the link can play with the date. No data without security😊
@@rexxelmercado8414 I’m talking about possibility of knowing the link by strangers or any unwanted ppl ?!!
Thank you very much! Great stuff, exactly what I've been looking for
Thank you so much, for sharing the code and your video. helped a lot
Thank you, easy to understand for beginners like me.
How to change the location of the form to above and the input results in the row below where columns are displayed per row max 10 columns and if more than 10 rows, then the remaining data will appear in the rows below in multiples of 10
Thanks a lot Very Useful
great job
I have two questions please.
How do I count the number of rows that are displayed?
And also I would like to have the total of the price column when a selection is made thanks
can someone help me ?
Am looking for a online form solution to read and update a google sheet. I want a form to ask for keyword and select all rows with keyword in column x, then see all occurances and be able to update two cells in each row of the selected items.
With up to 20 people accessing with different keywords.
Will this example above work ?
hello Sir thank you i have question how to delete column delete ?
how to create page navigation for a data table, for example the table displays 10 rows, for the next page another 10 rows. thank you
thank you for awesome work
just a question : can we change the label of each column instead of product name to something else and if we change does it affect the whole webapp ?
Hi @bpwebs
First of all, I would like to congratulate you wholeheartedly for this generous sharing.
I want to adapt the application you shared to my own conditions.
I chose to use the title 'Country' as 'Main Category'. It eliminates the difficulty of updating the category from within the script.
On the home page, under the Main Category box, I want to create a Sub Category that works in conjunction with the Main Category content. It would be very useful if this category data field was from the list in the table, just like "Helpers".
If you have such an application, I would like to reach it. Or if you want to help, I would be very happy. regards
Hello, I want to add a manual date entry field to this form. Can you help me with the code? Thank you in advance
Easy, just like the name field -copy the name field and paste on every section and change name into date , in form change type=text into type=date
Can we search text on 1 column?
Can someone help me here? everytime I change the sheet name and range, the Delete and Edit button do not work, basically my 2 sheets file are the same but have different file name and sheet name
How do you change the title for Product Details and Product details data base to something more fit for your new inputs?
Thanks 🎉🎉
WoW....!!
cant embed this on website. any help?
Replace the doGet() function with the following.
function doGet(request) {
let html = HtmlService.createTemplateFromFile('Index').evaluate();
let htmlOutput = HtmlService.createHtmlOutput(html); // Explicit Conversion
htmlOutput.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
htmlOutput.addMetaTag('viewport', 'width=device-width, initial-scale=1');
return htmlOutput;
}
Read more at: www.bpwebs.com/embed-google-apps-script-web-apps-in-websites/
thanks you sir
hi could you please help me to implement dark theme for this crud operation app
can anybody help me here, i want data table set to populate lost 30 records instead of 10. i tried to edit a part of JS but then data table is showing any data. Also trying to modify it to show in dark theme/ dark background with white text. thanks in advance
hi sir, can you put child rows?
the time record is late for 2hrs and 30mins, how to fix ?
👍 Awesome! 😎
I don't have a website, can I use a local url; how would I point to it? 🤔
TiA! ❤
Its showing can not edit app script.so how we can paste there URL which copied..?
Hey this returns dates with a " ' " in front of it. it's a single apostrophe. my query function in sheets doesn't work with it. how do I get rid of it?
Found the answer. Change "Raw" to "USER_ENTERED" in the CODE.GS. There 2.
Is it possible to sort the "Product Details Database" table in Descending order by the Last Update, so the first row showed is the latest submited?
I think you can achieve this by sorting on the sheet
Hello, is possible to add a highlight in a row/record of various colors dependent on the value in the row/record?
Conditional formatting
Does this work when opening the file from an Android phone???
Try this demo. script.google.com/macros/s/AKfycbxYqPy8kAK3q6y3gQKdJ7nK_uW5MCUVNb5nleB2K3R5AlST5_ybOyUpgI59WQVBDytr/exec
How to make it for multi user
Loading problem
add print option
i need a scrip code please
Can you help me in my script code plss
This dude doesn't answer questions nor respond to his viewers.
Perhaps why he still have less than 3k subscribers despite his great content.