![TechLever](/img/default-banner.jpg)
- Видео 63
- Просмотров 243 321
TechLever
Индия
Добавлен 27 окт 2022
👋 At TechLever, we're on a journey to explore the ever-evolving world of Google Sheets, G Suite app development, and web development. Our mission is to provide you with the knowledge and tools you need to excel in these domains.
🔍 What You Can Expect:
Google Spreadsheet Mastery: From basic functions to advanced data manipulation, we'll guide you through Google Spreadsheets, making your work smarter and more efficient.
G Suite App Development: Dive into the realm of app development within the G Suite ecosystem. Learn to create custom solutions, automate tasks, and enhance your workflow.
Web Development Wonders: Stay updated with the latest web development tools and technologies. We'll break down complex concepts and provide practical insights to level up your web development skills.
🔍 What You Can Expect:
Google Spreadsheet Mastery: From basic functions to advanced data manipulation, we'll guide you through Google Spreadsheets, making your work smarter and more efficient.
G Suite App Development: Dive into the realm of app development within the G Suite ecosystem. Learn to create custom solutions, automate tasks, and enhance your workflow.
Web Development Wonders: Stay updated with the latest web development tools and technologies. We'll break down complex concepts and provide practical insights to level up your web development skills.
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 ...
🔗 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
I have sent you an email.
ok
I have sent you an email.
Very nice technique!... Thank you...
Glad you liked it!
I LOVE YOUUUUU
it's good. thank you
Very good tutorial, fully understandable, short, perfect video and audio quality.
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?
I checked. The script was attached to the file. Please try again. Maybe you unchecked the ' Copy script' .
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?
Use custom form instead. See my other videos.
This is incredible solution.
Thank you very much.
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
hello Can you help me understand if my ideas are feasible?
Please reach out to me using the contact information given in the description box.
@@tech-lever hello, do you know api connector? do you use AI for coding? can I find "templates" ?
Hi Pritam - we are CA firm and need this customized / modified - how can we get in touch to discuss commercials ?
get contact details from the description box
hi, can u share source code with me? thx a lot
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.
Thank You
Glad you liked it.
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 ?
Thanks for the feedback. I will try to do the modification.
@@tech-lever Thanks ! Please let us know when the modification has been performed.
can you please share how you stored the data of radio button i am getting problem storing radio button data
I will try to do that. Please check if you have properly set the name attributes. Check MDN docs for Radio buttons.
@@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
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 ?
Plzz check my othere videos title CRUD web app.
thanks
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?
You can reach out to me using my contact detail given in the description box.
Automatic calendar task and working
Intranet project create a video
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.
Yes. But that would be chargeable as I will have to modify the code and redeploy. It will cost you 10 USD .
I have this error.. Sorry! You are not authorized to view this web application.
watch video again. You need to append ?u=admin&s=rtx4 to the URL
@@tech-lever it's working now thank you savior. this will be big help. subscribed already in your channel
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
you're an Angel thank you! this helps a lot for me
Glad it helped!
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?
You need to append ?u=admin&s=rtx4 to the URL
@@tech-lever Do you have anything for asset management system?
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?
Thanks for the feedback. Any issue found within the application will be fixed. Remind me again if not fixed in 2-3 days.
@@tech-lever sure thanks for your response. I will remind you on Sunday /Monday
So, with this I am using a third party app to process the information in my google sheet no?
Is it possible to read records from the primary spreadsheet but write a new record to a secondary spreadsheet.
Not in this project. I can customize it for you. Reach out to me using contact details given in the description box.
not working
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
You can reach out to me using my contact detail given in the description box. Lets see what can be done.
Boss you are great....
Link is not working anymore
Ok. I will check that
File uploading pdf is possible?
Yes.
hello there are still things that I have a lot of difficulty understanding, are you using the API connector extension
I have pay it from your under link, where can get this code?
Did you get the code?
can i edit the app of the language in chinese?
That would be difficult.
Please share how to hide the "the application was created by a google appscript user"
Please provide code. Thank you
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
Code please 😢
Nice tutorial. I have requested for customization. Please check your mail.
Code pls
Thank you so much !
I am glad you liked it ☺️
Can't delete data on Clients page, is there a solution?
Fixed that. Thanks for the feedback.
hi can you update the code and add search button please .
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); }
I have tried hard to do the same but only thing is fetched into the adjacent cell is disappointment
You need to run the script in the editor. That will ask you to authorize the code. Then it will start working.
I think there is a problem on deleting the clients? Kindly check it and revise the code if u have time thanks
Fixed that. Thanks for the feedback.
Thanks! The video is very helpful for beginners!
Good work
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
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.
Or I think deleting the File upload field and adding a new one can fix it.
Very interesting project, thank you. You can add a search function and it will be very practical!