Posts

-
Image
You can create a menu bar and a custom sub-menu bar in Google Sheets using Google Apps Script. Here are the steps to do that: Open the Google Sheet where you want to add the menu bar. Click on "Tools" in the top menu bar, and then select "Script Editor". This will open the Apps Script editor. In the Apps Script editor, click on "File" and then select "New Script File". Name the script file something like "Custom Menu". In the new script file, you can start by creating a function to add a custom menu. Here's an example code to create a "Custom Menu" with a "Sub Menu" and a "Sub-Sub Menu" in it: Save the script file by clicking on "File" and then selecting "Save". You can name the script file whatever you like. Go back to the Google Sheet and refresh the page. You should see a new menu item labeled "Custom Menu". If you click on it, you will see a sub-menu with two options la
Post a Comment
Read more

Google form basic to advanced full tutorial with description | G-MASTERY AUTOMATION

-
Image
Below are the steps for creating a Google Form from basic to adv anced. This tutorial includes detailed descriptions to guide you throughout the process: Sign in to your Google account and go to Google Forms by visiting this link: https://docs.google.com/forms/ Click the "+" icon in the bottom-right corner to create a new form, which will create a new, blank Google Form. Add a title and description to your form in the "Form description" box. Add a question by clicking on the "Untitled Question" box and type your question. Choose a question type by clicking on the drop-down menu to choose a question type such as multiple choice, dropdown, short answer, paragraph, etc. Add answer choices for some question types, like multiple choice or dropdown, by clicking on the "Add option" button. Customize your question by clicking on the three dots on the right side of the question box to give you options to shuffle answer choices, add an "Other" op
Post a Comment
Read more

How to Submit Custom HTML, Web Apps Script and CSS Form Data to Google Sheets? (With Full Source Code)

-
Image
How to Submit Custom HTML, Web Apps Script and CSS Form Data to Google Sheets? (With Full Source Code). Form: Google Sheet: form.HTML <div class="container">       <div class="row justify-content-center wrapper" id="register-box">         <div class="col-lg-10 my-auto myShadow">           <div class="row">             <div class="col-lg-5 d-flex flex-column justify-content-center myColor p-4">               <h1 class="text-center font-weight-bold text-white">Welcome Back!</h1>               <hr class="my-4 bg-light myHr" />               <p class="text-center font-weight-bolder text-light lead">To keep connected with us please Enter your personal info.</p>                             </div>             <div class="col-lg-7 bg-white p-4">               <h1 class="text-center font-weight-bold text-primary"
Post a Comment
Read more

Collaborating and sharing Google Sheets with others.

-
Image
  Google Sheets makes it easy to collaborate with others and share your spreadsheets with them. Here are some steps to follow: Open your Google Sheet and click on the "Share" button in the top right corner of the screen. Enter the email addresses of the people you want to share your sheet with. You can choose whether to give them editing or viewing access. If you want to add a message, check the box that says "Notify people" and enter your message in the text box. Click on "Send" to share your sheet.
Post a Comment
Read more

Basic functions and formulas in Google Sheets.

-
Image
Google Sheets is a powerful tool for organizing and analyzing data, and it comes with a range of built-in functions and formulas that make it easy to perform calculations and manipulate data. In this post, we'll go over some of the most commonly used functions and formulas in Google Sheets and show you how to use them in your own spreadsheets. SUM Function The SUM function is one of the most basic and widely used functions in Google Sheets. It allows you to add up the values in a range of cells. To use the SUM function, simply enter "=SUM(A1:A10)" into a cell, where "A1:A10" is the range of cells you want to add up. AVERAGE Function The AVERAGE function calculates the average value of a range of cells. To use the AVERAGE function, enter "=AVERAGE(A1:A10)" into a cell, where "A1:A10" is the range of cells you want to calculate the average of. MAX/MIN Functions The MAX and MIN functions allow you to find the highest and lowest values in a range
Post a Comment
Read more