Obtain links from buttons on GAS spreadsheet

Asked 2 years ago, Updated 2 years ago, 62 views

Would it be possible to get the link by creating a spreadsheet and pressing the "Completion Button" in it?

I just started and there were many things I didn't understand, so I asked you a question.
Sorry for the lack of information.
I understand what you want to do, but I don't know how to do that, so please help me.

javascript google-apps-script

2022-09-30 21:27

2 Answers

I have created an example of creating a menu called "View URL" using Google Apps Script.

function onOpen(){
  vars = SpreadsheetApp.getActiveSpreadsheet();
  SpreadsheetApp.getUi()
    .createMenu ("View URL")
    .addItem("View URL", "alertUrl")
    .addToUi();
}

function alertUrl() {
  vars = SpreadsheetApp.getActiveSpreadsheet();
  varurl=ss.getUrl();
  SpreadsheetApp.getUi().alert(url);
}

A menu similar to the following appears: ...
menu screenshot

Click to display a window similar to the one below and you can copy the URL.
Enter a description of the image here

For your information.


2022-09-30 21:27

I'm not sure what the specifications are, but
Maybe Google Apps Script will solve this problem.

See here for button installation
http://stabucky.com/wp/archives/7337

Examples of script construction can be found here.
Obtain the URL of the spreadsheet
http://nevernoteit1419.blogspot.jp/2012/01/idurl.html


2022-09-30 21:27

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.