Using User Interfaces in Spreadsheets and Documents | Google Apps Script for Beginners

Chapter 7. Using User Interfaces in Spreadsheets and Documents

There are many situations where we need to present some data from within a spreadsheet or a document but where the standard user interface is not really appropriate. For example, you have a logging sheet of all the visitors of an exhibition and you'd like to show an average count of the people that were present at this exhibition on a given day. It is of course possible to calculate this in a spreadsheet and decide which cell shows this value, but suppose you want to be able to get some variant of this and get a mean value for the exhibition duration; what are you going to do? Create a new cell with another result, and again come up against the need to add a description cell somewhere for identification purposes.

Let's check out an easier solution for this using what we just learned in the previous chapter.

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Google Apps Script for Beginners

By : Serge Gabet

Google Apps Script for Beginners

By: Serge Gabet

Overview of this book

Chapter 7. Using User Interfaces in Spreadsheets and Documents

Google Apps Script for Beginners

By : Serge Gabet

Google Apps Script for Beginners

By: Serge Gabet

Overview of this book

Chapter 7. Using User Interfaces in Spreadsheets and Documents

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access