How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

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

Пікірлер: 40

  • @insafnureev
    @insafnureev5 ай бұрын

    Thank you very much! Great stuff, exactly what I've been looking for

  • @walidnazmifordigitization5204
    @walidnazmifordigitization520411 ай бұрын

    Thanks a lot Very Useful

  • @SahilKashyap64
    @SahilKashyap645 ай бұрын

    Thank you so much, for sharing the code and your video. helped a lot

  • @MR.WANDERABENEDICTO
    @MR.WANDERABENEDICTO7 ай бұрын

    Thanks 🎉🎉

  • @user-yi4zg8gt3f
    @user-yi4zg8gt3f10 ай бұрын

    thanks you sir

  • @BraveHeart-ht8zf
    @BraveHeart-ht8zf Жыл бұрын

    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

  • @user-pu9cj8xi8n
    @user-pu9cj8xi8n6 ай бұрын

    great job

  • @kazimustafizurrahaman3396
    @kazimustafizurrahaman33966 ай бұрын

    WoW....!!

  • @abdullahquhtani4247
    @abdullahquhtani4247 Жыл бұрын

    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😊

  • @abdullahquhtani4247

    @abdullahquhtani4247

    7 ай бұрын

    @@rexxelmercado8414 I’m talking about possibility of knowing the link by strangers or any unwanted ppl ?!!

  • @SOSSVT
    @SOSSVT11 ай бұрын

    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 ?

  • @4funrc11
    @4funrc1111 ай бұрын

    👍 Awesome! 😎 I don't have a website, can I use a local url; how would I point to it? 🤔 TiA! ❤

  • @_wargasipil
    @_wargasipil8 ай бұрын

    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

  • @mariomarkanders4115
    @mariomarkanders41153 ай бұрын

    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 ?

  • @andrzej9036
    @andrzej9036 Жыл бұрын

    Hello, is possible to add a highlight in a row/record of various colors dependent on the value in the row/record?

  • @pepemiko

    @pepemiko

    10 ай бұрын

    Conditional formatting

  • @abelmrls
    @abelmrls9 ай бұрын

    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?

  • @user-pp4pc4vx9c

    @user-pp4pc4vx9c

    4 ай бұрын

    I think you can achieve this by sorting on the sheet

  • @tpitangerpg
    @tpitangerpgАй бұрын

    hello Sir thank you i have question how to delete column delete ?

  • @fakhrulrazi1578
    @fakhrulrazi1578 Жыл бұрын

    How to make it for multi user

  • @sherwinalfonso6846
    @sherwinalfonso68466 ай бұрын

    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

  • @RajeesRatnam
    @RajeesRatnam25 күн бұрын

    Can we search text on 1 column?

  • @jxhisam
    @jxhisam5 ай бұрын

    hi sir, can you put child rows?

  • @Netajidebade
    @Netajidebade3 ай бұрын

    hi could you please help me to implement dark theme for this crud operation app

  • @Netajidebade
    @Netajidebade3 ай бұрын

    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

  • @rahul_rv15
    @rahul_rv153 ай бұрын

    Its showing can not edit app script.so how we can paste there URL which copied..?

  • @zaccoza
    @zaccoza10 ай бұрын

    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

  • @MytubeEdutech
    @MytubeEdutechАй бұрын

    Loading problem

  • @PrimeRestore
    @PrimeRestore3 ай бұрын

    the time record is late for 2hrs and 30mins, how to fix ?

  • @Bharatiya_Brothers
    @Bharatiya_Brothers2 ай бұрын

    add print option

  • @user-pp4pc4vx9c
    @user-pp4pc4vx9c4 ай бұрын

    cant embed this on website. any help?

  • @bpwebs

    @bpwebs

    4 ай бұрын

    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/

  • @manthanpatel8707
    @manthanpatel8707 Жыл бұрын

    Can you help me in my script code plss

  • @sanahaskuranage8071
    @sanahaskuranage80714 ай бұрын

    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?

  • @sanahaskuranage8071

    @sanahaskuranage8071

    4 ай бұрын

    Found the answer. Change "Raw" to "USER_ENTERED" in the CODE.GS. There 2.

  • @airdrop4ufree
    @airdrop4ufree2 ай бұрын

    i need a scrip code please

  • @dgrolfe
    @dgrolfe2 ай бұрын

    Does this work when opening the file from an Android phone???

  • @bpwebs

    @bpwebs

    2 ай бұрын

    Try this demo. script.google.com/macros/s/AKfycbxYqPy8kAK3q6y3gQKdJ7nK_uW5MCUVNb5nleB2K3R5AlST5_ybOyUpgI59WQVBDytr/exec

  • @ifeanyibarth5137
    @ifeanyibarth51379 ай бұрын

    This dude doesn't answer questions nor respond to his viewers. Perhaps why he still have less than 3k subscribers despite his great content.