COMPLETE CRUD WEB APPLICATION USING GOOGLE SHEETS #googlesheets

preview_player
Показать описание
🚀 Excited to share a tutorial on creating a robust CRUD application using Google Sheets! 📊 Join me as we explore step-by-step how to leverage project records for a seamless user experience.

🌟 What to Expect:
Discover how to effortlessly create, read, update, and delete records with just a few clicks! I'll guide you through each operation, showcasing the power of Google Sheets for building functional applications.

🎨 Customization Galore:
Learn the art of customization! Dive into defining the table structure using a schema, tweaking app settings for a personalized touch, and refreshing sheets to keep everything up-to-date.

🔧 Tips and Tricks:
Uncover handy tips, such as utilizing reserved field names for automatic formatting – making your application dynamic and user-friendly.

🔄 Real-time Changes:
Witness the magic of real-time changes! Alter settings dynamically, choose different schemas, locales, and currencies, and see your application transform before your eyes.

🤓 Quick Recap:
In a nutshell, this tutorial offers a comprehensive guide to building a CRUD application in Google Sheets. Save your settings, customize to your heart's content, and happy coding!

******** Support me by buying this with Whatsapp Support just for 10 USD ******
***********************************************************************************

☕️😊 Buy me a coffee! ☕️💖
-------------------------------------------------------------------

🚀💻 #GoogleSheets #CRUDApplication #appsscript #webapp #googleappsscript #dataentry #macros
Рекомендации по теме
Комментарии
Автор

I want to express my sincere gratitude for sharing that incredible tutorial on how to create a CRUD. Your generosity in sharing your knowledge and expertise has been of great help to me. Thanks to your video, I was able to learn and apply the code effectively, and it has made a significant difference in my project.
I'm truly impressed by your dedication to the community and the way you share your programming skills in such a clear and understandable manner. Thank you for being a source of inspiration and for contributing to the growth of the developer community.
Your help has been invaluable, and I'm excited to continue learning from your content in the future!
Thank you once again!. 🙌

RoyerNadian
Автор

if you want to have a dynamic list of values in a dropdown, that gets dynamically updated when new rows are added to a table that its key serves as the foreign key, do as follows: a) define the sheet as a table b) define a NameRange on the column in that sheet c) in the Options column in the Schema sheet for the table that has a foreign key to another table, set the Options value to "=join(", ", NameRange)", where NameRange is the name you defined for in the referenced table

natiperlman
Автор

commendable knowledge and efforts! Highly appreciated

mohdsafwanhussain
Автор

Amazing Tutorial and It's so nice that you have share the link of spreadsheet! thanks a

aakashchudasma
Автор

I want to extend my heartfelt appreciation for providing such an exceptional tutorial on creating a CRUD system. Your willingness to share your knowledge and expertise has truly benefited me. Thanks to your detailed guidance, I was able to grasp the concepts effectively and implement the code seamlessly, leading to significant improvements in my project.

Your commitment to the community and your ability to convey complex programming concepts in a clear and accessible manner are truly remarkable. You serve as an inspiration to aspiring developers and play a vital role in nurturing the growth of the developer community.

I cannot overstate the value of your assistance, and I eagerly look forward to learning more from your insightful content in the future. Once again, thank you immensely for your invaluable contribution!

mfsuperman
Автор

love you a lot ....
I was so excited with the google sheet you shared in the description. It helped me a lot to improve my works. Thanks a lot for the customisable and ready made G Sheet.

VCareSchoolMulad
Автор

Amazing video! you have win a new suscriber!

LuisGGz
Автор

Great work and extremely efficient videos. I am not an expert in all of these stuff but I have some knowledge that allowed me to understand your videos to some good extent. I will wait for a separate video dealing with google calendars with dates and time objects. Thank you once again.

eurekaadvisor
Автор

great tutorial!, just curious what voiceover effect do you use in your videos?

gbvtech
Автор

You are the best. the most exciting tutorial and well explained . Your are too generous to share the code so we can follow and understand how the code works. Thanks a lot

afpd
Автор

O trabalho que postou foi de longe o melhor que encontrei até agora em formulário HTML, parabens! A amabilidade de deixar o ficheiro para ver e editar o código, e entender o que cada parte do script é responsável... fantástico. Já conseguiu um novo seguidor 😅

rubenlopes
Автор

this is just great thanks for sharing this CRUD, but im wonder if this with this code we can add more than one crud at the time for example if a want to use the project y one webapp and another one in the same webapp at the time

djgar
Автор

Thanks tons! The best coding YT video I have seen to learn a particular coding skill.

mingyaozhou
Автор

Congratulation for your big work! Is it possible to set some coloums as not editable but read only, without the buttons “add new item” and “delete”?

brufaman
Автор

It's awesome to look how it works. Can I find the code anywhere?

xulejes
Автор

How clearly the tutorial explains ... thanks

bilimlink
Автор

Thank You So Much for this wonderful video. Can you also show us how to add a download button in Web App so that data can be downloaded in real-time in excel and csv format.

vishalchugh
Автор

This is really great! Thank you! If I like to have two different tables (schemas) in my Web App, what I have to do? If I understood you right, then I only have to insert a second line in the "App Settings"-Sheet with corresponding Schema? First line with idColumn =1 and second line with idColumn = 2?

torsten
Автор

Hi sir, thumbs to this generous piece of work that you’ve made, however just wanted to ask is there an option where it can add restrictions in editing like putting password to edit

KENNETHGARCIA-nvoc
Автор

This looks amazing! One question, so my sheet has around 42 columns and 5000 rows (Columns is fixed, rows is generally between 4000 - 5000)
Do you think if I apply this fix, it would run very slow?

RobotIsaac