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.
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: ...
Click to display a window similar to the one below and you can copy the URL.
For your information.
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
© 2024 OneMinuteCode. All rights reserved.