TechLever
TechLever
  • Видео 63
  • Просмотров 243 321
Build CRUD Web App Using Firebase & Google Sheets #firebase #appsscript#firestore
In this comprehensive tutorial, we’ll walk you through the process of building a CRUD (Create, Read, Update, Delete) web application using Firebase and Google Sheets.
🔗 What You’ll Learn:
- How to configure Google Sheets as a dynamic schema and configuration tool.
- Configuring Firebase Firestore 🔥
- Setting up Firestore collections and documents.
- Linking Firebase with Google Sheets for seamless data management.
- Setting up the CRUD App for yourself.
💡 Why Use Firebase & Google Sheets?
Firebase Firestore offers a powerful, scalable, and flexible NoSQL database solution with real-time capabilities.
Google Sheets acts as an easy-to-manage back-end interface, perfect for those who prefer working ...
Просмотров: 725

Видео

How to Manage Client's Projects & Tasks with This Free Web Application | Google Sheets Integration
Просмотров 1,4 тыс.14 дней назад
Welcome to our comprehensive tutorial on using a free web application to effectively manage your clients' tasks and projects. This application is based on Google Sheets and offers a range of customizable features that make client management a breeze. Whether you’re a freelancer, small business owner, or project manager, this tool will streamline your workflow, allowing you to focus on what real...
Google Sheets | Multi Page CRUD Web APPLICATION #appsscript #webapp
Просмотров 2,9 тыс.21 день назад
🚀 Excited to share a tutorial on creating a Multi Page CRUD Web application using Google Sheets! 🌟 What to Expect: Discover how to effortlessly create, read, update, and delete records with just a few clicks! - It also feature File Upload - You can have Dynamic Drop-down list, Dependent Fields and Computed Fields 🔄 Real-time Changes: Witness the magic of real-time changes! Alter settings dynami...
Google Form | Send Email Notification on Google Form Submission #googleform
Просмотров 421Месяц назад
In this video, I will show you how to send email notifications to yourself or your support team when a Google Form is submitted. We will use an 'Issue form' for IT-related issues as an example. This tutorial covers form setup, script editing, and trigger configuration to send notifications to specified email addresses. You'll also see how to customize email templates and handle file uploads. Su...
Google Sheets | Form with Dependent Fields
Просмотров 1 тыс.Месяц назад
In this video I will show you how you can perform data entry in google sheet using a simple HTML form that supports Dependent dropdowns, dependent fields and computed fields. And since the application is fully responsive, you can use this on your mobile device also. You will be able to perform full CRUD operations. Spreadhseet: docs.google.com/spreadsheets/d/14Z_eGMS9qIzhln9E8_HjhzRdcW1DWnI5c7S...
Invoicing Web App using Google Sheet and Apps Script
Просмотров 3,2 тыс.Месяц назад
- Welcome to this comprehensive tutorial on creating a powerful Invoicing Web App using Google Sheets and Apps Script! 🚀 In this video, I'll walk you through the steps to build a fully functional invoicing system that allows you to: - Generate invoices for your clients - Save them in Google Drive - Send them via Gmail Key Features: Clients Tab: Manage all your clients or customers effortlessly....
Google Sheets | Form with multiple files upload using & Apps Script #form
Просмотров 1,2 тыс.Месяц назад
In this video, I'll show you how to upload multiple files or images using a web application, store them in Google Drive, and create related records. Follow along as I demonstrate how to set up the app, configure your forms, and deploy the script. Whether you're managing profiles, uploading documents, or editing records, this tutorial has you covered! Links and References: Spreadsheet Link: docs...
Google Sheets | Dynamic Filtering with Date Ranges
Просмотров 7632 месяца назад
In this video, I'm going to show you how to filter your dataset, especially when it contains multiple date columns. We will take employee records dataset with fields like Name, Date of Joining, Last Promotion Date, and Retirement Date. Our goal is to filter these employee records based on a date range. For instance, we might want to find all employees whose Date of Joining falls within a specif...
How to make Advanced Search Box in google Sheets
Просмотров 6252 месяца назад
In this short video, I will show you how to make your own custom search box to get filtered results. You can either search globally or you can also provide a column where the searches should be performed. Spreadsheet Link: docs.google.com/spreadsheets/d/1BztdRXjrJX4j9dYsDlniRMDqGlHRPYTb_3VypsNCBJU/edit #googlesheets #filters #search
Google Sheets | Display data in a Calendar View #googlesheets#calendar
Просмотров 7052 месяца назад
Hello everyone, In this video I will show you how to display your Google Sheets datasets with date and time fields in a calendar view. I am using the Qalandar package for this. I will be taking help of Data sets like - Events, Tasks, and Sales and display them in a nice calendar view. Spreadsheet Link: docs.google.com/spreadsheets/d/13KtQddExFVDpNH-C0FpKBulZh3BdrprnIB63mjFeVMY/copy Demo Link: s...
Google Sheets | Modal Form with Dependent Dropdown #form #googlesheets
Просмотров 8702 месяца назад
In this video, I will show you how to create dependent dropdown fields in your form using Google Sheets. This tutorial will guide you through the process of populating your Course Sign-up form with data from a Google Sheet. You'll learn how to select a Category and a Course, and see the form auto-populate the price based on your selections. Watch as we fill out the form, hit submit, and see the...
Google Sheets | Automatically Update Google Form #googleform#googlesheets
Просмотров 1,5 тыс.3 месяца назад
In this video, you'll learn how to automatically update a Google Form 📋 from Google Sheets 📊 whenever you make changes. 🔍 What you'll learn: 1️⃣ Link a Google Form to a Google Sheet 📑. 2️⃣ Set up triggers to update the form automatically 🔄. 3️⃣ Edit the script to match your data 💻. ☕️😊 Buy me a coffee! ☕️💖 buymeacoffee.com/pritamsharma paypal.me/pritamsharma45 🔗 Form Link : docs.google.com/form...
Google Sheets | Mail Merge Automation Builder
Просмотров 6233 месяца назад
In this video, learn how to build a Mail Merge Automation to send mass emails automatically using Google Sheets and Gmail. We'll cover creating email automation for scenarios like email marketing and birthday wishes, using custom email templates, and setting up criteria-based email sending. Spreadsheet Link: docs.google.com/spreadsheets/d/1nQ8d3Yliq3EeT16giAygEkFxIL6ey1ipt6PcEWTF1L0/copy Elemen...
Google Sheets | Data Entry using Modal Form #form#dataentry
Просмотров 4,7 тыс.3 месяца назад
Welcome to our tutorial on streamlining data entry with Google Sheets forms! In this video, we'll guide you through the process of setting up custom forms that allow seamless data entry directly into your Google Sheets. We'll start by demonstrating how to create custom forms for different purposes, such as recording profiles, expenses, and sales. You'll learn how to populate dropdown menus in y...
Google Sheets | Generate multiple PDFs using Google Doc
Просмотров 7583 месяца назад
Google Sheets | Generate multiple PDFs using Google Doc
Google Form | Send UPI Payment QR code
Просмотров 9354 месяца назад
Google Form | Send UPI Payment QR code
How to Send Automated Birthday Email (The Easy Way!)
Просмотров 7474 месяца назад
How to Send Automated Birthday Email (The Easy Way!)
Chat GPT and Google Sheet Integration #chatgpt #openai #googlesheets
Просмотров 1 тыс.5 месяцев назад
Chat GPT and Google Sheet Integration #chatgpt #openai #googlesheets
Expense Tracker using Google Sheets and Vue 3 #vuejs #vue3 #googlesheets
Просмотров 1,5 тыс.5 месяцев назад
Expense Tracker using Google Sheets and Vue 3 #vuejs #vue3 #googlesheets
Form with Repeatable Group using Vue JS and Google Sheets | Part-II #vuejs #googlesheets
Просмотров 1,8 тыс.5 месяцев назад
Form with Repeatable Group using Vue JS and Google Sheets | Part-II #vuejs #googlesheets
Form with Repeatable Group using Vue JS and Google Sheets | Part-I #form #appsscript
Просмотров 1,3 тыс.5 месяцев назад
Form with Repeatable Group using Vue JS and Google Sheets | Part-I #form #appsscript
Time Punching Web Application in Google Sheets #googlesheets #appsscript
Просмотров 9715 месяцев назад
Time Punching Web Application in Google Sheets #googlesheets #appsscript
Build Dynamic Digital Catalog with Google Sheets and Drive #googlesheets #imagegallery
Просмотров 2,2 тыс.5 месяцев назад
Build Dynamic Digital Catalog with Google Sheets and Drive #googlesheets #imagegallery
Build Interactive Dashboard in Google sheets #googlesheets #charts
Просмотров 1,1 тыс.6 месяцев назад
Build Interactive Dashboard in Google sheets #googlesheets #charts
Event/Appointment Form | Google Calendar and Google Sheets Integration #googlesheets
Просмотров 1,8 тыс.6 месяцев назад
Event/Appointment Form | Google Calendar and Google Sheets Integration #googlesheets
Web Forms with File Uploads 🔥 using Google Sheets and Google Drive #googlesheets #appsscript
Просмотров 4,1 тыс.7 месяцев назад
Web Forms with File Uploads 🔥 using Google Sheets and Google Drive #googlesheets #appsscript
Seed Google Sheets using Chat GPT #googlesheets #chatgpt
Просмотров 6537 месяцев назад
Seed Google Sheets using Chat GPT #googlesheets #chatgpt
Use INDEX,MATCH and OFFSET Function to Create Dynamic Charts #googlesheets #charts
Просмотров 6337 месяцев назад
Use INDEX,MATCH and OFFSET Function to Create Dynamic Charts #googlesheets #charts
Web Scraping in Google Sheets || IMPORTHTML, IMPORTXML, IMPORTFEED, IMPORTDATA
Просмотров 5 тыс.7 месяцев назад
Web Scraping in Google Sheets || IMPORTHTML, IMPORTXML, IMPORTFEED, IMPORTDATA
🚀Send HTML Email using Google Sheets for Free #googlesheets #newsletter
Просмотров 6627 месяцев назад
🚀Send HTML Email using Google Sheets for Free #googlesheets #newsletter

Комментарии

  • @AnonymousSibugay
    @AnonymousSibugay 6 часов назад

    I have sent you an email.

  • @AnonymousSibugay
    @AnonymousSibugay 6 часов назад

    I have sent you an email.

  • @silvestrecamposano6317
    @silvestrecamposano6317 8 часов назад

    Very nice technique!... Thank you...

  • @DiomarCosta-p1u
    @DiomarCosta-p1u День назад

    I LOVE YOUUUUU

  • @nagarajdoddamani697
    @nagarajdoddamani697 День назад

    it's good. thank you

  • @ShayT9019
    @ShayT9019 4 дня назад

    Very good tutorial, fully understandable, short, perfect video and audio quality.

  • @KateStillman
    @KateStillman 6 дней назад

    I am trying to follow your instructions but the "Script function sendSlackMessage could not be found" when I copied the sheet. There is no script in App Scrips. Is there another way to get the code?

    • @tech-lever
      @tech-lever 6 дней назад

      I checked. The script was attached to the file. Please try again. Maybe you unchecked the ' Copy script' .

  • @brunogennaro9673
    @brunogennaro9673 6 дней назад

    Google just imposed a limit on the number of options that can be added to a Forms dropdown in Apps Script. The limit is currently 1,000. Do you have a solution for me?

    • @tech-lever
      @tech-lever 6 дней назад

      Use custom form instead. See my other videos.

  • @hempiden
    @hempiden 6 дней назад

    This is incredible solution.

  • @user-wi4bq8oc6x
    @user-wi4bq8oc6x 8 дней назад

    tanks sir . but when am finish deply and open url it say (Sorry! You are not authorized to view this web application.) can you help me

  • @chrisder1814
    @chrisder1814 8 дней назад

    hello Can you help me understand if my ideas are feasible?

    • @tech-lever
      @tech-lever 8 дней назад

      Please reach out to me using the contact information given in the description box.

    • @chrisder1814
      @chrisder1814 2 дня назад

      @@tech-lever hello, do you know api connector? do you use AI for coding? can I find "templates" ?

  • @DhruvDua88
    @DhruvDua88 8 дней назад

    Hi Pritam - we are CA firm and need this customized / modified - how can we get in touch to discuss commercials ?

    • @tech-lever
      @tech-lever 8 дней назад

      get contact details from the description box

  • @asambleacristiana6552
    @asambleacristiana6552 9 дней назад

    hi, can u share source code with me? thx a lot

  • @hamisatimuftia5023
    @hamisatimuftia5023 10 дней назад

    This is great ! My further question : 1. For conditional scenario, can we make emailId and Subject are variable/parameterized based on Google Sheets value instead of constant ? I'm envisioning that we can add a new sheets contains table of Department, emailId and Subjects. These sheets act like some sort of email recipient configuration. 2. How to setup if there are multiple recipients in To ? For example, we prefer that the email is sent to multiple email address of support.

  • @HadiSusilo-p2x
    @HadiSusilo-p2x 11 дней назад

    Thank You

  • @hamisatimuftia5023
    @hamisatimuftia5023 11 дней назад

    This is cool ! My questions : 1. How to display completed tasks (automatically shown ticked boxes) in each sheets ? Because your script only import active (not complete) tasks 2. How to refresh the sheets every certain interval time ? Can we use some sort of Trigger ?

    • @tech-lever
      @tech-lever 10 дней назад

      Thanks for the feedback. I will try to do the modification.

    • @hamisatimuftia5023
      @hamisatimuftia5023 10 дней назад

      ​@@tech-lever Thanks ! Please let us know when the modification has been performed.

  • @cubesolver543
    @cubesolver543 11 дней назад

    can you please share how you stored the data of radio button i am getting problem storing radio button data

    • @tech-lever
      @tech-lever 10 дней назад

      I will try to do that. Please check if you have properly set the name attributes. Check MDN docs for Radio buttons.

    • @cubesolver543
      @cubesolver543 10 дней назад

      @@tech-lever sorry for this I Didn't update the URL in google sheet app script which was not allowing radio button data to get stored once again sorry

  • @dapcubalangir5011
    @dapcubalangir5011 11 дней назад

    Awesome . But how can I edit to my entered data later ? And is it a multi user form which can be used at a time by more than 100 people ?

    • @tech-lever
      @tech-lever 10 дней назад

      Plzz check my othere videos title CRUD web app.

  • @englishzeal.website
    @englishzeal.website 12 дней назад

    thanks

  • @OswaldOsorio
    @OswaldOsorio 12 дней назад

    Thank you for sharing your work! I have a formula in several columns in the data sheet and want it to display only in the web application. but every time i tried to edit a record in the web app it causes the formula to disappear in the sheet. Can you help me with this one please?

    • @tech-lever
      @tech-lever 12 дней назад

      You can reach out to me using my contact detail given in the description box.

  • @pawankumarnalla1535
    @pawankumarnalla1535 13 дней назад

    Automatic calendar task and working

  • @pawankumarnalla1535
    @pawankumarnalla1535 13 дней назад

    Intranet project create a video

  • @DrissIxX
    @DrissIxX 13 дней назад

    Hello, it's really amazing . For me im french and in the general details ill prefer choosing , FR , there an posibility for that , please . Thank you in advance and bravo for this work.

    • @tech-lever
      @tech-lever 13 дней назад

      Yes. But that would be chargeable as I will have to modify the code and redeploy. It will cost you 10 USD .

  • @tielcoelecdu4431
    @tielcoelecdu4431 14 дней назад

    I have this error.. Sorry! You are not authorized to view this web application.

    • @tech-lever
      @tech-lever 14 дней назад

      watch video again. You need to append ?u=admin&s=rtx4 to the URL

    • @tielcoelecdu4431
      @tielcoelecdu4431 14 дней назад

      @@tech-lever it's working now thank you savior. this will be big help. subscribed already in your channel

    • @mahimanasa1
      @mahimanasa1 13 дней назад

      Hi Pritam @tech-lever We need some similar solution But fir different purpose, for our organisation. If you are interested to take Job work/freelancing , share tour contact here..Thanks

  • @tielcoelecdu4431
    @tielcoelecdu4431 14 дней назад

    you're an Angel thank you! this helps a lot for me

    • @tech-lever
      @tech-lever 14 дней назад

      Glad it helped!

    • @zohairdilawar116
      @zohairdilawar116 13 дней назад

      Hi Pritam , great video. However i am not doing something right keep getting message 'Sorry you are not authorised ' Do i have to add admin in the code. Gs itself?

    • @tech-lever
      @tech-lever 13 дней назад

      You need to append ?u=admin&s=rtx4 to the URL

    • @tielcoelecdu4431
      @tielcoelecdu4431 9 дней назад

      @@tech-lever Do you have anything for asset management system?

  • @sajinj2457
    @sajinj2457 14 дней назад

    I purchased this application. But I found an error in the dates when trying to edit it after saving. Could you reply to my message?

    • @tech-lever
      @tech-lever 14 дней назад

      Thanks for the feedback. Any issue found within the application will be fixed. Remind me again if not fixed in 2-3 days.

    • @sajinj2457
      @sajinj2457 14 дней назад

      @@tech-lever sure thanks for your response. I will remind you on Sunday /Monday

  • @luisc1402
    @luisc1402 14 дней назад

    So, with this I am using a third party app to process the information in my google sheet no?

  • @memgt9940
    @memgt9940 15 дней назад

    Is it possible to read records from the primary spreadsheet but write a new record to a secondary spreadsheet.

    • @tech-lever
      @tech-lever 13 дней назад

      Not in this project. I can customize it for you. Reach out to me using contact details given in the description box.

  • @philztxr9336
    @philztxr9336 15 дней назад

    not working

  • @techanil6835
    @techanil6835 15 дней назад

    Sir can you show how to create tab level access,that i can share a single sheet which have five tabs with five people's... And each individual can see and edit only the respective tab which has given acces and cant see other tab those all other should be hidden

    • @tech-lever
      @tech-lever 12 дней назад

      You can reach out to me using my contact detail given in the description box. Lets see what can be done.

  • @techanil6835
    @techanil6835 15 дней назад

    Boss you are great....

  • @DroidManiacs
    @DroidManiacs 15 дней назад

    Link is not working anymore

    • @tech-lever
      @tech-lever 15 дней назад

      Ok. I will check that

  • @sajinj2457
    @sajinj2457 19 дней назад

    File uploading pdf is possible?

  • @chrisder1814
    @chrisder1814 19 дней назад

    hello there are still things that I have a lot of difficulty understanding, are you using the API connector extension

  • @KingTseng
    @KingTseng 22 дня назад

    I have pay it from your under link, where can get this code?

  • @user-jh9je4vf3c
    @user-jh9je4vf3c 23 дня назад

    can i edit the app of the language in chinese?

    • @tech-lever
      @tech-lever 21 день назад

      That would be difficult.

  • @sarathkumar-gu7zx
    @sarathkumar-gu7zx 24 дня назад

    Please share how to hide the "the application was created by a google appscript user"

  • @brokenqoutes
    @brokenqoutes 24 дня назад

    Please provide code. Thank you

  • @tech-lever
    @tech-lever 25 дней назад

    This channel needs your support.🙏I post short videos featuring small project giveaways, but it’s challenging to keep the channel sustainable. Therefore, I've set a small price for the projects shown in this video. Your support is greatly appreciated, and perhaps in the future, I can offer these for free. You can get the code here: pritamsharma.gumroad.com/l/fzhnkj

    • @kennethgarcia1178
      @kennethgarcia1178 25 дней назад

      Code please 😢

    • @sajinj2457
      @sajinj2457 19 дней назад

      Nice tutorial. I have requested for customization. Please check your mail.

  • @kennethgarcia1178
    @kennethgarcia1178 25 дней назад

    Code pls

  • @MarieFaubert
    @MarieFaubert 25 дней назад

    Thank you so much !

    • @tech-lever
      @tech-lever 24 дня назад

      I am glad you liked it ☺️

  • @TheFamilyMan-Channel
    @TheFamilyMan-Channel 28 дней назад

    Can't delete data on Clients page, is there a solution?

    • @tech-lever
      @tech-lever 28 дней назад

      Fixed that. Thanks for the feedback.

  • @2010akramkurwy
    @2010akramkurwy 29 дней назад

    hi can you update the code and add search button please .

  • @tech-lever
    @tech-lever 29 дней назад

    const DATA_ENTRY_SHEET_NAME = "Sheet1"; const TIME_STAMP_COLUMN_NAME = "Timestamp"; var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(DATA_ENTRY_SHEET_NAME); const doPost = (request = {}) => { const { postData: { contents, type } = {} } = request; var data = parseFormData(contents); appendToGoogleSheet(data); return ContentService.createTextOutput(contents).setMimeType(ContentService.MimeType.JSON); }; function parseFormData(postData) { var data = []; var parameters = postData.split('&'); for (var i = 0; i < parameters.length; i++) { var keyValue = parameters[i].split('='); data[keyValue[0]] = decodeURIComponent(keyValue[1]); } return data; } function appendToGoogleSheet(data) { if(TIME_STAMP_COLUMN_NAME !==""){ data[TIME_STAMP_COLUMN_NAME]=new Date(); } var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0]; var rowData = headers.map(headerFld => data[headerFld]); sheet.appendRow(rowData); }

  • @AAKASHRAI1000
    @AAKASHRAI1000 Месяц назад

    I have tried hard to do the same but only thing is fetched into the adjacent cell is disappointment

    • @tech-lever
      @tech-lever Месяц назад

      You need to run the script in the editor. That will ask you to authorize the code. Then it will start working.

  • @johnesteban9368
    @johnesteban9368 Месяц назад

    I think there is a problem on deleting the clients? Kindly check it and revise the code if u have time thanks

    • @tech-lever
      @tech-lever 28 дней назад

      Fixed that. Thanks for the feedback.

  • @xanderwork
    @xanderwork Месяц назад

    Thanks! The video is very helpful for beginners!

  • @zohairdilawar116
    @zohairdilawar116 Месяц назад

    Good work

  • @TilakConrad
    @TilakConrad Месяц назад

    super - very nicely done and explained - thank you very much and best of luck with your great channel. Question - why did I get an email from Google saying; File upload limit reached IT - Issue Form has stopped accepting responses. This form supports file uploads and is limited to the collection of 1 GB of files. The file upload limit has been reached, so this form is no longer accepting responses

    • @tech-lever
      @tech-lever Месяц назад

      Prepare your Form from scratch. And transfer all the code from my form to yours and then follow all the instructions. See if that helps. Then I can pin this comment.

    • @tech-lever
      @tech-lever Месяц назад

      Or I think deleting the File upload field and adding a new one can fix it.

  • @giaoanppt6257
    @giaoanppt6257 Месяц назад

    Very interesting project, thank you. You can add a search function and it will be very practical!