google-places-api

[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?

by

The onOpen trigger in your script is only for adding the Custom Menu in your Sheet. The function will only get executed when the user selected an Item in the menu that is associated with the function. In your example, clicking Get place info will execute the COMBINED2 function. Also, executing the script only when … Read more

[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?

by

Introduction Creating a custom UI button with a growing Google Sheet can be a great way to automate certain tasks and make your workflow more efficient. However, it can be difficult to know how to properly call a function with such a button. In this article, we will discuss the steps necessary to properly call … Read more