Skip to main content

Transcript

In this video, you will customize the text in the menu, sidebar, and spreadsheet to describe how your guide works.

Since you added a new interactive sidebar to your area guide, it is important that you give viewers clear directions on how to use it.

To begin, open Apps Script if it isn't open already.

Then, find the title "custom menu" in the first part of the code and change it to something fun and descriptive.

For example you might title the menu, Learn More, Cool Stuff to See, or Closer Look.

Anything you type between the single quotation marks will appear in the menu exactly as written.

Come up with your own, unique title that makes users want to find out more.

Try it out.

Save your code and run the onOpen function.

Refresh your spreadsheet and check that the menu looks how you want it to.

Next, change the show sidebar menu item to a more specific title.

Consider a title that describes what happens when they click this menu item, such as "See image." Then, save your code, run it, and check that it worked.

Finally, type a more personal title for the sidebar.

You might say something like "Check this out" or give a short explanation of how to use the interactive image.

Save the code again and check the sidebar title in your spreadsheet.

If there is a typo or your title is too long, adjust your code until you are happy with how it looks.

When you've finished changing the titles in the code, change the heading for the Image Links column to give your users detailed but brief instructions on how the links work.

Now, it's your turn: Change the custom menu titles and sidebar title in Apps Script, save and run your script to make sure your code works, and change the Image Links column heading in the spreadsheet to give instructions to your users.


Instructions

  1. Change the custom menu titles and sidebar title in Apps Script.
  2. Save and run your script to make sure your code works.
  3. Change the Image Links column heading in the spreadsheet so that it gives instructions to your users.