COMPLETE CRUD WEB APPLICATION USING GOOGLE SHEETS

  Рет қаралды 66,346

TechLever

TechLever

7 ай бұрын

🚀 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!
🌐 Demo: script.google.com/macros/s/AK...
📊 Spreadsheet Link: docs.google.com/spreadsheets/...
******* Support me by buying this with Whatsapp Support just for 10 USD *****
pritamsharma.gumroad.com/l/wtxnb
***********************************************************************************
***************************
✨ Buy this Advanced version with WhatsApp support for only $10! ✨
It features:
📄 Multi Page Apps
📁 File Uploads
🔽 Dynamic Dropdown
🔗 Dependent and Computed Fields
🖼️ Formatting support for Image, Avatar
➕ Additional fields like Time, Number/Currency, Image
Purchase Link: pritamsharma.gumroad.com/l/fz...
• Google Sheets | Multi ...
***************************
☕️😊 Buy me a coffee! ☕️💖
buymeacoffee.com/pritamsharma
paypal.me/pritamsharma45
-------------------------------------------------------------------
📘 Vuetify Docs: vuetifyjs.com/en/components/t...
📚 Vue JS Docs: vuejs.org/guide/introduction....
📌 Google Apps Script Reference: developers.google.com/apps-sc...
🚀💻 #GoogleSheets #CRUDApplication #appsscript #webapp #googleappsscript #dataentry #macros

Пікірлер: 179
@RoyerNadian1
@RoyerNadian1 7 ай бұрын
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!. 🙌
@tech-lever
@tech-lever 7 ай бұрын
Thank you very much for your kind words. This will really motivate me in creating youtube tutorials😊
@natiperlman9497
@natiperlman9497 23 күн бұрын
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
@mfsuperman
@mfsuperman 5 ай бұрын
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!
@tech-lever
@tech-lever 16 күн бұрын
Thank you very much
@NetMediaCCTV
@NetMediaCCTV Ай бұрын
Thank you for your sharing!
@aakashchudasma6060
@aakashchudasma6060 7 ай бұрын
Amazing Tutorial and It's so nice that you have share the link of spreadsheet! thanks a loooooootttttttttttttt
@tech-lever
@tech-lever 7 ай бұрын
Thanks for your lovely comments 😊. Hope it helps you 🙏
@mohdsafwanhussain7826
@mohdsafwanhussain7826 6 ай бұрын
commendable knowledge and efforts! Highly appreciated
@tech-lever
@tech-lever 6 ай бұрын
Thanks for your beautiful comments 😊
@VCareSchoolMulad
@VCareSchoolMulad 3 ай бұрын
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.
@tech-lever
@tech-lever 3 ай бұрын
My pleasure 😊
@VCareSchoolMulad
@VCareSchoolMulad 3 ай бұрын
Could you add hyperlinked text also in the schema.
@eurekaadvisor1944
@eurekaadvisor1944 6 ай бұрын
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.
@tech-lever
@tech-lever 6 ай бұрын
Thank you very much 🙏. I have noted your video recommendation.
@djgar02
@djgar02 4 ай бұрын
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
@afp2003d
@afp2003d 6 ай бұрын
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
@tech-lever
@tech-lever 6 ай бұрын
Thank you so much 😀. Your comments have made my day.
@gbvtech
@gbvtech 4 ай бұрын
great tutorial!, just curious what voiceover effect do you use in your videos?
@user-cw7sf4js3c
@user-cw7sf4js3c 5 ай бұрын
Thank you
@rubenlopes3570
@rubenlopes3570 5 ай бұрын
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 😅
@tech-lever
@tech-lever 5 ай бұрын
After translating it I found it's highly motivating and encouraging one. Thank you very much.
@hiroyukinumaguchi1984
@hiroyukinumaguchi1984 7 ай бұрын
Thanks! Great!
@tech-lever
@tech-lever 6 ай бұрын
Glad you liked it!
@indexranker
@indexranker 7 ай бұрын
nice1.. very clean... thank you..
@tech-lever
@tech-lever 7 ай бұрын
Thank you very much 😊
@jamirulhisam5582
@jamirulhisam5582 6 ай бұрын
thanks👍
@LuisGGz
@LuisGGz 4 ай бұрын
Amazing video! you have win a new suscriber!
@tech-lever
@tech-lever 4 ай бұрын
Yay! Thank you!
@user-bo8ex4yi5b
@user-bo8ex4yi5b 7 ай бұрын
Absolytely Amazing ! thak you so much
@tech-lever
@tech-lever 7 ай бұрын
Thanks for your lovely comments 🙏😊
@user-wy8rs4qi2h
@user-wy8rs4qi2h 2 ай бұрын
THANKYOU
@brufaman919
@brufaman919 4 ай бұрын
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”?
@bulbulahmed3098
@bulbulahmed3098 5 ай бұрын
great.
@KENNETHGARCIA-nv8oc
@KENNETHGARCIA-nv8oc 2 ай бұрын
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
@theeverydaylife6202
@theeverydaylife6202 3 ай бұрын
Great video. Thanks.
@tech-lever
@tech-lever 3 ай бұрын
Glad you liked it!
@kulvinder8211
@kulvinder8211 6 ай бұрын
i want add one more column for current date and time whenever a new entry is add or old entry is edit ,how is it done ? please give solution .
@malihachape
@malihachape 4 ай бұрын
Thanks so much, truly impressive work, including Search feature. Any way the web results would fit into iPhone screen, e.g. see all the columns on horizontal scrolling (instead of see the whole page on small screen)? I can figure some things out but I'm not a programmer, chatGPT didn't help much and I don't have knowledge to modify bunch of code.
@tech-lever
@tech-lever 4 ай бұрын
I can understand your issue. I am including that in the list of features that will be added in the next version of this project.
@torsten7535
@torsten7535 6 ай бұрын
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?
@tech-lever
@tech-lever 6 ай бұрын
Thank you very much! I really liked your idea. But this version allows you to view only one table at a time. You can only toggle between different tables and related schemas in the App settings. You cannot add more rows to it in the Settings tab. But your idea is great. Maybe in future I will extend this as per your idea and mark it Part-2. You can contact me by email if you need customized solution.
@vishalchugh3575
@vishalchugh3575 4 ай бұрын
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.
@user-xu8le2je5s
@user-xu8le2je5s 5 ай бұрын
It's awesome to look how it works. Can I find the code anywhere?
@eduardopraciano4143
@eduardopraciano4143 3 ай бұрын
Hello, greetings. I'm looking for videos that explain how I can create a logging system, that is, I need that when a user with access to the spreadsheet as an editor makes some insertion, change or even deletes a cell from a specific range of a given tab, this information is written in another tab called: "Logs" where ifnrome the date and time of the event, the user's email and what the status of the action was, whether the content was deleted, inserted or changed. Is there any way you can help me with this?
@user-fd2fk9ti1z
@user-fd2fk9ti1z 5 ай бұрын
Thank you.. how to add upload file questions
@RobotIsaac12
@RobotIsaac12 4 ай бұрын
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?
@mongneverdied1
@mongneverdied1 Ай бұрын
Thank you so much 😎😎😎
@tech-lever
@tech-lever Ай бұрын
Thanks for watching😊
@aarontran6468
@aarontran6468 3 ай бұрын
after i'm deloy, it's blank page. excution log not show any problem. this need any api or something >?
@mingyaozhou4783
@mingyaozhou4783 5 ай бұрын
Thanks tons! The best coding YT video I have seen to learn a particular coding skill.
@tech-lever
@tech-lever 5 ай бұрын
Thank you very much for your kind words.😊
@prooftrans420
@prooftrans420 4 ай бұрын
Can I make a whole school management system following this tutorial? I mean can I make it using 1 spreadsheet or multiple yet connected somehow. Thank you so much.
@airdrop4ufree
@airdrop4ufree 2 ай бұрын
Hi, can you make a tutorial for medical record for patients or database. Thanks
@nunomarques6106
@nunomarques6106 3 ай бұрын
I am having a issue regarding Reset form funtion. i have realized that sometimes when i insert a new record or edit a existent one, the reset form funtion doesn´t work and data from previous record still on form. Does someone had this issue? How do you solve it? Thank You.
@bilimlink
@bilimlink 3 ай бұрын
How clearly the tutorial explains ... thanks
@tech-lever
@tech-lever 3 ай бұрын
Glad it was helpful!
@JayrhomBaita
@JayrhomBaita 2 ай бұрын
May you share your email so I can send you a proposal.
@dfryden234
@dfryden234 5 ай бұрын
This was great. Would there be a way to have some fields appear on the page, but more fields when the edit button is selected?
@tech-lever
@tech-lever 5 ай бұрын
It's possible. But it would require lots of coding changes in the current project. If you have experience in frontend coding then you can do that.
@mohammadsameer4427
@mohammadsameer4427 6 ай бұрын
Sorry but when i clicked on spreadsheet link I am getting sheet with view only options, So i am not able to use as per my need
@Excel-With-Maruf
@Excel-With-Maruf 7 ай бұрын
Thanks For Your Code
@tech-lever
@tech-lever 7 ай бұрын
Thank you! I hope you will find it useful.
@girishyanamala9361
@girishyanamala9361 24 күн бұрын
🎉🎉🎉🎉wow nice
@tech-lever
@tech-lever 23 күн бұрын
Thank you very much for watching. Please share my content. Will be very helpful for new creator like me.
@chrisder1814
@chrisder1814 3 күн бұрын
hello there are still things that I have a lot of difficulty understanding, are you using the API connector extension
@72poligon
@72poligon 6 ай бұрын
👍👍👍
@GalAvraham
@GalAvraham 3 ай бұрын
Thanks for sharing. I might had missed it, but does the server side code is available as well?
@tech-lever
@tech-lever 3 ай бұрын
Yes it does
@jorgebernal3860
@jorgebernal3860 Ай бұрын
this is some great stuff. i am fairly new to this type of coding so was wondering if there is an option to only show certain key items from projectschema tab on the New Item form but still show them all in the web app itself?
@jorgebernal3860
@jorgebernal3860 Ай бұрын
any help would be greatly appreciated
@tech-lever
@tech-lever Ай бұрын
Yes. Its minor modification and it would cost you 15 USD. Whatsapp me. You will find my number in the About me section. OR you can email me.
@nunomarques6106
@nunomarques6106 3 ай бұрын
Hi. Nice work. Is possible to have the list with scroll instead of paging? And it´s possible to add bottons to print, save to pdf and excel? thanks for help.
@tech-lever
@tech-lever 3 ай бұрын
Yes. You can do that easily. Refer the docs for the table provided in the description. For PDF printing - you need to do some further development.
@RameshOrlando
@RameshOrlando 5 ай бұрын
@tech-lever I am learning Vuejs and your spreadsheet app helps me lot with it. Something funky seems to go on with the date field. When I add a new item, the spreadsheet shows the right date but the webapp shows one day less. For instance, if i set the date to 20 Feb for an item, the spreadsheets shows that but the item in webapp shows 19 Feb. I have been trying to figure it out but to no avail. Do you have pointers for me? Also, every time an item is edited, the date seems to get down by one. This seems to happen even your demo link. Is it because of the difference in locale?
@tech-lever
@tech-lever 5 ай бұрын
Check the set locale in your spreadsheet. It should be set to your country. You can do so in the Spreadsheet settings. If still facing the issues then check the buefy docs for the date field and look for locale and then edit the same in the html file. Hope it helps.
@harkesh_rubber
@harkesh_rubber Ай бұрын
This is amazing! Thanks a lot! Can there be a upload option to upload a file insted of a link upload
@tech-lever
@tech-lever Ай бұрын
Thanks. Explore my other videos. There you will find the upload features.
@Arun-dj9ss
@Arun-dj9ss 7 ай бұрын
Hi I am impressed with can you add login and logout system for the same sheet.
@tech-lever
@tech-lever 6 ай бұрын
It would be a lot to do for the short video. You can contact me for customized solution.
@allah-swt
@allah-swt 3 ай бұрын
How could you avoid any random user with the link to edit the database?
@makelifeeasy1917
@makelifeeasy1917 7 ай бұрын
great video dear, thanks
@tech-lever
@tech-lever 6 ай бұрын
So nice of you
@masoomprint
@masoomprint 11 күн бұрын
Please reply me want to custom something
@masoomprint
@masoomprint 11 күн бұрын
@masoomiyat99
@masoomprint
@masoomprint 11 күн бұрын
Instagram
@Ttnit2012
@Ttnit2012 7 ай бұрын
Thank for sharing. I have 1 question, Can I add more columns.
@tech-lever
@tech-lever 7 ай бұрын
Yes. Just make sure to add those col name in scheme also.
@fffff3469
@fffff3469 4 ай бұрын
I've been looking for a sheet like this!😊 Is it possible to add the function to search by label❓
@tech-lever
@tech-lever 4 ай бұрын
Yes. I have planned this in the next version of this project.
@RameshOrlando
@RameshOrlando 5 ай бұрын
Thanks for making and sharing this. Does anyone know how to change the default view to 25 "Items Per Page"? The page defaults to 10 Items.
@RameshOrlando
@RameshOrlando 5 ай бұрын
Figured it out. Inserted ':items-per-page="25" ' in v-data-table before :headers
@BraveHeart-ht8zf
@BraveHeart-ht8zf 3 ай бұрын
surprising sharing, how do you add a column with a formula and the results are displayed without error and if you add key = email, label =?? and must be entered with a valid email
@lazycat836
@lazycat836 4 ай бұрын
Anyone know how to put a password verification on the delete button? So after the yes/no comfirmation window it shows another window where u have to input the correct password to proceed with the delete. It's to prevent people urge to delete everything lol. Also how to make the rating system works instead of fixed values? Really nice template but Im not familiar with coding and vuetify to do these things.
@anindyaputrikinar8955
@anindyaputrikinar8955 2 ай бұрын
Where can I get the code?
@lorvicjohncanete2538
@lorvicjohncanete2538 6 ай бұрын
Hi! I really appreciate you making this one. I have one question though, how i can make the font weight of the table header? I have tried my best to change it but unable to do it hope you can reply to my query.
@tech-lever
@tech-lever 6 ай бұрын
Yes you can!. I will try to take out some time to modify it.
@lorvicjohncanete2538
@lorvicjohncanete2538 6 ай бұрын
@@tech-lever i will really appreciate it, to be honest i am modifying your CRUD tool, to have a timestamp when you add and edit but having difficulties doing so as well as auto populating the email used to access it and record it
@nunomarques6106
@nunomarques6106 3 ай бұрын
How can i change table to scroll instead fo paging? how can i setup height to be auto, adjusting to screen. I used fixed.screen funtions and a height of 600px to test and it worked fine. But in smaller screens its a mess. Thank you for help
@tech-lever
@tech-lever 3 ай бұрын
Instead of pixels do it in terms of vh. Like 0.8vh will be equal to 80 percent of Viewport Height. That way it will become independent of resolution. To remove pagination refer table section of vuetify docs. You will have to use fixed header and remove pagination attribute. Please refer docs.
@nunomarques6106
@nunomarques6106 3 ай бұрын
@@tech-lever Hi. Sorry to bother again but i am not finding where is added the pagination atribute. The viewport is working. Is possible to add sums at the bottom of a column, like in datatables? Thank you so much for you help. Best regards
@iiiyadex
@iiiyadex 2 ай бұрын
I have a question, everytime i insert/delete a form does it affect on the google service quota ? Like what is the limit can i submit or delete a form?
@tech-lever
@tech-lever 2 ай бұрын
There is a quota limit but I have never hit it although I use it pretty much throughout the day.
@bittumonkb866
@bittumonkb866 5 ай бұрын
Incredibile video... ❤❤❤ Instead of changing setting, can i have two html pages, one for project and another for employe details
@tech-lever
@tech-lever 5 ай бұрын
Yes. But it would be difficult in this project. But you can do that if you are experienced frontend developer. I will try to do another part of this video that will extend this project and serve your purpose.
@muhammadzazulirizki1000
@muhammadzazulirizki1000 5 ай бұрын
Hi, I am gonna have a few columns of that will have formula to calculate certain data from other columns. I want them to show up on the web app, but not editable. Is it possible to make it that way? Which part of the code should i tweak?
@tech-lever
@tech-lever 5 ай бұрын
Possible. I have got this in another slightly bigger project. Lets see If I can do codewalk through for that project.
@muhammadzazulirizki1000
@muhammadzazulirizki1000 5 ай бұрын
@@tech-lever that's great! I will wait. One more question, is it also possible to make "dependent drop down list" that will refer to another dropdown? So the goal is to make my employees to be able to choose variants (in the 2nd dropdown) based on selected products (from the 1st dropdown).
@tech-lever
@tech-lever 5 ай бұрын
@@muhammadzazulirizki1000 My next video that I will post within 2 days is featuring dependent dropdowns. You can use that concept.
@muhammadzazulirizki1000
@muhammadzazulirizki1000 5 ай бұрын
@@tech-lever subscribed!
@user-mk9wl7gc6f
@user-mk9wl7gc6f 4 ай бұрын
@@tech-lever Hi, is it is published, what is the name of the video featuring dependent dropdowns? thank you!
@nusratamina
@nusratamina 2 ай бұрын
does it support a login and multi user?
@tech-lever
@tech-lever 2 ай бұрын
Sorry. No.
@kgayken0121
@kgayken0121 6 ай бұрын
I updated mine to work as a purchase order input form. Is there anyway to have the script automatically populate the next available number when a new item is entered?
@tech-lever
@tech-lever 6 ай бұрын
Hi, I have updated the code. You can see the ID column now. Line number 94 and 95 is responsible for adding ID column. You can comment it out If you don't like the ID column.
@kgayken0121
@kgayken0121 6 ай бұрын
@@tech-lever That worked great, but my Id's are in 24-0001, 24-002 etc format. How can I get it to follow the 24-****
@kgayken0121
@kgayken0121 6 ай бұрын
@@tech-lever Never mind i figured it out :)
@abdullahquhtani4247
@abdullahquhtani4247 7 ай бұрын
Excellent and will be great if you could add authentication functionality. How could we exposed sensitive data to others😱
@tech-lever
@tech-lever 7 ай бұрын
You can generate dev link which can be opened by persons with whom you shared the file. No other person can open the link.
@Luc-pj2tv
@Luc-pj2tv 7 ай бұрын
Firstly, thank you for sharing the project. I'm encountering an issue: when I input time data [hh:mm] in the web app, it displays something like this 1899-12-30T00:38:50.000Z. Would you be so kind as to point me in the right direction for time formatting? Thanks again
@tech-lever
@tech-lever 7 ай бұрын
I have not handled Time input. I will update it so that it is able to handle time input correctly. Come in 1 or 2 day so and check in the description.
@Luc-pj2tv
@Luc-pj2tv 7 ай бұрын
@@tech-lever Greatly Appreciated
@muradali3701
@muradali3701 7 ай бұрын
​@@tech-leverthank you sir, I also have same time format issue. Have you update it?
@DSDinternational
@DSDinternational 5 ай бұрын
I watched your video and the demo web page. In Demo, I'm trying field validation. When I create a new item, I leave all fields empty. Even if all the fields are empty, I am able to click the "Save" button. Is this normal? I thought field validation was preventing me from saving. Can you explain to me how field validation and required column in the sheet work ?
@tech-lever
@tech-lever 5 ай бұрын
You are right. It should prohibit form submission. But its easy fix I will do that.
@sivalakshmin
@sivalakshmin 5 ай бұрын
@@tech-lever Waiting for you to fix this validation and required attribute issue. And many thanks for you patience and time.
@Rahul-yv1vr
@Rahul-yv1vr 3 ай бұрын
Hi I have a particular request, I have a web app code made with html css and vanilla js I've got everything working but unable to send the request to update the sheet I was wondering if I could provide you with my web app source code could you help me get it linked and working with Google sheet
@riwayateishq
@riwayateishq Ай бұрын
Did it work out for you?
@Rahul-yv1vr
@Rahul-yv1vr Ай бұрын
@@riwayateishq I already have the form ready but I was unable to send requests to the Google sheet
@ramreddymogiligari
@ramreddymogiligari Ай бұрын
Excellent tutorial. How to prevent users of web app from editing certain fields.pls help me.
@tech-lever
@tech-lever Ай бұрын
For whatsapp support you will have to buy this template. Then I can help you with that.
@ramreddymogiligari
@ramreddymogiligari Ай бұрын
@@tech-lever Thank you for replying. What is the cost of template.
@tech-lever
@tech-lever Ай бұрын
@@ramreddymogiligari Rs 850
@gerd805
@gerd805 4 ай бұрын
Thank you so much, really amazing, but i have i problem, when i edit the item in the web, it become double item with the new information that i add to it, how i can solve this, please help me🙏
@tech-lever
@tech-lever 4 ай бұрын
Then it's a bug. I will check it and fix it. Thanks for bringing this up.
@gerd805
@gerd805 4 ай бұрын
@@tech-leverdont worry sir, i have been figure it out, i make a mistake, i add new data without ID number, so when i edit it, it get double,so your code is fine, 🙏👍👌👌
@5kplamse
@5kplamse 7 ай бұрын
What is the usage of 'Data Entry Sheet' and 'Schema Sheet' inside App settings ? don't get it.
@tech-lever
@tech-lever 7 ай бұрын
It's like you have multiple pairs of data entry sheet and it's corresponding schema sheet in the Same spreadsheet. And then you can choose them in the settings tab. Please watch it one more time. Thanks for taking interest in my video. 😊
@5kplamse
@5kplamse 7 ай бұрын
@@tech-lever appreciate the effort you took to make this video. but for the time being its way beyond my pay grade. i only want a read only template with google sheets as the database, looking through your backend and index html, i have a really hard time figuring out which functions to remove. looks like i still have a lot to learn before i can understand this. but thanks for the info you're putting out there. Keep it coming !
@Kelly-hm4zg
@Kelly-hm4zg 6 ай бұрын
I was wondering if you could let me know what I am doing wrong. Everything is working great but the date. When a new item is entered the date is showing two days prior. ex if 1/23/24 is entered it shows up 1/21/24, but on the google sheets back end it is 2024-01-23
@tech-lever
@tech-lever 6 ай бұрын
It has to do with locale. I will send you the fixes. Remind me in few days...
@Kelly-hm4zg
@Kelly-hm4zg 6 ай бұрын
@@tech-lever Reminder 😀
@RameshOrlando
@RameshOrlando 5 ай бұрын
@Kelly-hm4zg - In your copy of the spreadsheet, go to File, Settings and change time zone to your time zone. Also, all the populated time fields in the spreadsheet will hold the previous GMT+5:30. Delete those fields or delete the entire column (s) and make ones as needed and Save Settings in the App Preferences sheet.
@malihachape
@malihachape 4 ай бұрын
@@RameshOrlandoThanks, that fixed it! I had the same issue, almost gave up on the entire project as correct date is important in my data
@wawanhardian7385
@wawanhardian7385 3 ай бұрын
can i use react js?
@tech-lever
@tech-lever 3 ай бұрын
Definitely.
@Shkur777
@Shkur777 Ай бұрын
Невероятно круто
@tech-lever
@tech-lever Ай бұрын
Thank you very much😊
@linnerskinner9355
@linnerskinner9355 4 ай бұрын
You are my favorite person on the planet
@tech-lever
@tech-lever 3 ай бұрын
Thanks for this beautiful comment.
@kiranarana7274
@kiranarana7274 24 күн бұрын
Can we use on excel?
@tech-lever
@tech-lever 23 күн бұрын
No
@GodisalwaysgoodW
@GodisalwaysgoodW 3 ай бұрын
source file?
@abrahamrubenperezpalmacupe5202
@abrahamrubenperezpalmacupe5202 2 ай бұрын
help me , BAD CODE I CAN EXECUTE IT
@tamminh1494
@tamminh1494 3 ай бұрын
Do you have project on github?
@tech-lever
@tech-lever 3 ай бұрын
You can get the code by making a copy of the Spreadsheet form the link in the description.
@InternetHub13
@InternetHub13 2 ай бұрын
Is there anyway to make it responsive?
@tech-lever
@tech-lever 2 ай бұрын
Yes. If you have got experience in CSS, styling then you can make it responsive. Check out the Vuetify Docs.
@InternetHub13
@InternetHub13 2 ай бұрын
@@tech-lever I have but very minor, just the syntax and CSS understanding. But everything that needs to be changed is only the CSS right?
@tech-lever
@tech-lever 2 ай бұрын
@@InternetHub13 But that will be difficult to implement. I am also not the CSS expert. But responsiveness is handled by CSS only.
@VebyoArson
@VebyoArson Ай бұрын
Would you mind to share the source code..?
@tech-lever
@tech-lever Ай бұрын
Link in the description. And please watch it full to know the instructions.
@SeyhaNget-fp9dx
@SeyhaNget-fp9dx 3 ай бұрын
Dear sir please kindly give me the script.
@ArchithAswath
@ArchithAswath 2 ай бұрын
Can I get the source code please?
@tech-lever
@tech-lever 2 ай бұрын
Get it from the description.
@laurenceosborne4261
@laurenceosborne4261 6 ай бұрын
Can you be hired to build this out into a bigger platform?
@tech-lever
@tech-lever 6 ай бұрын
Yes. I am a freelancer by profession. I generally build much bigger tools. Here I put out smaller versions.
@laurenceosborne4261
@laurenceosborne4261 6 ай бұрын
@@tech-leverhow can I contact you?
@tech-lever
@tech-lever 6 ай бұрын
Email Id in the about section
@tser2784
@tser2784 7 ай бұрын
pls improve to be responsive app ..thx
@tech-lever
@tech-lever 6 ай бұрын
Sure. Will try to get time for that.
@tser2784
@tser2784 6 ай бұрын
@@tech-lever .addMetaTag('viewport','width=device-width , initial-scale=1') and the others vuetify params like expand, think ur more easy to do this. adding multi select also often used by visitor like me. example integrating with jquery amsifySuggestags, thanks for beautifull and flexible coding..❤❤
@susanmast4393
@susanmast4393 2 ай бұрын
OK video but I absolutely hate voice over from AI - so I have to give this a thumbs down.
@tech-lever
@tech-lever 2 ай бұрын
No issue. But I didn't have a choice.
@JayrhomBaita
@JayrhomBaita 2 ай бұрын
May I know your email
@mfsuperman
@mfsuperman 5 ай бұрын
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!
@tech-lever
@tech-lever 5 ай бұрын
Thank you very much for you kind appreciation. You made my day. 😊
Excel | Data Entry using VBA #excel #exceltutorial #dataentry
4:28
Turn Your Spreadsheet into an App
6:58
Prolific Oaktree
Рет қаралды 65 М.
Опасность фирменной зарядки Apple
00:57
SuperCrastan
Рет қаралды 12 МЛН
UNO!
00:18
БРУНО
Рет қаралды 3 МЛН
EVOLUTION OF ICE CREAM 😱 #shorts
00:11
Savage Vlogs
Рет қаралды 12 МЛН
Google App Script crudDaily Received and Expense Web app and Dashboard,
9:24
NEVER install these programs on your PC... EVER!!!
19:26
JayzTwoCents
Рет қаралды 3 МЛН
Web App Example w/ Google Sheets, Tabulator, JavaScript, Apps Script, HTML, CSS Tutorial
2:26:51
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 135 М.
A Star Is About to Explode (And You'll Be Able to See It)
8:45
StarTalk
Рет қаралды 2,4 МЛН
Convert Google Sheets into a REST API
14:10
Better Sheets
Рет қаралды 5 М.
You don't need a frontend framework
15:45
Andrew Schmelyun
Рет қаралды 118 М.
Invoicing Web App using Google Sheet and Apps Script
8:41
TechLever
Рет қаралды 2,2 М.
Опасность фирменной зарядки Apple
00:57
SuperCrastan
Рет қаралды 12 МЛН