How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets
Vložit
- čas přidán 6. 05. 2023
- 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/crud-operation...
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.com/en/?id=156278
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
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 ?!!
Thanks a lot Very Useful
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
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 ?
thanks you sir
Thanks 🎉🎉
great job
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
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 ?
WoW....!!
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
👍 Awesome! 😎
I don't have a website, can I use a local url; how would I point to it? 🤔
TiA! ❤
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
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 could you please help me to implement dark theme for this crud operation app
How to make it for multi user
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 Sir thank you i have question how to delete column delete ?
Can we search text on 1 column?
hi sir, can you put child rows?
Its showing can not edit app script.so how we can paste there URL which copied..?
the time record is late for 2hrs and 30mins, how to fix ?
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.
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/
Loading problem
Can you help me in my script code plss
i need a scrip code please
Does this work when opening the file from an Android phone???
Try this demo. script.google.com/macros/s/AKfycbxYqPy8kAK3q6y3gQKdJ7nK_uW5MCUVNb5nleB2K3R5AlST5_ybOyUpgI59WQVBDytr/exec
add print option
This dude doesn't answer questions nor respond to his viewers.
Perhaps why he still have less than 3k subscribers despite his great content.