How to create Menu bar, Custom Sub Menu bar in Google Sheet Using Apps Script | G-MASTERY AUTOMATION

-


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:

  1. Open the Google Sheet where you want to add the menu bar.

  2. Click on "Tools" in the top menu bar, and then select "Script Editor". This will open the Apps Script editor.

  3. In the Apps Script editor, click on "File" and then select "New Script File". Name the script file something like "Custom Menu".

  4. 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:

  1. Save the script file by clicking on "File" and then selecting "Save". You can name the script file whatever you like.

  2. 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 labeled "Sub Menu" and "Sub-Sub Menu".

  3. When you click on the "Sub-Sub Menu" option, you will see two more options labeled "Sub-Sub Menu 1" and "Sub-Sub Menu 2". You can add your own functionality to each of these sub-sub menus by editing the corresponding functions in the script file.


Comments

Post a Comment

Popular posts from this blog

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
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"
Read more