Tech Tricks with Eli
Tech Tricks with Eli
  • Видео 45
  • Просмотров 122 967
Create a Reservation System in Google Sheets (Apps script version)
#google_sheets #googlesheetstutorial #appsscript
Welcome to your channel! In this tutorial, I will guide you step-by-step on how to create a fully functional reservation system using Google Sheets and Google Apps Script. Whether you need to manage bookings for a hotel, restaurant, event, or any other reservation-based service, this tutorial will provide you with all the tools you need.
In this video, you’ll learn:
Setting Up Your Google Sheet:
Creating the necessary sheets and formatting them.
Setting up data validation for user-friendly dropdown menus.
Writing the Apps Script:
How to access the Script Editor and write your first script.
Coding the logic for checking availability and making rese...
Просмотров: 329

Видео

Stock Inventory Management System in Google Sheets
Просмотров 17021 день назад
#google_sheets #inventorymanagementsystem Stock Inventory Management System in Google Sheets In this tutorial, I will show you how to create an inventory management list in Google Sheets. You will learn how to create a simple inventory list that you can filter columns, create reorder alerts, remove products that you don't want to reorder, automatically calculate "inventory value", total invento...
How to Use the Google Sheets Mobile App Like a Pro
Просмотров 9621 день назад
#GoogleSheets #MobileApp Welcome to [Your Channel Name]! In this tutorial, I'll show you how to effectively use the Google Sheets mobile app to manage your spreadsheets on the go. Whether you're new to Google Sheets or looking to enhance your mobile experience, this video has got you covered! ❤️ Link to the Website❤️ sheetfacts.com/ Subscribe link youtube.com/@TechTrickswithEli2023 Related Link...
Build a Habit Tracker in Google Sheets!
Просмотров 134Месяц назад
#googlesheetstutorial #google_sheets #googlesheetstips 🌹Welcome to this tutorial on how to build a habit tracker in Google Sheets! In this video, we'll show you how to create a simple habit tracker that will help you stay on track with your goals. We'll cover how to set up the spreadsheet, add data, and use formulas to track your progress. We'll also discuss some tips and tricks for making the ...
Mastering Page Breaks in Google Docs: The Ultimate Guide
Просмотров 71Месяц назад
#google_docs #pagenumbering #page_numbering In this tutorial video, we will show you how to start page numbering from a specific page in Google Docs. Whether you're working on a lengthy document or just want to add page numbers to a specific section, this step-by-step guide will help you achieve your goal. We'll cover everything from inserting page breaks to customizing the format of your page ...
How to Create an Online Voting Form with Google Forms
Просмотров 129Месяц назад
#google_forms In this tutorial, you're gonna learn to create an electronic voting form in Google Forms and send it to the others. You'll learn how to make the form and then collect the responses. all the responses will be gathered in a spreadsheet that you can count the votes just with one formula. in the end, you can make charts with the votes. ❤️ Link to the Website❤️ sheetfacts.com/ Subscrib...
Color Coding Data in Google Sheets!
Просмотров 1072 месяца назад
#Google_sheets Color Coding Data in Google Sheets! In this tutorial, you will learn how to make your data easier to understand in google sheets. Conditional formatting helps you to easily focus on a specific area. In this video, you'll learn about "Single Color" and "Color Scale". Timestamps 00:00 Intro 00:21 Conditional formatting 00:43 Color Scale 01:45 Single Color 03:32 Wrap up ❤️ Link to t...
Convert Google Slides to Video: 3 Easy Methods
Просмотров 502 месяца назад
#google_slide #googleslidespresentation #googleslides In a world where communication relies increasingly on visual mediums, mastering the art of transforming static presentations into captivating videos is essential. "How to Convert Google Slides to a Video [3 Methods]" offers a comprehensive guide to unleash the full potential of your presentations. With step-by-step instructions and expert ti...
How to create organizational chart in google sheets//Easy Method!
Просмотров 2103 месяца назад
#google_sheets #org_chart How to create an organizational chart in Google sheets//Easy Method! In this video, I'm going to show you an easy way to create an organizational chart in Google Sheets. This is a great way to keep track of your team's progress and track your performance. If you're looking for a simple way to create an organizational chart in Google Sheets, then this video is for you! ...
The Quick and Easy Way to Create a Table of Contents in Google Docs
Просмотров 1423 месяца назад
#google_docs #tableofcontents This video will show you the quick and easy way to create a table of contents in Google Docs. We'll go over how to set up the table of contents, how to add headings and subheadings, and how to customize the look of your table of contents. We'll also discuss some tips and tricks for making sure your table of contents is organized and easy to navigate. Finally, we'll...
How to Add Sub-Questions Based on Answers in Google Form
Просмотров 6413 месяца назад
#googleform #subquestion In this tutorial, you will learn how to sub-question in the google form. when you create a sub-question, you can have questions based on the answers. In this video, you will learn how to divide a form into sections. each section has its own page and when you answer the first question, the other questions will be shown based on the answer. ❤️ Link to the Website❤️ sheetf...
Creating a fillable form in Google Docs
Просмотров 2013 месяца назад
#google_docs #googledocs #googledocstutorial Creating a fillable form in Google Docs! Hi friends, in this tutorial I will show you how to create a fillable form with a date picker, Image, short answer, and checkboxes in Google Docs. you can share your form with people and groups or can get the link and send it to the applicants. Timestamps 00:00 Intro 00:48 Blank google docs 01:10 Header 01:50 ...
A Step-by-Step Guide to Auto Incrementing Numbers in Google Sheets
Просмотров 1944 месяца назад
#google_sheets #googlesheetstutorial #googlesheets Welcome to this tutorial on how to auto-increment numbers in Google Sheets! In this video, we'll show you how to quickly and easily add a sequence of numbers in Google Sheets. We'll go over the basics of setting up an auto-incrementing number column, as well as some more advanced techniques for customizing your auto-incrementing numbers. We'll ...
How to Create a Gantt Chart in Google Sheets
Просмотров 1944 месяца назад
#google_sheets #ganttchart In this tutorial video, you will learn how to create a Gantt chart in Google Sheets. A Gantt chart is a powerful tool for project management that helps you visualize the timeline of your project and track progress. With Google Sheets, you can easily create a Gantt chart that is customizable and easy to update as your project progresses. This step-by-step guide will wa...
How to Share Only One Individual Sheet Tab in Google Sheets
Просмотров 4264 месяца назад
#googlesheetstutorial #google_sheets #googlesheets In this tutorial, I will show you how to share only one sheet in Google Sheets. Usually, when you share a Google Sheet, you share the entire document, but in some situations, you may need to share only one sheet or tab. Let’s see how to do this. Timestamps 00:00 Intro 00:22 Importrange Function 02:50 Wrap up ❤️ Link to the Website❤️ sheetfacts....
Searchable Drop-Down list in Google Sheets
Просмотров 7445 месяцев назад
Searchable Drop-Down list in Google Sheets
How to start page numbering from a specific page in Google Docs
Просмотров 1195 месяцев назад
How to start page numbering from a specific page in Google Docs
Move and Copy the Entire Row to another Sheet Based on Date in Google Sheets
Просмотров 4896 месяцев назад
Move and Copy the Entire Row to another Sheet Based on Date in Google Sheets
How to Move the Row Based on a Drop-down List in Google Sheets
Просмотров 1,2 тыс.6 месяцев назад
How to Move the Row Based on a Drop-down List in Google Sheets
Import Excel File to Google Sheets [Without Losing Format]
Просмотров 8376 месяцев назад
Import Excel File to Google Sheets [Without Losing Format]
How to Create Resume in Google Docs
Просмотров 926 месяцев назад
How to Create Resume in Google Docs
Advance Google Sheets Search Box! [Apps Script]
Просмотров 1,7 тыс.7 месяцев назад
Advance Google Sheets Search Box! [Apps Script]
How to Insert a Video in Google Slides
Просмотров 997 месяцев назад
How to Insert a Video in Google Slides
Move entire row from one sheet to another sheet based on checkbox
Просмотров 3 тыс.8 месяцев назад
Move entire row from one sheet to another sheet based on checkbox
How to submit HTML form data to Google spreadsheet
Просмотров 5 тыс.8 месяцев назад
How to submit HTML form data to Google spreadsheet
How to Automatically Send Email from Google Sheets
Просмотров 4858 месяцев назад
How to Automatically Send Email from Google Sheets
How to Create a Simple Calendar for 2023 in Google Sheets [no function and formula
Просмотров 4308 месяцев назад
How to Create a Simple Calendar for 2023 in Google Sheets [no function and formula
Google Sheets Sync Data from One Sheet to Another
Просмотров 3 тыс.8 месяцев назад
Google Sheets Sync Data from One Sheet to Another
How to Resize Rows and Columns in Google Sheets [Manually and Automatically]
Просмотров 1,7 тыс.9 месяцев назад
How to Resize Rows and Columns in Google Sheets [Manually and Automatically]
How to create a data entry form in Google Sheets [with multiple databases]
Просмотров 69 тыс.9 месяцев назад
How to create a data entry form in Google Sheets [with multiple databases]

Комментарии

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

    Very voice is very irritating! sorry mam

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

    ❤❤❤

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

    ❤❤❤

  • @OsmanGani-oz8vx
    @OsmanGani-oz8vx 5 дней назад

    Useful Video.

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

    The tutorial is good. But I am making a different data base. If you can show how you do the formula with (ID#,Name,Mobile#,Date Start and Date End. I will highly appreciate. You explain everything cleary and I learned. 😊 Except for the formula, as I have zero knowledge on this. 😅

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

    would this work if I just want to copy the row but NOT MOVE IT?

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

    thanks

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

    i cant use the code 😢

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

    a very nice tutorial - clear and well delivered - congratulations and thanks very much. Question - looked for the link to code/template - looked on your site also and couldn't find - best of luck with your great channel

  • @krishnasoni4745
    @krishnasoni4745 17 дней назад

    VERY HELPFUL ❤ THANK YOU

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

    thank you for this great tutorial! helped me a lot!

  • @majeyafe
    @majeyafe 23 дня назад

    it worked perfectly! i have a question, i added a dropdown instead of a blank box, but i want to add another dropdown with different words, how can i add the other one to the formula? :(

  • @prof.-swapnil6377
    @prof.-swapnil6377 25 дней назад

    Thanks

  • @SubramanyamGaddam
    @SubramanyamGaddam 26 дней назад

    Good morning. Its great tutorial. I am from India

  • @JimBell20
    @JimBell20 26 дней назад

    This only works if there are no blank cell in the data range.

  • @efg1884
    @efg1884 29 дней назад

    ❤❤❤❤❤

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

    Why does mine don't have any option button to allow access?

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

    Thank you!

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

    I've paid to get the data and cannot download the spreadsheet. Please advise where I can find it. Thanks!

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

      Hi, are you sure you made the purchase correctly? If yes, don't worry. Please send me your purchase information so that it can be checked and the files will be emailed to you❤🌹

  • @h.m.arifulislam9893
    @h.m.arifulislam9893 Месяц назад

    Hi, I am Ariful, I very impress your tutorial. please share your script function.

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

    Nice class...mam I want source code ....

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

    Thanks for your efforts.

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

    Thank you very much. I appreciate your effort. Your effort deserves appreciation.

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

    Thank you very much. I appreciate your effort. Your effort deserves appreciation.

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

    Thank u madam 🎉❤

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

    Can I have the link to the spreadsheet please?

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

    Does javascript works in this type, i think it is not.......i have created a html form which having js fuctions in script tag . Do they work if i follow this way???

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

    Hey there can you help me create my company product database inventory from in google sheets

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

    Hey there can you get data entry from source code

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

    Great Content with the talking sound miaw miaw miaw🐭 I'll practice what you taught.

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

    Thanks simply clean explanation but code is not free

  • @muraly3523
    @muraly3523 2 месяца назад

    Great❤

  • @yamilexamador-maldonado9544
    @yamilexamador-maldonado9544 2 месяца назад

    Whenever I type in any of my values to search, I get all my results from my database sheet instead of just what I'm searching up. Any help on why this might be happening?

  • @petercharney9356
    @petercharney9356 3 месяца назад

    I like the content, the clicking sound though is way to aggressive for me and resulted in really skipping a lot of parts of the video

  • @prasaddaware1221
    @prasaddaware1221 3 месяца назад

    Go Green 🍏

  • @prasaddaware1221
    @prasaddaware1221 3 месяца назад

    💚💚💚💚

  • @damianos.2954
    @damianos.2954 3 месяца назад

    Very nice and clear explanation. Thank you!

  • @md.solayemanislam1669
    @md.solayemanislam1669 3 месяца назад

    Really helpful...

  • @teguhmantapu01mantapu6
    @teguhmantapu01mantapu6 3 месяца назад

    Hi there, been watching Your vid, i found something strange on the Advance Google Sheets Search Box! [Apps Script], i did all the same thing/stuff on your spreadsheet, even making the same table lay out, but still when i click the search button and script running, it doesn't show (var s = (8 + cont).toString(); ) value as it display nothing on row 8++ and the link of your spreadsheet can't be accessed/died link

  • @shafeekshefe8093
    @shafeekshefe8093 3 месяца назад

    Hi Can you help me How can i make it different work book

  • @zhillaburns1160
    @zhillaburns1160 3 месяца назад

    Your voice is not clear.

  • @rightfitresources
    @rightfitresources 3 месяца назад

    Please create ATS( application tracking system) by Google sheets,

  • @shafeekshefe8093
    @shafeekshefe8093 3 месяца назад

    Thanks its working great 🎉

  • @suzu_1848
    @suzu_1848 3 месяца назад

    It took me for a day to work my sheet properly. Thank you so much for the instructions!❤

  • @prasaddaware1221
    @prasaddaware1221 3 месяца назад

    Hiii frndss💌💌💌💌

  • @kevinmiranda1079
    @kevinmiranda1079 4 месяца назад

    hi, i ordered the template through your link and i havent received it, can you help me with this

  • @prasaddaware1221
    @prasaddaware1221 4 месяца назад

    Hey Friend, Really Helpful & Quality Content. Stay Motivated & Be consistent! Friends?🫶🤜🤛

  • @geofoods2917
    @geofoods2917 4 месяца назад

    I Guess the title of the video was jumbled, could have been the chart instead of auto email. Nice videos though....

  • @kynistrong683
    @kynistrong683 4 месяца назад

    Hello! How would you adapt the code if you wanted to keep the original data present on the original sheet , but have it hidden. (i.e for your example keeping the data present on the to do list sheet just hidden rather than cut completely) and simply duplicate the data into a new sheet (i.e. having the same data present on both sheets) ?